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

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

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

Sai Srinivas Sriparasa

1 customer reviews
Build fast, secure, and interactive web applications using this comprehensive guide
Mapt Subscription
FREE
$29.99/m after trial
eBook
$15.40
RRP $21.99
Save 29%
Print + eBook
$35.99
RRP $35.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$15.40
$35.99
$29.99p/m after trial
RRP $21.99
RRP $35.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Building a Web Application with PHP and MariaDB: A Reference Guide Book Cover
Building a Web Application with PHP and MariaDB: A Reference Guide
$ 21.99
$ 15.40
Building a Web Application with Spring and Angular [Video] Book Cover
Building a Web Application with Spring and Angular [Video]
$ 124.99
$ 106.25
Buy 2 for $32.90
Save $114.08
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781783981625
Paperback200 pages

Book Description

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.

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

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
From 1 reviews

Read More Reviews

Recommended for You

Mastering Web Application Development with AngularJS Book Cover
Mastering Web Application Development with AngularJS
$ 26.99
$ 5.40
JavaScript and JSON Essentials Book Cover
JavaScript and JSON Essentials
$ 17.99
$ 12.60
Object-Oriented JavaScript - Second Edition Book Cover
Object-Oriented JavaScript - Second Edition
$ 29.99
$ 21.00
Git: Version Control for Everyone Book Cover
Git: Version Control for Everyone
$ 23.99
$ 16.80
MEAN Web Development Book Cover
MEAN Web Development
$ 29.99
$ 3.00
Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80