Course Topics: 15

Estimated Time Needed: 43 hour(s)

Audience: This course is for anyone who would like to create dynamic Web sites using PHP and MySQL.

Course Description: This online course teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.

Course Tutorials Include:

Time: 2 hour(s)

PHP and MySQL: 1 Installing Required Software

Description

After taking this course, the learner will be able to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.

Objectives

• To install and configure MySQL
• To install and configure Apache with PHP
• To create MySQL users and grant privileges
• To test PHP and MySQL installations
• To configure PHP

Time: 3 hour(s)

PHP and MySQL: 2 PHP Basics

Description

After taking this section, the learner will be able to describe the PHP scripting language, and create basic PHP scripts using proper PHP syntax.

Objectives

• Identify basic PHP syntax
• Create basic PHP scripts
• Send data to the Web browser
• Apply variables, strings, and constants to a PHP a script

Time: 4 hour(s)

PHP and MySQL: 3 Programming with PHP

Description

After taking this section, the learner will be able to create elaborate scripts, write HTML forms, and program PHP to handle the form data.

Objectives

• Handle HTML forms using PHP scripts
• Validate form data
• Manage arrays using various types of loops
• Work with magic quotes

Time: 3 hour(s)

PHP and MySQL: 4 Creating Dynamic Web Sites

Description

This section provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that are responsive to users and can alter content based on differing situations.

Objectives

• Create PHP scripts using multiple files
• Display and handle HTML forms within a single PHP script
• Create and call functions
• Create functions that take arguments and return values
• Set and alter variable scope
• Send email from a PHP script

Time: 4 hour(s)

PHP and MySQL: 5 SQL and MySQL

Description

After taking this section, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.

Objectives

• Choose column types and other column properties
• Create databases and tables
• Insert records, select, update and delete data
• Use conditionals and functions

Time: 3 hour(s)

PHP and MySQL: 6 Advanced SQL and MySQL

Description

After taking this section, the learner will be able to use the principles of database design, including normalization and use of forms. They will also be able to use MySQL to create relational databases, and perform searches on those databases.

Objectives

• Normalize a database into First, Second and Third Normal Forms
• Create and populate a database in MySQL
• Search a database using joins, groupings, and FULLTEXT searches
• Change the search engine type of a table
• Create indexes to improve the ability to search a database

Time: 2 hour(s)

PHP and MySQL: 7 Error Handling and Debugging

Description

This section provides the learner with the steps and tools necessary to identify and correct errors that can occur when running PHP and MySQL applications.

Objectives

• Identify error types
• View, log, and debug errors
• Adjust PHP's error reporting
• Create custom error handlers

Time: 2 hour(s)

PHP and MySQL: 8 Using PHP with MySQL

Description

This section provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that allow for database interactions such as the storing, gathering, and updating of information.

Objectives

• Describe how arguments and PHP functions relate to the database
• Differentiate between simple and complex functions depending on execution results
• Understand the importance of associative and indexed arrays.
• Modify specific scripts to allow for secure data transmission
• Update database records using PHP scripts

Time: 2 hour(s)

PHP and MySQL: 9 Developing Web Applications

Description

This section provides the learner with information about a number of independent topics that are present in more sophisticated Web applications.

Objectives

• Adjust behavior for server settings
• Pass variables and values to a script
• Edit existing records
• Paginate query results
• Make sortable displays
• Use HTTP headers

Time: 3 hour(s)

PHP and MySQL:10 Cookies and Sessions

Description

This section provides the learner with information about using cookies and sessions with PHP to overcome the statelessness of the Web.

Objectives

• Use cookies
• Use sessions
• Improve session security
• Manage the relationship between cookies and sessions

Time: 3 hour(s)

PHP and MySQL:11 Web Application Security

Description

In this section, the learner will become familiar with methods for increasing the security of their web applications using PHP and MySQL. These techniques include methods of form validation, the ability to define patterns and then matching or replacing those patterns, and data encryption.

Objectives

• Prevent forms from being submitted multiple times
• Validate form data
• Define patterns and both match and replace them
• Manage database encryption and decryption techniques

Time: 4 hour(s)

PHP and MySQL:12 Extended Topics

Description

This section covers extended PHP topics that are worth considering in your development work, but not related to every Web application.

Objectives

• Upload a file in PHP
• Develop JavaScript using PHP
• Utilize output buffering
• Identify Improved MySQL Extension functions
• Describe the purpose of PEAR

Time: 2 hour(s)

PHP and MySQL:13 Content Management Example

Description

After taking this section, the learner will become familiar with the foundational information required to build a sample content management site through PHP interactions using a database.

Objectives

• Create the advanced PHP scripts needed for a content management site
• Update and add information with a database
• Download files through PHP scripts and database interactions
• Manage files through PHP scripts and database interactions

Time: 3 hour(s)

PHP and MySQL:14 User Registration Example

Description

This section provides an overview of the user registration system.

Objectives

• Handle user registration
• Activate accounts
• Create login and logout scripts
• Apply password management

Time: 3 hour(s)

PHP and MySQL:15 E-Commerce Example

Description

After taking this section, the learner will have the information and sample needed to create an e-commerce site using PHP and MySQL, including creating the database, creating the public and administrative pages, and managing the shopping cart.

Objectives

• Create a database for an e-commerce site
• Create the administrative pages for an e-commerce site
• Create pages for a customer to browse the inventory and place orders from an e-commerce site

Create and manage an online shopping cart for your e-commerce site