PHP & MySQL Introduction Course
- this course is no longer scheduled to run. Please refer to schedule for current course titles.
Course DescriptionMySQL and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications.
The course examines the core concepts and technologies required to build a basic dynamic website using PHP. The Introduction to PHP training begins by examining how to setup and configure Apache to support PHP and then our Introduction to PHP training moves on to explore the language fundamentals of PHP. The Introduction to PHP training concludes with a discussion about form-driven websites, state management, and overall site design. |
£895.00 2 day course Scheduled Dates: 28 May 2012 25 June 2012 23 July 2012 |
Course pre-requisites:
This course is suitable for experienced web developers with a good grasp of HTML and general web concepts.
Topics covered on the 2 day PHP & MySQL Introduction course
Getting started
- Background to PHP
- Installation and configuration
- Embedding PHP tags
- Adding comments
- Using the Print function
PHP scripting
- Using variables
- Dynamic variables
- Data types
- Defining arrays
- Associative arrays
- Manipulating arrays
- Operators and expressions
- If statements
- Switch statements
- The While statement
- The For statement
- Defining functions
- Passing arguments
Working with forms
- Forms overview
- Capturing user input
- Get and Post differences
- Working with global variables
- Handling file uploads
Accessing databases
- Establishing a connection
- Setting up queries
- Using SQL commands
- Displaying results
- Adding records
- Modifying records
- Deleting records
State management
- Overview of strategies
- Using hidden fields
- Creating query strings
- Reading and setting cookies
- Setting expiry dates
- Deleting cookies
- Overview of session functions
- Using session variables
- Tracking the session ID
Manipulating data
- Formatting strings
- Manipulating strings
- Searching strings
- Regular expression functions
- Replacing patterns in strings
- Splitting strings
- Formatting dates
- Converting data types
Errors and debugging
- Overview of PHP errors
- Logging errors
- Typical scripting errors
- Debugging strategies
- Using Print statements
- The Debug function
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Course Fee = £895.00 (excl.VAT)
Scheduled course dates
28 May 2012 to 29 May 2012
25 June 2012 to 26 June 2012
23 July 2012 to 24 July 2012
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Web Design Training and bespoke Web Design courses