PHP & MySQL

PHP is the language powering more than 80% of the web that uses server side technology, if you want your website to interact with a database and have back end functionality, then you need to know PHP.

This course starts from the beginning of setting up your server and writing your first line of PHP code. Then over the two days you will gain understanding on how to send and receive information to and from a database and how to create secure interactive website functionality.

Through project based learning you will gain practical experience in working with variables, arrays, conditional statements, loops, functions, objects, error reporting and exceptions.

Our PHP & MySQL course is available at our training centre in The Shard, London.

We also offer private training courses tailored to your needs, which are ideal if you have more than two members of your team that want to retrain or develop their skills in PHP.

Led by one of our in-house PHP experts this foundation training will take you from a point of no experience in server-side scripting, to where you are equipped with the skills you need to start writing your own backend code.

We’ll share our industry experience to help you avoid the potholes and give you the best programming practices that will allow you to start your journey in becoming PHP developer.

What will I learn?Upon completion of this course you will have gained the skills to:

• Customise your web server and use it to run your PHP programs
• Work effectively with all the PHP variable types
• Work with inbuilt PHP functionality to increase your workflow
• Use conditional statements, loops, functions and objects to solve a range of problems
• Setup and use a secure link with a database to run MySQL queries

Why should I take this course?If you want to take your first steps in becoming a backend developer, but currently have no experience and don’t know where to start, then this is the course for you.Course OverviewIntroduction

• PHP Overview
• XAMPP Setup
• Hello World!
• Comments

Variables

• Declaration
• Types
• String Functions

Arrays

• Declaration and Using
• Associative Arrays
• Multidimensional
• Array Functions

Logic

• If Statement
• If Else Statement
• Switch Statement

Loops

• While Loop
• Do…While Loop
• For Loop
• Foreach Loop

Functions

• Declaration
• Variable Scope
• Passing Values

Objects

• OO Programming
• Class declaration
• Methods & Properties
• Inheritance

Database Introduction

• Database Overview
• MySQL
• Command Line
• phpMyAdmin

Using MySQL

• Running a Query from PHP
• Query Types
• Relationships
• Variable Types
• Date & Time

MVC’s

• Model View Controller Overview
• Top MVCs
• Advantages of Using a MVC

Certificate of completion

Digital certificate - Included