Announcement: Mindasys is now Skillet! Check out our new website.

Key points about this course

Duration : 3 Days
Course Fee : RM 3,599.00

HRD Corp Claimable Course

PHP & MySQL (Beginner to Intermediate)

Virtual Class

Public Class

In House Training

Private Class

Course Overview

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. ThisPHP & MySQL course is designed as a second level course for students in the PHP programming language.

Course 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

  • PHP and MySQL (Beginner to Intermediate Level)

  • Ask For