Find a copy online
Links to this item
Find a copy in the library
Finding libraries that hold this item...
|Additional Physical Format:||Print version:
Sriparasa, Sai Srinivas.
Building a web application with PHP and MariaDB : a reference guide.
Birmingham, England : Packt Publishing, ©2014
|Material Type:||Document, Internet resource|
|Document Type:||Internet Resource, Computer File|
|ISBN:||9781783981632 1783981636 9781783981625 1783981628|
|Notes:||Title from PDF title page (viewed on June 26, 2014).
|Description:||1 online resource.|
|Contents:||Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: CRUD Operations, Sorting, Filtering, and Joins; String datatypes; Number datatypes; Date datatypes; The students table; The courses table; The students_courses 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 PHPNew 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 handing; 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 coursesRegistering 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; Hiding server information. Server configuration limitsSecuring 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; Index.
|Responsibility:||Sai Srinivas Sriparasa.|