PHP and MY SQL

PHP and MY SQL.

Course Code : 107

Workshop : Training

Duration :

Instructor :

COURSE OUTLINE

· Install and configure PHP, mySQL and Apache Webserver on Windows

· How databases are used on the Web

· Use PHPmyAdmin to create and edit databases

· Query your database with basic SQL commands

· Program with basic PHP statements

· Use PHP to communicate with your database

· Add, Delete and Modify data in the browser

· Build a complete Data Management system with PHP and mySQL

COURSE OBJECTIVES

In this course you gain PHP programming skills need to successfully build interactive, data-driven sites and MySQL database skills to build the databases that will power your sites.

TARGET AUDIENCE

This course is aimed at intermediate and advanced web designers looking to take the leap into building database driven websites. Knowledge of JavaScript is required however if you do know some JavaScript, that will make learning PHP a breeze, since the languages are similar.

COURSE CONTENTS

1. Introduction to HTML Scripting

Basic HTML Document Tags

Text Structure and Formatting

Including Images

Linking multiple HTML pages

Creating Forms

Working with tables

2. Introduction to PHP

PHP's purpose and capabilities

Server Side vs. Client Side Scripting

How PHP looks like – Basic Construct

Testing PHP installations in your server

3. Language Basics

Lexical Structure and Syntax

Data Types in PHP

Using Variables and Constants

Understanding Arrays

Working with combinations of Data Types, Variables and Arrays

Processing data using operators

4. Creating Dynamic Web Content

Embedding PHP in Webpages

Retrieving user input through forms

Retrieving user input using the GET method

Getting the date and time

Dynamically including code using include and require

5. Giving your code life – Control Structures

Conditional decision making – if, else, and elseif

True, false, and evaluation of expressions

Multiple and nested conditions

Short Circuit Evaluation – break and continue

The Operator

Decision making using the switch statement

Iterations using while loops

Iterations using do...while loops

Iterations using for loops

Iterations using for each loops

Terminating code using exit (), return, and die ()

6. Using PHP's built-in functions

Mathematical functions

Working with Strings

Generating random numbers

Learning more about built-in functions

7. Creating custom functions

Why write your own functions

Syntax for defining a function

Variable scope, and the global statement

Adding in function parameters

Return values from functions

8. Introduction to Database

What is a database

Why use a database – The three-tier architecture approach

Introducing MySQL and PHPMyAdmin

Understanding the database structure

Creating a simple database

Basic SQL commands

9. Making PHP and MySQL work for each other

Connecting to the database

Displaying database content through PHP

Adding data into the Database

Deleting from the Database

Updating and modifying data in the Database

10. Putting it all into practice – Lab project

Step-by-step creation of a simple web application that allows user to view data in a

formatted page, and interactively add, edit, and delete the database content.