PHP and MySQL (Introduction)

PHP and MySQL course is offered by Synergie Training. Synergie Training’s IT Training Division is one of the leading technical training companies in Scotland and deliver training all over the UK.

Content:

• Introduction
• Installing PHP & MySQL
• Introducing PHP & MySQL
• Installing Your Own Web Server
• Your First PHP Script
• MySQL Databases
• Your First Database
• An Introduction to Databases
• Using phpMyAdmin to Execute SQL
• SQL Basics
• PHP Fundamentals Part 1
• Introducing PHP
• PHP Variables, Operators, and Comments
• PHP Arrays
• Passing Variables in Links
• Passing Variables in Forms
• PHP Fundamentals Part 2
• PHP Conditional Statements
• PHP Loops
• PHP Functions
• PHP Templates
• Controllers and Templates
• Displaying MySQL Content
• Connecting to MySQL with PHP
• Sending SQL Queries with PHP
• Handling SELECT Result Sets
• Modifying Database Content with PHP
• Inserting Data into the Database
• Deleting Data from the Database
• Updating Data in the Database
• Extended Database Design: Multi-table Queries
• SELECT with Multiple Tables
• Simple Relationships
• Many-to-Many Relationships
• Structured PHP Programming
• Including HTML Content and PHP Code
• Types of Includes
• Custom Functions
• Variable Scope and Global Access
• Feeding Web Pages With AJAX
• Creating the Client Side User Interface
• Passing Data to Server Side PHP Using jQuery
• Passing AJAX Data to Client Using PHP