PHP and MySql Training: Creating Online Applications

Creating database application with PHP & MySQL

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.

This practical workshop teaches students how to leverage the PHP language and the MySQL database to create database driven web applications.

This PHP & MySQL training course covers the fundamentals of PHP programming, introduction to MySQL database, advanced features of PHP, MySQL and creation of database driven applications.

You Will Learn How To

  • Write effective, efficient PHP scripts
  • Create a Good Database Design based on RDBMS principles
  • Embed PHP scripts in HTML pages to create dynamic Web pages
  • Manipulate data from Web page forms
  • Structure PHP code using user-defined functions and external libraries
  • Develop database-enabled Web applications using MySQL

Recommended Pre-requisites

Some understanding of programming concepts, HTML, and experience working with a DBMS is recommended prior to attending this course.

Course Outline/Agenda

  • Introduction to PHP: PHP’s role in the WWW
  • Language fundamentals: PHP Basics, PHP Data types, Storing & retrieving information in variables, Basic operations
  • Decision making in PHP: Comparison operators, IF, While, For
  • Arrays and PHP: Working with arrays, sorting, array functions, multi-dimensional arrays
  • Re-using PHP code: Functions, Including Code, Variable Scope in PHP
  • PHP and the WWW server: Working with Forms, Validating data, processing files, secure code
  • Working with MySQL

A brief history of MySQL, Relational database concepts
Database tables, Data Types,
Using the CREATE TABLE statement
Manipulating data in SQL
The SELECT statement
+Overall SELECT syntax
+ Selecting values to display
+ Restricting selections using the WHERE clause
+ Using ORDER BY to sort query results
+ Using LIMIT to limit result sets
The INSERT statement
The UPDATE Statement
The DELETE and TRUNCATE TABLE statements

  • Accessing databases using PHP

Retrieving information about queries (metadata)
Transactions and queries
Retrieving data from a database
Single-step queries

  • Managing web sessions: Sessions & Cookies
  • Handling date & time in PHP
  • Working with files in PHP
  • Sending email using PHP
  • Creating a Databaset Driven PHP Application
  • Debugging PHP Code:
    PHP Error handling
    PHP debugging tools
    Suppressing errors

Create a Database Driven Web Application using PHP & MySQL – For example, create a Membership Application, an Orders Database, a CD shop catalogue & search project, or select a project of your own choice ( after consultation with the trainer).

Class Size
This class is limited to a maximum of 8 to 10 students.

Fill the form on the Top Right of this page to book your seat for this practical, hands-on PHP & MySQL course in Singapore now. What are you waiting for?

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!