Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

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

Customer Reviews

4.3 (3)

5 star

33.3%

4 star

66.7%

3 star

0%

2 star

0%

1 star

0%

String datatypes

Let us look at the following main datatypes:

Datatype	Explanation	Comments
`CHAR(L)`	This stores a fixed-length string between 0 and 255 bytes.	Trailing spaces are removed.
`VARCHAR(L)`	This stores a variable-length string between 0 and 65,535 characters.	65,535 is the effective maximum row size for table.
`TEXT`	This stores character data and the maximum length of a text column is 65,535 characters.	Length need not be specified.
`TINYTEXT`	This stores the text column with a maximum length of 255 characters.
`MEDIUMTEXT`	This stores the text column with a maximum length of 16,777,215 characters.
`LONGTEXT`	This stores the text column with a maximum length of 4,294,967,295 characters.
`BLOB`	This stores binary data and the maximum length of a text column is 65,535 bytes.	Binary Large Objects are used to store binary data such as images.
`TINYBLOB`	The `BLOB` datatype column with a maximum length of 255 bytes.
`MEDIUMBLOB`	This stores the text column with a maximum length of 16,777,215 bytes.
`LONGBLOB`	This stores the text column with a maximum length of 4,294,967,295 bytes.
`ENUM`	This provides a list of strings from which a value can be chosen.	A list of 65,535 values can be inserted into the `ENUM` datatype.
`SET`	This is similar to the `ENUM` datatype. It provides a list of strings from which zero or more values can be chosen.	Can have a maximum of 64 distinct values.

Visually different images

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