Building a web application with PHP and MariaDB : a reference guide /: a reference guide. (2014)

• Record Type: Book
• Further Information: Note: Sai Srinivas Sriparasa.
• 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.
• Publisher Details: Birmingham : Packt Publishing
• Publication Date: 2014
• Extent: 1 online resource
• Subjects: 005.13; COMPUTERS -- Programming -- Open Source; PHP (Computer program language); Database management; Client/server computing; COMPUTERS -- Programming Languages -- C♯; COMPUTERS -- Programming Languages -- Java; COMPUTERS -- Programming Languages -- Pascal; Client/server computing; Database management; PHP (Computer program language); COMPUTERS -- Internet -- Application Development; Electronic books
• Languages: English
• ISBNs: 9781783981632; 1783981636; 9781783981625; 1783981628
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.