Building a Web Application with PHP and MariaDB: A Reference Guide电子书

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