5. Interacting with a Database | PHP 7 Programming Cookbook

Book Overview & Buying
Table Of Contents
Feedback & Rating

PHP 7 Programming Cookbook

By : Bierer

4.1 (8)

Buy this Book

PHP 7 Programming Cookbook

4.1 (8)

By: Bierer

Buy this Book

Overview of this book

PHP 7 comes with a myriad of new features and great tools to optimize your code and make your code perform faster than in previous versions. Most importantly, it allows you to maintain high traffic on your websites with low-cost hardware and servers through a multithreading web server. This book demonstrates intermediate to advanced PHP techniques with a focus on PHP 7. Each recipe is designed to solve practical, real-world problems faced by PHP developers like yourself every day. We also cover new ways of writing PHP code made possible only in version 7. In addition, we discuss backward-compatibility breaks and give you plenty of guidance on when and where PHP 5 code needs to be changed to produce the correct results when running under PHP 7. This book also incorporates the latest PHP 7.x features. By the end of the book, you will be equipped with the tools and skills required to deliver efficient applications for your websites and enterprises.

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Free Chapter

1. Building a Foundation

Introduction

PHP 7 installation considerations

Using the built-in PHP web server

Defining a test MySQL database

Installing PHPUnit

Implementing class autoloading

Hoovering a website

Building a deep web scanner

Creating a PHP 5 to PHP 7 code converter

2. Using PHP 7 High Performance Features

Introduction

Understanding the abstract syntax tree

Understanding differences in parsing

Understanding differences in foreach() handling

Improving performance using PHP 7 enhancements

Iterating through a massive file

Uploading a spreadsheet into a database

Recursive directory iterator

3. Working with PHP Functional Programming

Introduction

Developing functions

Hinting at data types

Using return value data typing

Using iterators

Writing your own iterator using generators

4. Working with PHP Object-Oriented Programming

Introduction

Developing classes

Extending classes

Using static properties and methods

Using namespaces

Defining visibility

Using interfaces

Using traits

Implementing anonymous classes

5. Interacting with a Database

Introduction

Using PDO to connect to a database

Building an OOP SQL query builder

Handling pagination

Defining entities to match database tables

Tying entity classes to RDBMS queries

Embedding secondary lookups into query results

Implementing jQuery DataTables PHP lookups

6. Building Scalable Websites

Introduction

Creating a generic form element generator

Creating an HTML radio element generator

Creating an HTML select element generator

Implementing a form factory

Chaining $_POST filters

Chaining $_POST validators

Tying validation to a form

7. Accessing Web Services

Introduction

Converting between PHP and XML

Creating a simple REST client

Creating a simple REST server

Creating a simple SOAP client

Creating a simple SOAP server

8. Working with Date/Time and International Aspects

Introduction

Using emoticons or emoji in a view script

Converting complex characters

Getting the locale from browser data

Formatting numbers by locale

Handling currency by locale

Formatting date/time by locale

Creating an HTML international calendar generator

Building a recurring events generator

Handling translation without gettext

9. Developing Middleware

Introduction

Authenticating with middleware

Using middleware to implement access control

Improving performance using the cache

Implementing routing

Making inter-framework system calls

Using middleware to cross languages

10. Looking at Advanced Algorithms

Introduction

Using getters and setters

Implementing a linked list

Building a bubble sort

Implementing a stack

Building a binary search class

Implementing a search engine

Displaying a multi-dimensional array and accumulating totals

11. Implementing Software Design Patterns

Introduction

Creating an array to object hydrator

Building an object to array hydrator

Implementing a strategy pattern

Defining a mapper

Implementing object-relational mapping

Implementing the Pub/Sub design pattern

12. Improving Web Security

Introduction

Filtering $_POST data

Validating $_POST data

Safeguarding the PHP session

Securing forms with a token

Building a secure password generator

Safeguarding forms with a CAPTCHA

Encrypting/decrypting without mcrypt

13. Best Practices, Testing, and Debugging

Introduction

Using Traits and Interfaces

Universal exception handler

Universal error handler

Writing a simple test

Writing a test suite

Generating fake test data

Customizing sessions using session_start parameters

A. Defining PSR-7 Classes

Introduction

Implementing PSR-7 value object classes

Developing a PSR-7 Request class

Defining a PSR-7 Response class

Index

Customer Reviews

4.1 (8)

5 star

62.5%

4 star

12.5%

3 star

2 star

25%

1 star

Class	Functionality
`PDO`	Maintains the actual connection to the database, and also handles low-level functionality such as transaction support
`PDOStatement`	Processes results
`PDOException`	Database-specific exceptions
`PDODriver`	Communicates with the actual vendor-specific database

PHP 7 Programming Cookbook

By : Bierer

PHP 7 Programming Cookbook

By: Bierer

Overview of this book

Using PDO to connect to a database

How to do it...

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access