Professional Training

PHP and MySQL Introduction

Systematix Limited, In Birmingham (+4 locations)
Length
2 days
Next course start
Enquire for more information (+5 start dates)
Course delivery
Classroom, Virtual Classroom
Length
2 days
Next course start
Enquire for more information (+5 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Course description

PHP and MySQL Introduction

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.

Upcoming start dates

Choose between 5 start dates

Enquire for more information

  • Classroom
  • Birmingham

Enquire for more information

  • Classroom
  • London

Enquire for more information

  • Classroom
  • Manchester

Enquire for more information

  • Classroom
  • Reading

Enquire for more information

  • Virtual Classroom
  • Online

Suitability - Who should attend?

Prerequisites

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

Training Course Content

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

Request info

Contact course provider

Fill out your details to find out more about PHP and MySQL Introduction.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Systematix Limited

Welcome to Systematix, your gateway to a world of boundless learning and professional growth! At Systematix, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals and organisations...

Read more and show all courses with this provider

Ads