Course Audience
This course is perfect for existing web designers familiar with XHTML coding techniques. Introductory programming experience is assumed.

Course Overview
PHP and MySQL are growing increasingly popular with professional web designers because of its simplicity and flexibility. PHP is widely supported and hosted on commercial websites without the need for expensive licences, and is indeed also supported by free software available online. The wealth of support tools online are extremely beneficial and can help you as a designer take full advantage of the language to its full range.  Users familiar with languages such as C, Java, VBScript and JavaScript will find the transition to PHP intuitive.

MySQL is used to create robust backend databases particularly suited for websites with high content. It provides a real alternative to commercial databases and can be found online for free.

Course Content
Variables, Expressions & Functions
Identifiers and Data Types
Installation & Configuration
Installation on a Windows System
File Management
Working with files. Opening files. Reading from files. Writing to files. Using file contents to populate web page Templates
Configuration Options
Language Fundamentals
Encapsulating PHP within HTML
Using scalar variables
PHPs different operators
Control Structures
Arrays in PHP
Manipulating Form Data
Forms in HTML
POST vs GET for form input Returning results to the user
Calling pages from themselves using forms
An Introduction to MySQL
Relational databases
MySQL installation
Basic MySQL Management
Database Interaction
Storing data to a database
Transactions
Using templates to control the look-and-feel
Array, date/time, filesystem and directory, mail, string and regular expressions functions
databases
Retrieving data from forms
Validating Input
Accessing Environment Security Issues

Course Objectives
The course aims to provide each student with a working knowledge of how to setup and configure a web server. Students will have the knowledge to manipulate dynamic web pages using PHP and the MySQL database.

Course Duration / Commencement dates
40 contact hours – usually delivered over a 13 week period.
Please contact CCT directly for the next Commencement date

Fees
Course tuition fees EUR875