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

Building a Web Application with PHP and MariaDB: A Reference Guide
eBook: $21.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $57.98    Print cover: $35.99
save 6%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 200 pages [ 235mm x 191mm ]
Release Date : June 2014
ISBN : 1783981628
ISBN 13 : 9781783981625
Author(s) : Sai Srinivas Sriparasa
Topics and Technologies : All Books, Application Development, Web Development, Open Source

Table of Contents

Chapter 1: CRUD Operations, Sorting, Filtering, and Joins
Chapter 2: Advanced Programming with MariaDB
Chapter 3: Advanced Programming with PHP
Chapter 4: Setting Up Student Portal
Chapter 5: Working with Files and Directories
Chapter 6: Authentication and Access Control
Chapter 7: Caching
Chapter 8: REST API
Chapter 9: Security
Chapter 10: Performance Optimization
  • Chapter 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
  • Chapter 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
  • Chapter 7: Caching
    • Introduction to caching
    • Caching in the database
    • Caching in the application
    • Advanced caching techniques
    • Summary
  • Chapter 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
  • Chapter 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

Sai Srinivas Sriparasa

Sai Srinivas Sriparasa is a web developer and an open-source evangelist living in the Atlanta area. He was the lead developer for building Dr. Oz's website and currently works on predictive analysis algorithms for News Distribution Network (NDN). He has previously led teams for companies such as Sprint Nextel, West Interactive, Apple, and SAC Capital. His repertoire includes PHP, Python, MySQL, MariaDB, MongoDB, Hadoop, JavaScript, HTML5, Responsive Web Development, ASP.NET, C#, Silverlight, and so on. He has worked on books such as JavaScript and JSON Essentials, Packt Publishing.

Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Building a Web Application with PHP and MariaDB: A Reference Guide +    Haskell Data Analysis Cookbook =
50% Off
the second eBook
Price for both: $39.05

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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.


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.

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.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software