Building Dynamic, Database-Driven Websites with PHP and MySQL Training Course
1Summary
Behind almost every content management system, booking engine, or e-commerce site is the same underlying pattern: a server-side language reading from and writing to a database in real time. This hands-on training course from the Arab British Fellowship Training Academy teaches participants to build that pattern themselves using PHP, with MySQL as the primary database and a look at PHP’s database-agnostic API that extends the same skills to almost any database system.
Through extensive practical sessions, delegates design and create database tables, then use SQL to power dynamic applications such as user-driven content management systems, online document and photo libraries, catalogue and diary applications, and online booking and e-commerce platforms.
2Objectives and target group
Who should attend?
- Web developers who want to use PHP’s server-side scripting capabilities to build dynamic, database-driven websites with relational database systems such as MySQL.
How attendees will benefit?
After completion of the course, delegates will understand:
- The basic program and data structure features available in PHP, and how to output dynamic web content from files and databases into HTML pages.
- How to handle user input from forms, and how to identify and authenticate users through PHP session management and cookies.
- How to design, create, and access database tables using SQL language features.
- How a secure e-commerce application is implemented.
3Course Content
Module 1: PHP Fundamentals inside HTML Pages
- Integrating PHP into HTML websites.
- PHP variables, data types, arrays, and control structures.
- Functions, variable scope, and include files.
Module 2: Handling Input, Files, and Uploads
- Processing user input from HTML forms using PHP.
- Handling files, directories, and folders.
- File upload from a form.
Module 3: Connecting PHP to a Database
- Creating a database table.
- Inserting and updating data in tables.
- Selecting data from a table and integrating it into a PHP web page.
Module 4: Sessions, Cookies, and User State
- Authenticating users and maintaining state with PHP session management.
- Use of cookies.
- Sending emails from PHP.
Module 5: Building Secure, Object-Oriented Applications
- PHP’s object-oriented features.
- Accepting secure credit card transactions.
- Managing PHP and SQL security considerations.
- Debugging a program.