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

Build fast, secure, and interactive web applications using this comprehensive guide

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

Learning
Sai Srinivas Sriparasa

Build fast, secure, and interactive web applications using this comprehensive guide
$21.99
$35.99
RRP $21.99
RRP $35.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781783981625
Paperback200 pages

About This Book

  • Learn how to construct scalable and secure web applications
  • Utilize PHP and MariaDB to architect and create data-driven web applications
  • Numerous real-time scenarios have been implemented as examples that will lead to a better understanding of how web applications are handled

Who This Book Is For

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.

Table of Contents

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
Summary
Chapter 3: Advanced Programming with PHP
New features in PHP 5.4 and 5.5
Unit testing
Working with MariaDB
Summary
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
Summary
Chapter 5: Working with Files and Directories
Data imports
Data exports
Logging
Summary
Chapter 6: Authentication and Access Control
Authentication
Access controls
User roles
Summary
Chapter 7: Caching
Introduction to caching
Caching in the database
Caching in the application
Advanced caching techniques
Summary
Chapter 8: REST API
What is REST?
Generating XML feeds
Generating JSON feeds
Summary
Chapter 9: Security
Securing the Apache web server
Securing MariaDB
Securing PHP
Summary
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
Summary

What You Will Learn

  • Grasp basic as well as advanced programming techniques with PHP and MariaDB
  • Perform CRUD operations, aggregations, filtering, and joins
  • Execute DDL operations and work with stored procedures, stored routines, and triggers
  • Employ concepts of object-oriented programming in PHP
  • Get acquainted with the latest features offered by PHP 5.4 and 5.5
  • Work with unit testing
  • Conduct file operations and logging with PHP
  • Implement authentication and ACLs
  • Improve performance optimization and security

In Detail

Starting with a quick refresher of the PHP language and MariaDB database, readers will explore concepts such as unit testing, session authentication and management, permissions engine, caching, security, and performance optimization. Building a Web Application with PHP and MariaDB: A Reference Guide begins with basic and advanced programming techniques in both PHP and MariaDB, followed by specialized operations such as working with files and directories. Next, you will be introduced to the concept of REST, and how principles of REST are applied to host XML and JSON feeds for others to consume. This book will show readers how to build a web application that will be an online book store. This would leverage a logging system that keeps a track of the activity that is going on in the application.

This book will help a beginner to learn the basics of object-oriented programming with PHP and help a seasoned expert to understand the intricacies of securing and speeding up their web applications.

Authors

Table of Contents

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
Summary
Chapter 3: Advanced Programming with PHP
New features in PHP 5.4 and 5.5
Unit testing
Working with MariaDB
Summary
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
Summary
Chapter 5: Working with Files and Directories
Data imports
Data exports
Logging
Summary
Chapter 6: Authentication and Access Control
Authentication
Access controls
User roles
Summary
Chapter 7: Caching
Introduction to caching
Caching in the database
Caching in the application
Advanced caching techniques
Summary
Chapter 8: REST API
What is REST?
Generating XML feeds
Generating JSON feeds
Summary
Chapter 9: Security
Securing the Apache web server
Securing MariaDB
Securing PHP
Summary
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
Summary

Book Details

ISBN 139781783981625
Paperback200 pages
Read More