Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

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

By : Sai S Sriparasa

4.3 (3)

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

4.3 (3)

By: Sai S Sriparasa

Overview of this book

This is a step-by-step, tutorial guide designed to help readers transition from beginners to more experienced developers using clear explanations. The variety of examples will help readers build, secure, and host real-time web applications. If you are a developer who wants to use PHP and MariaDB to build web applications, this book is ideal for you. Beginners can use this book to start with the basics and learn how to build and host web applications. Seasoned PHP Developers can use this book to get familiar with the new features of PHP 5.4 and 5.5, unit testing, caching, security, and performance optimization.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. CRUD Operations, Sorting, Filtering, and Joins

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

2. Advanced Programming with MariaDB

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

3. Advanced Programming with PHP

New features in PHP 5.4 and 5.5

Unit testing

Working with MariaDB

Summary

4. Setting Up Student Portal

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

Summary

5. Working with Files and Directories

5. Working with Files and Directories

Data imports

Data exports

Logging

Summary

6. Authentication and Access Control

6. Authentication and Access Control

Authentication

Access controls

User roles

Summary

7. Caching

7. Caching

Introduction to caching

Caching in the database

Caching in the application

Advanced caching techniques

Summary

8. REST API

8. REST API

What is REST?

Generating XML feeds

Generating JSON feeds

Summary

9. Security

9. Security

Securing the Apache web server

Securing MariaDB

Securing PHP

Summary

10. Performance Optimization

10. Performance Optimization

Performance optimization for the Apache web server

Performance optimization for MariaDB

Performance optimization for PHP

CDN, reverse proxy, and database replication

Summary

Index

Index

Summary

In this chapter, we have covered the basics of relational database management systems with MariaDB. We began by building our first database, and performed Create, Read, Update, and Delete (CRUD) operations. We used the SQL SELECT statement to retrieve data and used the ORDER BY and WHERE statements to sort and filter the data respectively. Later, we moved on to use the UPDATE and DELETE statements to modify and remove data respectively. Finally, we used the INNER JOIN to retrieve data from multiple tables and coupled that with the WHERE statement to filter that data.

In the next chapter, we will be going over more advanced topics such as creating calculated fields and building complex views, stored procedures, functions, and triggers.

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

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

Search

Your notes and bookmarks