Online PHP Course
Dynamic Web Development with PHP
The Web today is an increasingly dynamic environment. PHP, in conjunction with the database MySQL, is the leading technology used to build millions of dynamic Web sites. In this online PHP course, you'll learn how to develop dynamic Web site features using PHP and MySQL. Working step-by-step, you'll learn how to: set up and configure a Web site and 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.
Learn the basics of coding with PHP and MySQL
Learn at Your Own Pace
1 - Intro to PHP
In Lesson One, you'll learn the basics of how dynamic sites work. You'll explore the differences between static and dynamic sites and the benefits of using PHP and MySQL. You'll learn how to add PHP code to a Web site, and examine how PHP files are processed by a server. To prepare you for PHP development, you'll learn how to install your development environment (on your Mac or PC), and make existing sites dynamic in Dreamweaver. You'll write a basic PHP script and configure your Web site and development site for PHP.
Project - Publish PHP page
2 - Building and Using MySQL Databases
Most dynamic Web sites need a backend database. A database contains information that is displayed to users online, such as product information in a catalog. Lesson Two explores how to design, build, and access a MySQL database for a dynamic site. The lesson begins by explaining how MySQL works and showing how to access a MySQL database using a cPanel and phpMyAdmin. Next, you'll explore the basics of database design, learning how to define required information and structure database tables. Using phpMyAdmin, you'll learn to build a database and write SQL queries to add, retrieve, change, and remove data from it, as well as back up the database to your local development environment.
Project - Write SQL queries
3 - Collecting Information in a Form
Lesson Three focuses on the challenge of writing PHP scripts to display dynamic forms. You'll begin by learning how to separate logic and display code in your PHP scripts and comment your code. Then you'll learn how to name, create, and assign PHP variables as well as check their contents and explore how to store information as character strings and numbers and display it using echo statements. In the second half of the lesson, you'll connect what you've learned to more complex forms, learning how to organize scripts using display and logic scripts and how to walk through an array. To combat inevitable scripting errors, you'll learn how to interpret and act upon common PHP error messages.
Project - Create a form
4 - Processing Information from a Form
Dynamic Web pages essentially collect information from visitors in HTML forms and respond to that information. Lesson Four discusses how to write scripts to process information submitted in a form, checking its format, and redisplaying the form when information is missing or invalid. During the lesson, you will learn how to use variables and functions to set up conditions and write if statements. Various tasks including comparing values, testing variable content, and pattern matching are discussed and then explored in the context of processing form information.
Project - Form validation and processing
5 - Interacting with the Database
The database is the center of your dynamic Web site, whether you want to display information from your database on your Web page or store information in your database that you collect in a form. Lesson Five focuses on using PHP to interact with a MySQL database. You'll learn how to set up different levels of user account, using hostnames, passwords, and account privileges, so that you can connect to a MySQL server. You'll discover how to write PHP scripts to store data, protecting yourself against damaging queries. Then you'll explore how to retrieve data from the database and display it, using different kinds of loops and displaying several rows if needed. You'll also focus on the challenge of building dynamic forms—forms whose structure and content is defined by data in a database.
Project - Login application
6 - Working with Multiple Page Web Sites
Project - Online catalog display
- Identify the differences between static and dynamic Web design and the specific benefits of using PHP and MySQL.
- Install a development environment on a Mac or PC, make an existing sites dynamic in Dreamweaver, and configure a Web site and development site for PHP.
- Grasp the basics of how MySQL works and and access and manipulate a MySQL database using a cPanel and phpMyAdmin.
- Implement a basic database design, defining required information and structuring database tables appropriately.
- Build a database using phpMyAdmin and write SQL queries to add, retrieve, change, and remove data from it.
- Back up the database to your local development environment and restore it to a live site using phpMyAdmin.
- Write basic SQL queries for typical customer information requests.
- Name, create, and assign PHP variables and check their contents.
- Use PHP to store information as character strings and numbers and display it using echo statements.
- Organize your scripts for easy development and maintenance.
- Interpret and debug common PHP error messages.
- Use variables and functions to set up conditions and write if statements.
- Write scripts to process information submitted in a form, check its format, and redisplay the form when information is missing or invalid.
- Set up different levels of user account, using hostnames, passwords, and account privileges, to connect to a MySQL server.
- Write PHP scripts to store data collected in HTML forms, protecting a site against SQL injections.
- Write scripts to retrieve data from a database and display it on a Web page.
- Build a basic dynamic form that pulls date and time information from a database.
- Use PHP to move users to a different page, pass information from one page to the next, and display information throughout a site.
- Write basic PHP functions to perform repeated tasks.
- Build an online login application.
- Write an application to display an online catalogue.
Interested in this course? Self-paced enrollment options are available.
|Course Level||Classes start||Registration Fee||Technology Fee||Tuition|
60 hour course, 3 months access
|Enroll today, start tomorrow||$50||$25/course||$924|
|* Registration fees are nonrefundable after 5 days from enrollment. All tuition includes a digital materials fee for updates to course or program content.|
Software and Supplies
To take this course you'll need:
- Computer with Internet connection.
- Strong experience and comfort in hand-coding HTML and CSS, including ability to code the different types of HTML form fields.
- Adobe Dreamweaver and basic Dreamweaver experience.
- An account with a Web hosting provider with access to PHP and MySQL.
Important: This course is quite technically challenging. Students entering this class should have a strong experience and comfort with hand-coding HTML and CSS and experience with basic site development in Adobe Dreamweaver.