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
Project
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.