Higher PHP Book8+
Functions
Introduction
Anonymous Functions
External Variables of Anonymous Functions
Getting External Variables of Anonymous Functions
Modifying External Variables of Anonymous Functions
Variable Before Calling an Anonymous Function
Value Type of an Anonymous Function
Arrow Functions
External Variables of Arrow Functions
Calling a Function by Name
Callback Functions
Callbacks in Built-in Functions
JSON Format
Introduction
Data in JSON
Data from JSON
Objects from JSON
Objects from JSON to Associative Arrays
Sending Data in JSON Format
Incorrect JSON
JSON Parser Errors
XML Format
Introduction
XML Tag Text
Texts of an XML Tag Group
XML Tag Attributes
Attributes of an XML Tag Group
Nested XML Tag
XML Tag Group with Nesting
XML Tag Names with Hyphens
CURL Library
Introduction
Response into a Variable
Checking Response for Errors
Following Redirects
Working with HTTPS
Browser Emulation
Sending Data via POST Method
Sending Cookies
Sending Cookies Back
Setting HTTP Headers
Working with API
Introduction
Preparation for Learning
API with a Single URL
API Multiple URLs
API with a GET Parameter
API with Multiple GET Parameters
API Outputting JSON
API with POST Parameters
API with POST Parameters in JSON Format
API and DB
API for CRUD Operations
API with Authorization
API with SEO-friendly URLs
REST API
Using Third-Party APIs
SQL Security in PHP
Introduction
Test Tables
Comments in an SQL Query
Quotes in SQL Queries
SQL Injection into a String Parameter
SQL Injection into a Numeric Parameter
Turning Off Database Errors
Value Substitution
List of Values
List of Fields
Dynamic Query Formation
Viewing Others' Data
Working with PDO
Introduction
Test Table
Connection
Queries
Query Problems
Prepared Statements
Positional Placeholders
Named Placeholders
Auto-Wrapping Placeholders in Quotes
Positional Variable Binding
Named Variable Binding
Getting a Single Field
All Rows from the Result
Multiple Execution
Working with the LIKE Operator
Working with the LIMIT Operator
Optimization
Website Loading Speed Factors
Available Resources
Optimizing Repeated Operations
Optimizing Repetition of Heavy Operations
Optimizing Cyclic Operations
Unnecessary Array Length Calculation in a Loop
Optimizing Unnecessary Loop Iterations
Optimization via Built-in Functions
Choosing the Optimal Algorithm
Optimizing Regular Expression Usage
Optimizing SQL Query Usage
Optimizing Memory Consumption
Optimizing Unnecessary Arrays
Optimizing Array Conversion