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

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

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.

Suitable For

UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MariaDB.

Follow-On Courses

Prerequisites

Attendance on the PHP Programming course or equivalent experience.