更新时间：2021-07-16 11:37:11
coverpage
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
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. CRUD Operations Sorting Filtering and Joins
String datatypes
Number datatypes
Date datatypes
The students table
Inserting data
Retrieving data
Sorting data
Filtering data
Updating data
Deleting data
Joins
Summary
Chapter 2. Advanced Programming with MariaDB
Enhancing the existing tables
Working with stored procedures
Working with stored routines
Working with triggers
Chapter 3. Advanced Programming with PHP
New features in PHP 5.4 and 5.5
Unit testing
Working with MariaDB
Chapter 4. Setting Up Student Portal
Setting up the nuts and bolts of our application
Setting up MVC
Adding a student
Listing all students
Adding a course
Listing all courses
Registering a student to a course
Viewing all registrations
Chapter 5. Working with Files and Directories
Data imports
Data exports
Logging
Chapter 6. Authentication and Access Control
Authentication
Access controls
User roles
Chapter 7. Caching
Introduction to caching
Caching in the database
Caching in the application
Advanced caching techniques
Chapter 8. REST API
What is REST?
Generating XML feeds
Generating JSON feeds
Chapter 9. Security
Securing the Apache web server
Securing MariaDB
Securing PHP
Chapter 10. Performance Optimization
Performance optimization for the Apache web server
Performance optimization for MariaDB
Performance optimization for PHP
CDN reverse proxy and database replication
Index
