Duration: 2 Hours 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.
Installing Apache with PHP
Setting MySQL permissions
Testing the installation
• 2. PHP Basics
Duration: 3 Hours After taking this course, the learner will be able to describe the PHP scripting language, and create basic PHP scripts using proper PHP syntax.
Understanding PHP, HTML, and white space
• 3. Programming with PHP
Duration: 4 Hours After taking this course, the learner will be able to create elaborate scripts, write HTML forms, and program PHP to handle the form data.
Creating HTML forms
Handling HTML forms
Managing magic quotes
Using conditionals and operators
Validating form data
Creating and accessing arrays
Arrays and strings
For and While loops
• 4. Creating Dynamic Web Sites
Duration: 3 Hours This course 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.
Including multiple files
Using PHP redux
Making sticky forms
Creating your own functions
Creating a function that takes arguments
Setting default argument values
Returning values from a function
Date and time functions
• 5. SQL and MySQL
Duration: 4 Hours After taking this course, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.
Choosing column types
Choosing other column properties
Using mysql client
Creating databases and tables
Using LIKE and NOT LIKE
Sorting and limiting query results
Updating and deleting data
Using text and numeric functions
Formatting date and time functions
• 6. Advanced SQL and MySQL
Duration: 3 Hours After taking this course, 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.
Normalization, keys, and relationships
First Normal Form
Second Normal Form
Third Normal Form
Creating and populating the database
Grouping selected results
Using different table types
Performing basic FULLTEXT searches
Performing Boolean FULLTEXT searches
Optimizing the database
• 7. Error Handling and Debugging
Duration: 2 Hours This course provides the learner with the steps and tools necessary to identify and correct errors that can occur when running PHP and MySQL applications.
General error types and debugging
Displaying PHP errors
Adjusting PHP error reporting
Creating custom error handlers
Logging PHP errors
PHP debugging techniques
SQL and MySQL debugging techniques
• 8. Using PHP with MySQL
Duration: 2 Hours This course 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.
Modifying the template
Connecting to MySQL and selecting the database
Executing simple queries
Retrieving query results
Ensuring secure SQL
Counting returned records
Updating records with PHP
• 9. Developing Web Applications
Duration: 2 Hours This course provides the learner with information about a number of independent topics that are present in more sophisticated Web applications.
Adjusting behavior for server settings
Sending values manually
Using hidden form inputs