PHP & MariaDB for Web Development
PHP & MariaDB for Web Development Course Overview
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.
---------------------------------------------------------------------------------------------------------------------------------------------
Who will the Course Benefit?
UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MariaDB.
----------------------------------------------------------------------------------------------------------------------------------------------
Course 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.
--------------------------------------------------------------------------------------------------------------------------------------------
This is a PHP & MariaDB for Web Development course by Uplatz.
PHP & MariaDB for Web Development
PHP & MariaDB for Web Development Training Course
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: PHP CONFIGURATION
- Working with External Files
- Error Reporting
- Interacting with External Programs
Session 2: BASIC SQL STATEMENTS
- Creating Databases and Tables
- Inserting Data into Tables
- Viewing Tables
- UPDATE
- Drop
Session 3: CONNECTING TO MariaDB/MySQL
- mysqli_connect
- mysqli_error
- Die
Session 4: USING PHP TO PERFORM DATABASE FUNCTIONS
- Inserting Data into a Database
- Creating Queries
- Executing Queries
- Processing the Returned Query Data
- Updating the Database
PHP & MariaDB for Web Development Training Course
Session 5: GENERATING HTML USING PHP
- PHP Inside HTML
- HTML Form with Embedded PHP
- Multiple HTML Pages/Forms with PHP
Session 6: EMAIL AND COOKIES USING PHP
- Generating Email using PHP
- Generating Cookies using PHP
- Using Cookies
Session 7: PHP AND DATABASE SECURITY
- Designing Databases
- Connecting to Database
- Encrypted Storage Model
- SQL Injection
- Security Techniques
- Error Reporting
- User Submitted Data