PHP and mySQL - Introduction

Available Start Dates:
choose your own

Price: see custom ratecard Duration: 2 Platforms: PC

Courses now provided by Lucidica IT Support and Training, please contact them for booking and information www.lucidica.com

Static Webpages are no longer sufficient for the needs of the Internet in the 21st Century. An increasing number of business sites use databases to store data and produce dynamic Webpages. PHP and mySQL are a cost-effective but powerful solution to building database driven Websites which can be developed on Windows and deployed on either Windows or Unix(Linux)servers. This course does not cover the PHP language itself in great depth but concentrates on getting up and running with the mySQL database, using PHP as the server-side control. PHP is a powerful, free server-side language which is relatively easy to learn for those who have never programmed before.

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 Outline

Day 1

Installing PHP, mySQL and Apache Webserver on Windows 2000
Using PHPmyAdmin to create and manage databases
Password protection of private directories on Linux with .htaccess
Using basic SQL language commands
SELECT
DELETE
INSERT
The basics of the PHP language
Printing to the Screen
Variables
Maths functions
Gathering data using Forms
String manipulation and formatting

Day 2

Control Functions
Arrays
Building your own functions
Includes
The php_info() file
Using PHP to communicate with mySQL
Building a database application
Displaying database information in a table
Managing the database: deleting and updating records
Searching the database
Splitting search results over multiple pages
Displaying alternating row colours

Courses

Development

Facilities

Room Hire

CONTACT & INFO