Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

Profile Services Careers Courses Why Us Contact Us

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

web development
Website Designing
Logo Designing
Graphic Designing
Banners and Posters
On Page SEO
Off Page SEO
Web 2.0 and 3.0
Core Java
Advanced Java
C with Data Structure
OOPS Using C++
SQL Server 2005
3g management contact no.