PHP / MySQL Development
This course is aimed at anyone involved in web design and development who would like to learn how to build dynamic database driven websites using PHP and MySQL.
Who should attend?
You should have a basic understanding of Dreamweaver before taking this course. Be able to create and manage pages and sites and be familiar with internet. A basic knowledge of HTML code is desirable but not essential.
Every effort will be made to complete the agenda within the given time scale, but it should be noted that the course is designed to run at your pace and topics will not be rushed in order to complete the agenda.
Introduction To MySQL
Understanding Database Structure
Creating a Database
Basic SQL Commands
Introduction to PHP
Language basics
Data types in PHP
Understanding and working with arrays, variables, data types
Processing data using operators
Creating Dynamic Content
Embedding PHP in Web Pages
Using forms to capture user input
Use of the date and time
Using “include” & “require” to dynamically include code
Control Structures
Decision making - if / else / else if
Evaluation of expressions and “true” and “false”
Multiple and nested conditions
The “?” Operator
Loops
Terminating Code
Functions
Built in Functions:
Mathmatical
Strings
Random Numbers
Custom functions:
Syntax for defining functions
Variable Scope
Function parameters
Return Values
PHP & MySQL - Working Together
Connecting to the Database
Displaying Database content using PHP
Adding and deleting database data
Updating database.