This course provides a broad foundation in Web site development using PHP and MySQL. Students learn how to develop dynamic Web site features using PHP and MySQL. Working step-by-step, students learn how to set up and configure a Web site as well as a development site for PHP development, design and build a MySQL database and write basic SQL queries, write basic PHP scripts to collect and process information from forms, troubleshoot and fix common PHP scripting errors, write scripts to store information in a database, and display dynamic information on multiple pages within a site. Students also learn to create an online catalogue that displays product information pulled from a database and build a foundation for developing online customer accounts, mailing lists, user polls, forums, shopping carts, and more.
HTML and CSS Essentials and Dreamweaver 1 courses or equivalent experience. Strong experience and comfort in hand-coding HTML and CSS is recommended for this course.
A Student Guide is provided for this course. Evaluation is based solely on an Academy of Learning Career College final exam. Prior to taking the final exam, students must successfully complete all the components of the online course material. Participants who receive 75% or higher on their exam will receive a certificate.
- Lesson 1:
Intro to PHP; Dynamic Web Development Environment; How PHP Works; The Anatomy of a Work Environment; Setting Up Your Development Environment
- Lesson 2:
Building and Using MySQL Databases; How MySQL Works; Getting Access to MySQL; Designing a Database; Building the Database; SQL Queries
- Lesson 3:
Collecting Information in a Form; Displaying a Simple Form in a Web Page; Writing PHP Scripts; Using PHP Variables for Dynamic Information; Storing and Displaying Information; Organizing Scripts; Understanding PHP Error Messages; Processing Information Collected in a Form
- Lesson 4:
Processing Information from a Form; Displaying Information from a Form; Processing Form Information; More About the Logic Script; Checking the Format of the Information
- Lesson 5:
Interacting with the Database; Connecting to a MySQL Database; Storing Data in the Database; Building Dynamic Forms; Developing a Web Application
- Lesson 6:
Working with Multiple Page Web Sites; HTML Pages Don’t Remember; Navigating Web Sites with Multiple Pages; Passing Information from One Page to the Next; Making Information Available to All Pages in the Web Site; Organizing Your Multipage Web Site; Creating Your Own Functions; Miscellaneous PHP Goodies