HRDF Funded Full PHP with MYSQL Training

This is a 2 days web development training on PHP and MYSQL. PHP is a popular, reliable programming language at the foundation of many data-driven CMS websites such as Wordpress, Joomla and Magento. This comprehensive PHP with MYSQL course will help beginners to learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database. The trainer will cover the basic CRUD routines for updating a database.
Topics include:

• What is PHP?
• Installing and configuring PHP and MySQL on Mac and Window
• Exploring data types
• Controlling code with logical expressions and loops
• Using PHP's built-in functions
• Writing custom functions
• Building dynamic web pages
• Working with forms and form data
• Using cookies and sessions to store data
• Connecting to MySQL with PHP
• Creating and editing database records

Module 1 Get Ready

• Install Apache, PHP and MYSQL
• Install Sublime Text
• Embed PHP in HTML
• PHP and HTML Comment

Module 2: Data Types

• Variables
• Number
• String
• Boolean
• Array
• Associative Array
• Null and Empty
• Constant

Module 3 Operators

• Common Operators
• Compound Operators
• Increment/Decrement Operators
• Comparison Operators
• Logical Operators
• Operator Procedure

Module 4 Control Structures

• Conditional
• While loop
• Do While Loop
• For loop
• Foreach loop
• Continue & Break

Module 5: Function

• Function Syntax
• Return value
• Default Argument
• Multiple Return Values
• Variable Scope

Module 6 Getting Data

• Data Sources
• Get Method
• Post Method 
• Include
• HTTP Header
• Cookies

Module 7: MySQL Basic

• Basic database concept
• Create/Delete database
• Create user
• Create/Delete/Show table
• CRUD in MYSQL

Module 8 Using PHP to access MySQL

• PHP API for MYSQL
• Connecting to MYSQL
• MYSQL query
• Fetching data
• Creating record
• Updating data
• Deleting data

Module 9: File I/O

• Reading a file
• Writing a file

Module 10: Object Oriented Programming (Optional)

• Class & Object
• Constructor Function
• Destructor Function
• Inheritance
• Function Overriding
• Member Types
• Interface