Web Programming using PHP/MySQL Part 2

This course builds on the teachings of Web Development using PHP part 1, introducing MySQL, a relational database management system developed by Oracle and based on the industry standard structured query language (SQL), and shows how to integrate it into a web application build using a PHP back end.

Combining PHP and MySQL allows developers to store create, read, update, and delete (CRUD) data using web forms. Uses include log in systems (user data - usernames, passwords, etc), customer/employee data (name, email, phone, address, etc) and ecommerce (shopping carts, payment systems, orders, etc).

By the end of the course, you will be able to:

• Create a single point of entry website
• Use MySQL workbench software
• Create database tables
• Read, write, update and delete data in databases
• Query databases to retrieve specific data
• Create a log in system for a website
• Validate new users using email confirmation
• Restrict certain website content dependant on user credentials
• Write basic Object Orientated PHP and MySQL queries.

Who is it for?

This advanced short course is ideal for those who have successfully completed the Web Programming with PHP Part 1 or have good PHP skills. You will require HTML authoring skills ideally through completion of our introductory web authoring course Building Websites with HTML5 and CSS3.

Timetable

This practical course takes place over ten weekly evenings.

City Short Courses follow the academic year, delivering courses over three terms. These include:

• Autumn - October
• Spring - January
• Summer - April

Benefits

• Delivered by an industry professional
• Taught in small groups
• Awarded a City, University of London certificate

• How to build a single point of entry website
• What a MySQL database is and what it is used for
• How to use the MySQL workbench software to design a simple database
• How to Connect to a MySQL database from your website using PHP
• How to create, retrieve, update and delete records in a database using PHP
• How to create a simple log in system for your website
• How to register for such a system with email verification
• Object orientated PHP and MySQL

By the end of the course you will be able to:

• Build modular web applications
• Use object oriented programming techniques
• Keep track of users with sessions and cookies
• Secure your PHP site
• Integrate with 3rd-party web services using PHP
• Process web forms robustly and securely.

Successful completion of Web Programming with PHP/MySQL Part 1 or equivalent PHP/MySQL skills and completion of our introductory web authoring course Building Websites with HTML5 and CSS3, or equivalent (X)HTML authoring skills.

English requirements

You will need a good level of spoken and written English to enrol on this course.