PHP & MySQL (Beginner to Intermediate)
Our PHP & MySQL course is designed to help you do just that! With a focus on real-world examples and working sample projects, you'll learn how to integrate and implement these technologies to build a dynamic website. Plus, we cover all the related technologies you need to know to succeed in this field. Join our public class training in Kuala Lumpur or opt for In-House training at your own venue throughout Malaysia.
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
This PHP & MySQL course introduces the participants to develop dynamic, secure, commercial Web sites to reflect the rapidly changing landscape of MySQL and PHP. In this PHP training course, students will learn to create database-driven websites using PHP and MySQL
This will broaden the scope to integrate and implement these PHP & MySQL technology by following real-world examples and working sample projects, and also covers related technologies needed to build a dynamic web site.
This PHP & MySQL course is available on our public class training in Kuala Lumpur or also available if you want to conduct In-House training at your venue, throughout Malaysia.
Who should attend?
This PHP & MySQL training is designed for programmers responsible for developing and/or maintaining PHP web based applications that access a MySQL database. This PHP & MySQL course is designed as a second level course for students in the PHP programming language.
Prerequisites
Students should have basic MS-Windows knowledge, including file creation, text editing, FTP client, and Web browser usage. The student should also have basic knowledge HTML, web concepts, and basic PHP programming concepts.
Course Content
1. Installation
- Windows Installation
- All-in-one Installation
- Installing Individual Packages
- Editing PHP Scripts – Free IDE
2. Introducing PHP
- Syntax and Statements
- Variables, Operators, and Comments
- Arrays
- User Interaction and Forms
- Control Structures
- Use PHP Templates
3. PHP functions
- Defining a & Calling a Basic Function
- Call-by-value & Call-by-reference
- Mathematical Functions
- String ,Date, and Time Functions
- Anonymous Functions
4. Introducing MySQL
- Structured Query Language
- Creating a Database
- Creating a Table
- Inserting/ Viewing/ Modifying/ Deleting Data into a Table
- Functions for Use with GROUP BY Clauses
5. Publishing MySQL Data on the Web with PHP
- Connecting to MySQL with PHP
- Sending SQL Queries with PHP
- Handling SELECT Result Sets
- Inserting / Deleting Data into the Database
6. Relational Database Design
- SELECT with Multiple Tables
- Simple Relationships
- Many-to-Many Relationships
- One for Many, and Many for One
7. Advanced SQL Queries
- Sorting SELECT Query Results
- LOCKING TABLES
- Column and Table Name Aliases
- GROUPING & LIMITING SELECT Results
- LEFT JOINs
8. Structured PHP Programming
- Including HTML Content
- Including PHP Code
- Shared Include Files
- Advance Custom Functions and Function Libraries
- Variable Scope and Global Access
9. Cookies, Sessions, and Access Control
- How Sessions Work in PHP
- Session Code & Functions
- Configuration Issues
- How Cookies Work in PHP
- Sending HTTP Headers
10. Binary Data
- Handling File Uploads
- Recording Uploaded Files in the Database
- Storing Files
- MySQL Packet Size
- PHP Script Timeout
11. Content Formatting with Regular Expression
- Regular Expression
- String Replacement with Regular Expression
- Matching Tags
- Paragraph/Hyperlink
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.