Dive into the world of web development with our comprehensive PHP and MySQL training. This course commences by demystifying the essence of PHP and seamlessly guides you through the process of installation and configuration on both Mac and Windows platforms. Explore PHP's diverse data types, control your code using logical expressions and loops, and harness the power of both built-in and custom functions to build robust web applications.

Beyond the foundational PHP aspects, our training offers a deep dive into creating dynamic web pages, proficiently handling forms and their data, and effectively utilizing cookies and sessions to store vital information. A key highlight is the detailed approach towards integrating PHP with MySQL, enabling you to effortlessly create and modify database records. Equip yourself with the skills to develop dynamic, database-driven web applications with Tertiary Courses today.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M304

Topic 1 Get Ready

• Install Apache, PHP and MYSQL

• Install Sublime Text

• Embed PHP in HTML

• PHP and HTML Comment

Topic 2: Data Types

• Variables

• Number

• String

• Boolean

• Array

• Associative Array

• Null and Empty

• Constant

Topic 3 Operators

• Common Operators

• Compound Operators

• Increment/Decrement Operators

• Comparison Operators

• Logical Operators

• Operator Procedure

Topic 4 Control Structures

• Conditional

• While loop

• Do While Loop

• For loop

• Foreach loop

• Continue & Break

Topic 5: Function

• Function Syntax

• Return value

• Default Argument

• Multiple Return Values

• Variable Scope

Topic 6 Getting Data

• Data Sources

• Get Method

• Post Method 

• Include

• HTTP Header

• Cookies

Topic 7: MySQL Basic

• Basic database concept

• Create/Delete database

• Create user

• Create/Delete/Show table

• CRUD in MYSQL

Topic 8 Using PHP to access MySQL

• PHP API for MYSQL

• Connecting to MYSQL

• MYSQL query

• Fetching data

• Creating record

• Updating data

• Deleting data

Topic 9: File I/O

• Reading a file

• Writing a file

Topic 10: Object Oriented Programming (Optional)

• Class & Object

• Constructor Function

• Destructor Function

• Inheritance

• Function Overriding

• Member Types

• Interface