PHP and MariaDB for Web Development — A 2 day course
Synopsis
The PHP & MariaDB for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MariaDB Database system.
Objectives
On completion of the PHP & MariaDB for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MariaDB database.
The delegate will learn to:
- PHP Configuration
- Basic SQL Syntax
- Connect to a MariaDB Database with Error Checking
- Use PHP to Interact with a MariaDB Database
- Utilise PHP with the HTML Environment
- Work with Email and Cookies
- Consider Security Implications when using PHP and MariaDB
Contents
PHP Configuration
- Working with External Files
- Error Reporting
- Interacting with External Programs
Basic SQL Statements
- Creating Databases and Tables
- Inserting Data into Tables
- Viewing Tables
- UPDATE
- Drop
Connection to MariaDB/MySQL
- mysql_connect
- mysql_error
- mysql_select_db
- Die
Using PHP to Perform Database Functions
- Inserting Data into a Database
- Creating Queries
- Executing Queries
- Processing the Returned Query Data
- Updating the Database
Generating HTML Using PHP
- PHP Inside HTML
- HTML Form with Embedded PHP
- Multiple HTML Pages/Forms with PHP
E-Mail & Cookies Using PHP
- Generating Email using PHP
- Generating Cookies using PHP
- Using Cookies
PHP & Database Security
- Designing Databases
- Connecting to Database
- Encrypted Storage Model
- SQL Injection
- Security Techniques
- Error Reporting
- User Submitted Data
Publicly scheduled dates, locations, and prices
Select a date to enquire about availability of places. For dates after 13 August 2021, please call 0333 210 0140 or use our contact form to enquire about places and availability.
London — £745 (+VAT)
Suitable For
UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MariaDB.
Follow-On Courses
- Apache Web Server
- Introduction to MariaDB
- Perl Programming
- Python Programming
- Ruby Programming
- Ruby on Rails
Prerequisites
Attendance on the PHP Programming course or equivalent experience.