|
|
|
|
This course shows you how to use the PHP scripting language and a web browser to access MySQL databases and tables. Simple and complex queries can be set up through a web page which calls a PHP script to carry out the enquiry. PHP can present the results of the query as a web page. PHP can also be used to provide a web interface to add, delete and edit rows of data in MySQL tables.
Course Content
• Introduction to PHP
• Taking User Input from Forms via PHP
• Variables and Expressions in PHP
• PHP Operators
• Conditional Tests and Events in PHP
• PHP Flow Control
• PHP Configuration
• PHP Functions
• Storing Data in Arrays using PHP
• MySQL Basics
• MySQL Directory Structure
• Designing and Creating Databases with MySQL
• Creating Databases, Tables, and Indexes
• Writing SQL Queries
• Advanced SELECTs
• Subqueries, Joins, and Unions
• Inserting, Updating and Deleting Records
• Using MySQL Built-In Functions with SELECT
• MySQL Table Types and Transactions
• Using Transactions with InnoDB Tables
• Administering MySQL
• Configuring MySQL
• Administering Your Database
• Backup and Disaster Recovery
• Securing Your MySQL Installation
• Replicating Your Database
• Optimizing MySQL
• Optimizing Your Database
• Optimizing Your Queries
• Handling Databases with PHP
• String Manipulation in PHP
• Sessions and Cookies in PHP
• File and Directory Access Using PHP
• Other I/O Issues in PHP
• Handling Email with PHP
• Object Orientation in PHP
• SOAP
|
|
|
|
|
|
|
|