Building a Web Application with PHP and MariaDB: A Reference Guide -- Table of Contents -- Building a Web Application with PHP and MariaDB: A Reference Guide -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers, and more -- Why subscribe? -- Free access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. CRUD Operations, Sorting, Filtering, and Joins -- String datatypes -- Number datatypes -- Date datatypes -- The students table -- The courses table -- The students_courses table -- Inserting data -- Retrieving data -- Sorting data -- Filtering data -- Updating data -- Deleting data -- Joins -- Summary -- 2. Advanced Programming with MariaDB -- Enhancing the existing tables -- Working with stored procedures -- Working with stored routines -- Working with triggers -- Summary -- 3. Advanced Programming with PHP -- New features in PHP 5.4 and 5.5 -- Updated array declaration -- The array dereferencing function -- The list() function in the foreach statement -- Availability of this in closures -- Class member access on instantiation -- Generators -- Traits -- Addition of the finally block to exception handling -- Unit testing -- Installing PHPUnit -- Working with MariaDB -- PHP - mysqli -- PHP - PDO -- Summary -- 4. Setting Up Student Portal -- Setting up the nuts and bolts of our application -- Setting up URL rewrite -- Setting up MVC -- Adding a student -- Listing all students -- Adding a course -- Listing all courses -- Registering a student to a course -- Viewing all registrations -- Summary -- 5. Working with Files and Directories -- Data imports -- Data exports -- Logging -- Summary.

6. Authentication and Access Control -- Authentication -- Access controls -- User roles -- Summary -- 7. Caching -- Introduction to caching -- Caching in the database -- Caching in the application -- Advanced caching techniques -- Summary -- 8. REST API -- What is REST? -- Generating XML feeds -- Generating JSON feeds -- Summary -- 9. Security -- Securing the Apache web server -- Hiding server information -- Server configuration limits -- Securing MariaDB -- Password-protected access -- Building views to restrict access -- Creating users and granting access -- Securing PHP -- Summary -- 10. Performance Optimization -- Performance optimization for the Apache web server -- Disabling unused modules -- Using compression -- Caching -- Performance optimization for MariaDB -- Best practices for data retrieval -- Understanding query execution -- Query optimization and indexing -- Performance optimization for PHP -- CDN, reverse proxy, and database replication -- Summary -- Index.