Book Image

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

By : Sai S Sriparasa
Book Image

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

By: Sai S Sriparasa

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Building a Web Application with PHP and MariaDB: A Reference Guide
Sai S Sriparasa
Jun, 2014 | 200 pages
No titles found
Table of Contents (17 chapters)
Building a Web Application with PHP and MariaDB: A Reference Guide
Building a Web Application with PHP and MariaDB: A Reference Guide
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
CRUD Operations, Sorting, Filtering, and Joins
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
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
Advanced Programming with PHP
New features in PHP 5.4 and 5.5
Unit testing
Working with MariaDB
Summary
4
Setting Up Student Portal
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
Working with Files and Directories
Data imports
Data exports
Logging
Summary
6
Authentication and Access Control
Authentication and Access Control
Authentication
Access controls
User roles
Summary
7
Caching
Caching
Introduction to caching
Caching in the database
Caching in the application
Advanced caching techniques
Summary
8
REST API
REST API
What is REST?
Generating XML feeds
Generating JSON feeds
Summary
9
Security
Security
Securing the Apache web server
Securing MariaDB
Securing PHP
Summary
10
Performance Optimization
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

Working with MariaDB

So far we have worked with core programming concepts of PHP and we have also worked with the MariaDB database server in Chapter 1, CRUD Operations, Sorting, Filtering, and Joins and Chapter 2, Advanced Programming with MariaDB. In this section, let us focus on setting up communication between PHP and MariaDB. PHP provides three APIs to connect to MariaDB; they are as follows:

API

Description

Comment

mysql

This is probably the most used API to connect to MySQL and MariaDB databases. This API has been around since PHP 2.0. Active development for this API has been stopped and it is not advised to use this API in any of new projects.

The mysql API has been deprecated since PHP 5.5.0 and will be removed in the future.

mysqli

MySQL Improved is the new API that has been introduced with PHP 5. This API is a huge upgrade over the last API. This API supports features such as client-side and server-side prepared statements, stored procedures, and transactions. This API...

Previous Section
End of Section 4
Next Section