PHP and My SQL Programming

Course			Duration
PHP and My SQL Programming			4 days

 

In this intensive, hands-on PHP training course, students will learn to create database-driven websites using PHP and MySQL. Students will first learn the basics of PHP including syntax, flow control, string manipulation, and functions. Next, the course turns to database topics with several chapters on SQL basics followed by content on how to integrate PHP with the database. Regular Expressions are covered next to give students the tools they need for advanced form validation. Then, students will learn to track users as they move from page to page within a web site using PHP session variables. Finally, they will learn to manipulate files and send emails using built-in PHP functions.

Audience

Programmers who want to learn PHP.

Prerequisites

HTML experience is required. Programming experience in a high-level language is required. Basic CSS knowledge is helpful.

Course Objectives

• Write PHP scripts using all the major features of the language.
• Control the flow of program execution.
• Use indexed and associative arrays to store sets of values.
• Process and validate HTML forms.
• Work with PHP’s built-in string manipulation functions.
• Write reusable files and include them in multiple pages.
• Define functions to create more manageable PHP applications.
• Create SQL Select, Insert, and Update statements.
• Integrate PHP with a database to create reports and insert and update records.
• Use the PEAR DB package as a database abstraction layer.
• Use PHP regular expressions for advanced form validation.
• Use session variables to create site-wide user authentication and cookies to remember visitors between visits.
• Send email with PHP’s built in mail() function.
• Read, write, and upload files.