HRDF Funded Course - PHP with MySQL Essential Training

This is a 2 days 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

Jamalla Zawia is a Web/Mobile Application Developer and Instructor. She has a great passionate toward both, Teaching and Software Development. She has seven years of teaching experience as a college instructor, in addition to at least other seven years of experience in Software Development as a Freelancer. Jamalla graduated in 2009 with a Master Degree in Information Technology and prior to that she had graduated in 2004 with a Bachelor Degree in Computer Science. She got both degrees with excellence. She executed and participated in many Software Development projects in both education and business domains.

Jamalla works on lot of desktop, web, and mobile technologies such as HTML, CSS, Bootstrap, JavaScript, PHP, Laravel, Java, C#, Angular 2.0, Android, SharePoint, WordPress, WooCommerce, Joomla, MySQL and many more. Currently she works as a senior Data Analyst and Management for national Petroleum Company in Yemen where she is a key part of internal teams.