PHP and MySQL (Beginner to Intermediate Level)

Duration: 3 Days

Training Fee: RM 3200.00

HRDF Claimable

About this course

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.

Prerequisite

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 Outline

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

Training Methods

Public Class Training

Private Class Training

In-House Class Training

Public Class Schedule
12-14 Feb 18
9-11 Apr 18
11-13 Jun 18
13-15 Aug 18
15-17 Oct 18
17-19 Dec 18

Please contact us if you need more information about Private or In-House Class Training – click here

Register Here

  • Public Class Training

  • Your Information

  • Participant List

  • NameContact NumberDesignation 
    Add a new row

Any Questions?

  • Contact Us

Call Us : 03-21165778