Register Now for this Training

Current Promotions

PMP Exam Free Preview Session

May 28, 2013 - Tuesday @6:15pm and

June 11, 2013 - Tuesday @ 6:15 pm

Creating Database Applications Using PHP & MySQL

Learn how to create Dynamic, Online Applications - like Shopping Carts, Customer Databases, Online Stores, Accounting Systems, Membership Systems, all using PHP programming language, and the MySQL Relational Database.

SDF Funding now Available for Singaporeans/PRs, sponsored by their Singapore based Company. Call (65) 6296-2995 for Details.

Course Objectives
Target Audience
Course Outline
Course Benefits
How to Register

Course Objectives

You Will Learn How To:

Install, Setup and Create a database using MySQL
Insert, Update, Delete Records in MySQL database tables
Write Queries against the MySQL database & Retrieve data using specific criteria
Write effective, efficient PHP scripts
Embed PHP scripts in HTML pages to create dynamic Web pages
Manipulate data from Web page forms
Track users as they navigate your site with cookies and other PHP features
Structure PHP code using user-defined functions and external libraries
Develop database-enabled Web applications using MySQL ( You can also get an Introduction to MySQL database, and Oracle Database SQL Expertise in a separate training class too)

Target Audience

Those creating dynamic, database-driven Web sites. Basic experience with HTML is assumed. Prior Programming or PHP experience is helpful but not required.

Certification:
Certificate of attendance would be given to all participants who attend the complete training.

Materials:
Notes in folders will be provided.

Class Size:
8-12 participants

Course Outline

In this course, you develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web application.

Exercises include:

Creating A MySQL Database, Creating Tables, Fields, and Inserting Records in the MySQL Database tables
Selecting Data from the MySQL database using various filtering criteria techniques.
Sort, Format and Convert MySQL data using specific MySQL Functions and features.
Generating Web pages dynamically using PHP
Retrieving and manipulating form data
Personalizing Web site content using cookies
Tracking user navigation on your Web site
Integrating database content to generate dynamic Web pages
Building modular scripts to enable code reusability

Introduction to PHP

Origins of PHP in the open source community
Availability across multiple platforms
Installing as a module for Apache Web Server

PHP language building blocks

Comparing PHP with other Web scripting languages
Investigating PHP data types
Integers, Floating point values, Strings, Booleans

Writing PHP scripts

Storing values in scalar variables
Writing conditional expressions
Implementing loops such as while, for and foreach
Building complete scripts incorporating loops and conditional expressions

Writing Web Pages with PHP

Interacting with the server

Embedding PHP code into HTML pages
Determining how data is sent from forms to PHP scripts
Creating dynamically-generated hyperlinks to call PHP scripts

Manipulating user input

Presenting the user with input options via different HTML form elements
Retrieving form data with POST and GET arrays
Validating retrieved data
Strategies for handling invalid input
Storing state information using cookies

Applying Advanced Scripting Techniques

Exploiting the built-in functionality of PHP

Formatting date and time information
Manipulating string data
Investigating other built-in features

Structuring PHP code

Writing user-defined functions to structure your code
Passing arguments and default values to functions
Returning data from functions
Accessing global variables
Building code libraries for reusability
Incorporating external PHP scripts with require and require_once

Building Complete Web Applications

Managing errors

Investigating the HTTP header
Suppressing on-screen error messages on production servers
Configuring the php.ini file to control error messages

Handling problematic situations

Troubleshooting problems when manipulating data
Redirecting the browser to other pages
Modifying the PHP configuration file to suit your needs
Developing debugging strategies

Establishing database connectivity

Creating and managing database connections
Sending queries to the database server employing the most efficient methods
Retrieving query results as associative arrays
Displaying returned data on Web pages
Avoiding potential problems by managing quotes and backslashes in data
Closing the database connection

Course Benefits

PHP is a scripting language used to create dynamic, complex and robust Web pages. It can seamlessly integrate with a wide range of database servers, including Oracle, MySQL and Microsoft SQL Server.

In this Introductory course on PHP programming, you gain a solid foundation for incorporating PHP techniques in your online, web based applications, and learn how to interface it with the MySQL database.

Extensive hands-on exercises provide you with the skills to produce dynamic Web pages, retrieve and manipulate data, track user navigation, and integrate database content.

Practical, Hands-On Exercises & Techniques to Gain a Solid Understanding of:

Creating a User Login & Authentication System
Sending Form Data to the MySQL Database
Using Sessions & Cookies in PHP pages
Insert, Update, Delete, Select and Display data from MySQL Database into the Web
Search the Database and Display only Matching Results using PHP
Use Pagination to Control Results Per Page
Advanced Features & Structured Code Writing Tips

How to Register

Register Online for the 3 Day PHP & MySQL Training Workshop Today.

To claim SDF Funding for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.

Call Kamini at (65) 6296-2995 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming PHP & MySQL Training class.

We also offer Customized Corporate Training for PHP, with MySQL or Oracle Database. If you have a group of 10 or more participants, we can conduct this training at your office too. Contact us for details.

Go to Top

Course Enquiry
Select Your Course *
Course Date*
Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Pass Type
No. of Participants*

Our Clients

Testimonial for PHP & MySql

I learnt how to create my own quizes, and manage a portal. The hands-on practice with instant trouble shooting with the training was very helpful. - Lee Teck Hong, Hwa Chong Singapore.

The training met my expectations. Each individual lesson was short, organized and easy to understand and do. I liked the interactive sessions the bost - Thomas Kong, Singapore

I liked the hands-on exercises, and was able to create a database driven application within the 3 days of the course - Judy Lim, ITE College East, Singapore

The greatest strength is the hands-on exercises & tips on using PHP & Mysql for real life projects - SIM University

I liked the clear instructions and guides to recommended sites - ABN AMRO N.V.

Everything is great about this workshop. I most liked the hands-on approach to PHP & MySQL database programming - Chung K Y, Temasek Polytechnic

Register Now for this Training

19, 20, 21 Jun 2013

7, 8, 9 Oct 2013

9, 10, 11 Dec 2013

Current Promotions

Creating Database Applications Using PHP & MySQL

Course Enquiry