Training Courses

PHP and MySQL : Introduction

Four Day Course

Overview

Both PHP and MySQL are increasingly popular open-source technologies and this course has been designed to give you the skills to fully utilise the power and flexibility they offer.

This four day, practical, exercise-driven course will cover the fundamentals of using MySQL and PHP and will provide a firm grounding in each technology and explore how they allow you to build sophisticated, bespoke web applications.

This course is designed for those new to working with PHP, MySQL and SQL (there is a two-day version of this course for those with some existing knowledge of programming in PHP). Feel free to tailor the following course outline to your exact requirements if you wish. This course is designed for delegates with some experience of HTML. You should also have attended our Introduction to PHP course or have a similar working knowledge of PHP prior to attending this course.

  • Private Courses

    One to one tuition or a private group with just your colleagues. Your choice of duration, content and location. We can train at one of our centres or onsite with you wherever you are located.

    We offer a free consultation service to help work out every detail and build the perfect course for you.

    From £545 + VAT

    Get A Free Consultation & Quote

Course Outline

  • Introduction
    • Why use PHP and MySQL?
    • The PHP programming environment
    • Overview of SQL

    Setting up a Test Server
    • Decisions about a testing environment
    • WAMP/MAMP
    • Installing Apache, PHP and MySQL on your computer
    • Testing on a remote Server
    • Deciding on Development tools
    • Using PHPMyAdmin

    Overview of PHP
    • Setting up a PHP page
    • The phpinfo() function
    • Learning basic syntax
    • Echoing HTML output to the browser
    • The importance of comments
    • Using single and double quotes

    Variables in PHP
    • Using loose typed variables
    • Assigning variables
    • Overview of numeric, string and other types
    • Assigning a variable to itself

    Logical operators
    • Arithmetic operators
    • Logical operators
    • Comparisons
    • Operator precedence

    Numbers in PHP
    • Making calculations
    • Using built-in numeric functions
    • Incrementing and decrementing

    Strings in PHP
    • Concatenating strings
    • Trimming strings
    • Removing slashes and other harmful characters
    • String functions
  • Control structures in PHP
    • The If statement
    • FOR loops
    • While loops
    • The Switch

    Transferring information between PHP pages
    • GET and POST
    • Different form field types
    • Self-referencing forms
    • Form handlers

    Database fundamentals
    • Structuring a database
    • Using tables
    • Table relationships
    • Common data types

    Creating a database
    • Using PHPmyAdmin
    • Adding a table
    • Populating a table with types and data
    • Browsing a table with SQL

    Getting PHP to connect to MySQL
    • PHP5 and MySQL5 security features
    • Using mysqli_connect()
    • Testing a connnection
    • Mysqli and prepared statements
    • Using a positional placeholder
    • Writing a sample error trap

    Querying MySQL using PHP
    • Writing SQL queries
    • Using Select, Insert, Update and Delete
    • Querying MySQL and returning results
    • Interpreting the returned array

    Building a Web Application
    • Manipulating dynamic pages:
    - Add entries
    - Modify entries
    - List entries
    - Filter entries
    - PHP and XML

    Security features
    • Validating entries

    Questions and answers
Experience + Flexibility

We know training inside out. We can advise you on all the options to make sure you get the best possible course.

Tell us you need to cancel 5 working days before your course and there’s no charge. Great for your peace of mind.

Our trainers bring their years of industry experience into the classroom. You'll leave confident and prepared.

The smallest class size in the industry. More one on one time with the trainer and a less intimidating group size.

Tell us which you use and it'll be booted up and waiting with the latest software when you arrive.

We provide a lovely onsite lunch so you can relax. We can cater for any dietary requirement with no fuss.

Comfort + Location
Reputation + Feedback

Our Clients


We've worked very hard over the last 20 years to grow our business through personal recommendations.

When you attend a course we ask you to tell us how it went. We use your feedback to help us improve our courses.

We publish all our customer satisfaction stats live on our site (good or bad) because we want everyone to know just how highly you rate us every day, every week and every year.

We know that choosing the best course can be difficult, maybe the thoughts of the 13140 other clients we've asked will give you the inspiration to join us too.

The most recent comments from attendees of our courses are shown below. We reckon they will give you a pretty good indication of how they think we perform.

  Client Ratings

Attendees surveyed13140
  Trainer Knowledge9.8 / 10
  Trainer Materials9.6 / 10
  Trainer Preparation9.8 / 10
  Overall Trainer Score9.7 / 10
  Centre Lunch9.6 / 10
  Centre Staff9.9 / 10
  Overall Centre Score9.7 / 10
  Overall Experience9.6 / 10
  % Who Would Recommend Us99.7%

  Recent Feedback


"Very knowledgeable, good facilitator and good interaction "

"Helpful examples. easy to follow. Flexible approach to the needs of the group. "

"adaption to what we will need it for on a day to day basis which was great. Very engaging and will be useful to all of us. "

"Really good structured course "

"Overall structure was great!"

"Overall being engaging and helpful. Addressing the areas that I struggled with in my writing and bringing that to full circle. I feel a lot more confident to plan and tackle work now - everything came full circle. "

"Great teacher, small group sizes meant you got personal training. Yummy lunch and snacks – Definitely will recommend "

"Lovely environment! "

"The trainer was particularly good because her enthusiasm and passion for the subject of photography was infectious and added another dimension to the course. The booking of the course was also well managed. "

"Simon was really engaging and knowledgeable. He made course fun whilst also emphasising the importance of the information delivered. "

"Really good courses, good to relate teaching and run tools to our own websites"

"Knowledgable and friendly staff"

"Very knowledgeable instructor, lovely staff and great facilities! "

"Really comfortable and relaxed environment. Emma was very friendly and knowledgeable, and the whole course was very enjoyable."

"Very useful covering of basics as well as more advanced stuff. Flexible when we had requests of things to learn"

"Great small groups of learning. Very helpful and patient trainer!"

"Organisation, intimate small classes, hospitality."

"Excellent venue, really small class so lots of individual attention, organised and friendly. "

"good food, clean, attentive hospitality staff, good trainer"

"Being dynamic when teaching. Sarah catered for what we wanted to learn as well as the course specification."

"atmosphere and ambience excellent. catering excellent, training rooms well specced. "

"Ian is great! Really made an effort to meet individual needs. Thank you"

"Great trainer - very enthusiastic and friendly. Good group size. Lunch was amazing too. :)"

"Very good course as an introduction. The instructor was very willing to teach things that were not necessarily part of this particular iteration. "

"Very organised, both days ran smoothly, had a good two days "

"Answering questions that were additional and specific to my needs of indesign but not necessarily on the syllabus"

"Trainer very helpful"

"A good balance in teaching given the requirements of all students on the course and the exposure that each had with the programme previously."

"Lots of examples and efforts to contextualise the course to everyone's personal requirements."

"Ian made learning on Ai very clear and simple to understand "