PHP and MySQL Introduction

Call Us On:
0118 324 3000

Exciting News! Systematix is rebranding to Future Savvy. Same great services, with a fresh new look. Learn More

Overview

MySQL™ 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.

This Introduction to PHP training 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.

Prerequisites

This course is suitable for experienced web developers with a good grasp of HTML and general web concepts.

1. Getting started

Background to PHP
Installation and configuration
Embedding PHP tags
Adding comments
Using the Print function

2. 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

3. Working with forms

Forms overview
Capturing user input
Get and Post differences
Working with global variables
Handling file uploads

4. Accessing databases

Establishing a connection
Setting up queries
Using SQL commands
Displaying results
Adding records
Modifying records
Deleting records

5. 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

6. Errors and debugging

Overview of PHP errors
Logging errors
Typical scripting errors
Debugging strategies
Using Print statements
The Debug function

We can arrange your own private MySQL course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:

At Your Offices

Virtual Online

Training Centres

Very informative course, very useful tips on how to work with SQL Management Studio. A lot of SQL quirks explained, a lot of good examples.

Magdalena Piekarska - Veolia

The pace he delivered the course was perfect and he explained everything so clearly and in a way I could understand.

Jessica Homer - All About Food

Really enjoyable and relevant, Stuart was brilliant!

Vicky Fox - Charity Link

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

The trainer was very through and very helpful. The course was delivered superbly and I'm very pleased.

David O'Hara - Multibrands UK

Format:

Virtual or Classroom

Length:

2 Days

You will learn how to build a MySQL database-driven Web application using the PHP scripting language.

MySQL Introduction-Intermediate

Format:

Virtual or Classroom

Length:

3 Days

Learn the essentials of writing Structured Query Language (SQL) commands to access, create and modify data within a MySQL database.

Payments processed by card