Cargando…
Building a web application with PHP and MariaDB : a reference guide /
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. If you are a developer who wants to use PHP and MariaDB to...
| Clasificación: | Libro Electrónico |
|---|---|
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2014.
|
| Colección: | Community experience distilled
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- 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.