Richland College Multimedia Learning Center
Digital Media Programming with PHP and MySQLDigital Media Programming with PHP and MySQL -- IMED 2351 -- Section 83701
Instructor's name: Jim Link
Instructor's e-mail: jlink@dcccd.edu
Instructor's vitae
Spring 2020
Wednesdays, 5:40pm to 9:30pm, Room T223
January 29 to May 13, 2020
The instructor will send an e-mail to the class's registered students at the beginning of the first week of class, to provide a welcome and some instructions.
Course description:
Introduction to Web page programming with the PHP scripting language and the MySQL database system.
PHP is one of the easiest and most flexible languages used to create dynamic or database-driven Web pages. In this class we will show you the fundamental concepts of programming, using PHP as our programming language/system. You will learn how to design, create, and manage a MySQL database, and to use PHP Web pages to manage and display the information in the database.
By the end of the class, you will be able to create Web pages that automatically update themselves from a database; that send e-mails using the server instead of a client (local) e-mail system; validate and save form data to a database; and manage and validate username and password for site access. You will also be able to create and manage your own database, and use the SQL database query language. And you will have the basic skills to create an e-Commerce site, if you add a lot of time and effort after/outside the course.
Course Outline:
- Introducing PHP
- Debugging and DreamWeaver
- Variables and Input
- Conditions and Functions
- Loops and Arrays
- Working with Files and Cookies
- Building a Database, and SQL Queries
- More About SQL Queries
- Changing a Database's Contents with PHP
- Database Security
- Form Validation
- Introduction to Codeigniter
- Introduction to PHP and AJAX
- XML and CMS