PHP & MySQL
New to PHP and want to harness its power? Our two-day PHP & MySQL course will teach you everything you need to know so that you can set up your sever and create interactive website functionality.
Book this courseCourse Overview
2 day course
Certificate of Attendance
In-person, Private
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.
On this two-day course, we’ll start by teaching you how to set up your server, and write your first line of PHP code.
Over two consecutive days, you’ll learn how to send and receive information to and from a database, and how to create secure, interactive website functionality. Through project-based learning you’ll gain hands-on experience 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 at a location of your choice across the UK.
What you'll learn
By the end of this course, you will be able to:
Customize your web server and use it to run your PHP programs
Work with inbuilt PHP functionality to increase your workflow
Set up and use a secure link with a database to run MySQL queries
Work effectively with all the PHP variable types
Use conditional statements, loops, functions and objects to solve a range of problems
Course agenda
Introduction
- PHP overview
- XAMPP set-up
- 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 and properties
- Inheritance
Database Introduction
- Database overview
- MySQL
- Command line
- phpMyAdmin
Using MySQL
- Running a query from PHP
- Query types
- Relationships
- Variable types
- Date and time
MVCs
- Model View Controller overview
- Top MVCs
- Advantages of using a MVC
Who it's for
If you want to take your first steps toward becoming a back-end developer, but currently have no experience and don’t know where to start, then this is the course for you.
BOOK THIS COURSE
Enquire for a team or large group
For private sessions call our sales team