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

About the Author

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.

I want to convey my sincere thanks to the team at Packt Publishing for making this book possible: Shaon, Sageer, and Sumeet in particular. This is my second book, so I want to thank all of the readers in advance for taking time to read my book. Please contact me on my LinkedIn profile, http://www.linkedin.com/in/saisriparasa, for networking or any questions that you have.

My acknowledgement section will not be complete unless I thank my mom, dad, and my sister for all their patience and support throughout my life. I hope you all enjoy this book as much as I did and wish me luck for my next book.

Previous Section
Next Chapter