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 8788 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 surveyed8788
  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


"Everything was fab. Thank you!"

"An engaging trainer, who was very patient with everyone. Gave useful tips and advise. Answered all the questions"

"Good Examples, clear instructions, helpful tips. "

"Very welcoming, happy to answer all questions and no question was a silly one. Content of the course definitely covers what we need to learn."

"Approachable and friendly trainer! "

"Patient. Explained things throughly. Showed examples of how it goes well and what happens when it goes bad. friendly and personable trainer. Great zen in the building. overall really liked my day!"

"Good pace, clear instruction, great catering. "

"everthing is good !!"

"the trainer is very good and deal with the course in professional way and he is very excellent in explaining and helping trainee"

"Friendly and approachable trainer who was very knowledgeable and happy to help in any way. Great pace."

"Really nice training space and team. Liked the small class and liked the natural training style from Kate. It didn't feel like we were being lectured. Liked how we did lots of examples and practices. "

"Our trainer Kate was amazing! Very informative, very patient and Kate really boosted my confidence when using INDESIGN. "

"Very approachable friendly atmosphere, great group sizes, much smaller than I had expected which was a great surprise. "

"Informative training - Good food and snacks"

"Being patient and providing informative training. It was really beneficial that we got regular breaks as my mind remained engaged throughout"

"Really engaging and personable. Instantly felt comfortable and like I could ask stupid questions!"

"Answering questions, friendly approachable attitude"

"Covered a lot of bases. Good environment. "

"Welcoming us and sharing the knowledge."

"Gained brilliant knowledge which I will use in my day to day job."

"Nice learning environment and people, great lunches!"

"Great trainer, personable and answered all questions effectively. Intuitive introduction to illustrator and covered a large number of topics in two days, as well as going into extra depth on relevant topics! Good spec macs and all the resources required were provided which is great. "

"Small class sizes were great. Intimate class, I was able to ask many questions and bounce ideas off of others. "

"beaut environment and creative space "

"Breaks are important to stay refreshed and continue learning, this I find every time helps me stay concentrated and absorb the course. Trainers are always very helpful and knowledgable. "

"fantastic knowledge of information, great examples given of daily tasks"

"Very tailored workshop to our needs. Sandi listened to our needs and covered the essential points which would help us in our day to day work. We picked up lots of shortcuts and tips which will make our job so much easier and save us so much time. Thank you so much for an informative and enjoyable day . Also thank you for a lovely lunch in such a lovely, friendly environment. Thank you"

"Answering questions off the cuff, walking us through previously-complex questions, providing peace of mind that our challenges are surmountable. Friendly, relaxed atmosphere & super approachable, knowledgable staff. Leaving today feeling upskilled and confident."

"Simple, clear and helpful tips. Will improve my video production skills as a basic level user!"

"Very informative training, nice environment, evreyone very friendly and helpful."