PHP with MySQL

Overview

This course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP that powers many websites. It originally started out as a way to make dynamic websites by generating html. Because of its roots, it is very easy to insert bits and pieces of PHP inside of standard HTML/XHTML code. Participants will be using MySQL which is a popular relational database management system. It is the standard database system available on web hosting sites. Although it works with many different programming languages, it is frequently paired with PHP.

Pre-requisite Knowledge/Skills

• Basic Programming knowledge and Logical skills and
• Basic SQL knowledge.

Course Objective

Upon successful completion of the course, participants should be able to:

• List the major elements of the PHP & MySQL work and explain why PHP is good for web development
• Learn how to take a static website and turn it into a dynamic website run from a database using PHP and MySQL.
• Analyze the basic structure of a PHP web application and be able to install and maintain the web server, compile, and run a simple web application.
• Learn how databases work and how to design one, as well as how to use php MyAdmin to work with MySQL.
• Learn different ways of connecting to MySQL through PHP, and how to create tables, enter data, select data, change data, and delete data. Connect to SQL Server and other data sources.

Course Outline

The contents of this course are designed to support the course objectives. The following focus areas are included in this course:

• Module 1: Introduction to MYSQL
• Module 2: MySQL with PHP
• Module 3: Introduction to PHP
• Module 4: PHP programming
• Module 5: PHP Arrays
• Module 6: PHP Functions
• Module 7: PHP Forms and User Input
• Module 8: PHP Cookies and Sessions
• Module 9: PHP Exception Handling

Project Work

Participants are required to do a project work as a part of the program. Project work should be in accordance with the project specifications provided by ICT Academy in consultation with the industry. The project work should be done in groups, with 4 or 5 participants in a group.

Course Deliverables