MySql & PHP

MySQL and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world’s most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications. Our Introduction to SQL using MySQL course is designed for students new to writing SQL queries using MySQL.

Objective:

PHP is a widely used programming language which works on the principal of server side scripting to produce dynamic Web pages. It can be easily integrated with HTML and SQL to produce these dynamic web pages, and is often used to process the contents of a Web page form as it is more secure and reliable than JavaScript. You will learn how PHP can be combined with MySQL to create a very powerful online database engine. This free online PHP programming course will be of great interest to IT and Web development professionals who would like to learn more about using PHP and MySQL to integrate database functions into Websites, and to learners who would like to learn more about the functionality of PHP and MySQL.

Course Outline:

• What is PHP
• Install PHP
• PHP Example
• PHP Echo
• PHP Print
• PHP Variable
• PHP $ and $$
• PHP Constants
• PHP Magic Constants
• PHP Data Types
• PHP Operators
• PHP Comments

Control Statement

• PHP If else
• PHP Switch
• PHP For Loop
• PHP While Loop
• PHP Do While Loop
• PHP Break

PHP Functions

• PHP Functions
• Parameterized Function
• PHP Call By Value
• PHP Call By Reference
• PHP Default Arguments
• PHP Variable Arguments
• PHP Recursive Function

PHP Arrays

• PHP Array
• PHP Indexed Array
• PHP Associative Array
• Multidimensional Array
• PHP Array Functions

PHP Strings

• PHP String
• PHP String Functions

PHP Math

• PHP Math Functions

PHP Form

• PHP Form: Get Post

PHP Include

• PHP include & require

State Management

• PHP Cookie
• PHP Session

PHP File

• PHP File Handling
• PHP Open File
• PHP Read File
• PHP Write File
• PHP Append File
• PHP Delete File

Upload Download

• PHP File Upload
• PHP Download File

PHP Mail

• PHP Mail

PHP MySQLi

• MySQLi CONNECT
• MySQLi CREATE DB
• MySQLi CREATE Table
• MySQLi INSERT
• MySQLi UPDATE
• MySQLi DELETE
• MySQLi SELECT
• MySQLi Order by

MySQL Course Contents

• What is MySQL
• MySQL History
• MySQL Features
• MySQL Data Types
• Install MySQL

MySQL Database

• Create Database
• Select Database
• Drop Database

Table & Views

• CREATE Table
• ALTER Table
• TRUNCATE Table
• DROP Table
• MySQL Views

MySQL Queries

• MySQL Queries
• INSERT Record
• UPDATE Record
• DELETE Record
• SELECT Record

MySQL Clauses

• MySQL WHERE
• MySQL DISTINCT
• MySQL FROM
• MySQL ORDER BY
• MySQL GROUP BY
• MySQL HAVING

MySQL Conditions

• MySQL AND
• MySQL OR
• MySQL AND OR
• MySQL LIKE
• MySQL IN
• MySQL NOT
• MySQL IS NULL
• MySQL IS NOT NULL
• MySQL BETWEEN

MySQL Join

• MySQL JOIN

Aggregate Functions

• MySQL count()
• MySQL sum()
• MySQL avg()
• MySQL min()
• MySQL max()
• MySQL first()
• MySQL last()