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.
Course overview:
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Course objectives:
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.
COURSE PREREQUISITES:
Not available. Please contact.
Course content:
PHP & MariaDB for Web Development Training Course Course Contents – DAY 1 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 Course Contents – DAY 2 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
Target audience:
Who will the Course Benefit? UNIX and Windows Users,Web Developers and Programmers wishing to create web based systems utilising PHP and MariaDB.