Preface
Audience
Assumptions This Book Makes
Organization of This Book
Conventions Used in This Book
Using Code Examples
O’Reilly Online Learning
How to Contact Us
Acknowledgments
1. Introduction to Dynamic Web Content
HTTP and HTML: Berners-Lee’s Basics
The Request/Response Procedure
The Benefits of PHP, MySQL, JavaScript, CSS, and HTML
MariaDB: The MySQL Clone
Using PHP
Using MySQL
Using JavaScript
Using CSS
And Then There’s HTML5
The Apache Web Server
Node.js: An Alternative to Apache
About Open Source
Bringing It All Together
Questions
2. Setting Up a Development Server
What Is a WAMP, MAMP, or LAMP?
Installing AMPPS on Windows
Testing the Installation
Accessing the Document Root (Windows)
Alternative WAMPs
Installing AMPPS on macOS
Installing a LAMP on Linux
Working Remotely
Logging In
Transferring Files
Using a Code Editor
Questions
3. Introduction to PHP
Incorporating PHP Within HTML
This Book’s Examples
The Structure of PHP
Using Comments
Basic Syntax
Variables
Operators
Variable Assignment
Multiline Strings
Variable Typing
Constants
Predefined Constants
The Difference Between the echo and print Commands
Functions
Variable Scope
Questions
4. Expressions and Control Flow in PHP
Expressions
TRUE or FALSE?
Literals and Variables
Operators
Operator Precedence
Associativity
Relational Operators
Conditionals
The if Statement
The else Statement
The elseif Statement
The switch Statement
The ? (or Ternary) Operator
Looping
while Loops
do...while Loops
for Loops
Breaking Out of a Loop
The continue Statement
Implicit and Explicit Casting
PHP Modularization
Questions
5. PHP Functions and Objects
PHP Functions
Defining a Function
Returning a Value
Returning an Array
Returning Global Variables
Recap of Variable Scope
Including and Requiring Files
The include Statement
Using include_once
Using require and require_once
PHP Version Compatibility
PHP Objects
Terminology
Declaring a Class
Creating an Object
Accessing Objects
Cloning Objects
Constructors
Destructors
Writing Methods
Declaring Properties
Static Methods
Declaring Constants
Property and Method Scope
Static Properties
Inheritance
Questions
6. PHP Arrays
Basic Access
Numerically Indexed Arrays
Associative Arrays
Assignment Using the array Keyword
The foreach...as Loop
Multidimensional Arrays
Using Array Functions
is_array
count
sort
shuffle
explode
compact
reset
end
Questions
7. Practical PHP
Using printf
Precision Setting
String Padding
Using sprintf
Date and Time Functions
Date Constants
Using checkdate
File Handling
Checking Whether a File Exists
Creating a File
Reading from Files
Copying Files
Moving a File
Deleting a File
Updating Files
Locking Files for Multiple Accesses
Reading an Entire File
Uploading Files
System Calls
Questions
8. Introduction to MySQL
MySQL Basics
Key Database Terms
Accessing MySQL via the Command Line
Starting the Command-Line Interface
Using the Command-Line Interface
MySQL Commands
Data Types
Indexes
Creating an Index
Querying a MySQL Database
Joining Tables
Using Logical Operators
MySQL Functions
Accessing MySQL via phpMyAdmin
Questions
9. Mastering MySQL
Database Design
Primary Keys: The Keys to Relational Databases
Normalization
First Normal Form
Second Normal Form
Third Normal Form
When Not to Use Normalization
Relationships
One-to-One
One-to-Many
Many-to-Many
Databases and Privacy
Transactions
Transaction Storage Engines
Using START TRANSACTION
Using COMMIT
Using ROLLBACK
Using EXPLAIN
Backing Up and Restoring
Using mysqldump
Creating a Backup File
Restoring from a Backup File
Dumping Data in CSV Format
Planning Your Backups
Questions
10. Accessing MySQL Using PHP
Querying a MySQL Database with PHP
The Process
Creating a Login File
Connecting to a MySQL Database
Building and Executing a Query
Fetching a Result
Fetching a Row While Specifying the Style
Closing a Connection
A Practical Example
The $_POST Array
Deleting a Record
Displaying the Form
Querying the Database
Running the Program
Practical MySQL
Creating a Table
Describing a Table
Dropping a Table
Adding Data
Retrieving Data
Updating Data
Deleting Data
Using AUTO_INCREMENT
Performing Additional Queries
Preventing Hacking Attempts
Steps You Can Take
Using Placeholders
Preventing JavaScript Injection into HTML
Questions
11. Form Handling
Building Forms
Retrieving Submitted Data
Default Values
Input Types
Sanitizing Input
An Example Program
Questions
12. Cookies, Sessions, and Authentication
Using Cookies in PHP
Setting a Cookie
Accessing a Cookie
Destroying a Cookie
HTTP Authentication
Storing Usernames and Passwords
An Example Program
Using Sessions
Starting a Session
Ending a Session
Setting a Timeout
Session Security
Questions
13. Exploring JavaScript
Outputting the Results
Using console.log
Using alert
Writing into Elements
Using document.write
JavaScript and HTML Text
Using Scripts Within a Document Head
Including JavaScript Files
Debugging JavaScript Errors
Using Comments
Semicolons
Variables
String Variables
Numeric Variables
Arrays
Operators
Arithmetic Operators
Assignment Operators
Comparison Operators
Logical Operators
Incrementing, Decrementing, and Shorthand Assignment
String Concatenation
Escape Characters
Variable Typing
Functions
Global Variables
Local Variables
Using let
Using const
The Document Object Model
Another Use for the $ Symbol
Using the DOM
Questions
14. Expressions and Control Flow in JavaScript
Expressions
Literals and Variables
Operators
Operator Precedence
Associativity
Relational Operators
Using onerror
Using try...catch
Conditionals
The if Statement
The else Statement
The switch Statement
The ? Operator
Looping
while Loops
do...while Loops
for Loops
Breaking Out of a Loop
The continue Statement
Explicit Casting
Questions
15. JavaScript Functions, Objects, and Arrays
JavaScript Functions
Defining a Function
Returning a Value
Returning an Array
JavaScript Objects
Declaring a Class
Creating an Instance
Accessing Objects
Static Methods and Properties
The Legacy Objects Simulated with Functions
JavaScript Arrays
Arrays
Associative Arrays
Multidimensional Arrays
Using Array Methods
Anonymous Functions
Arrow Functions
Questions
16. JavaScript and PHP Validation and Error Handling
Validating User Input with JavaScript
The validate.html Document (Part 1)
The validate.html Document (Part 2)
Regular Expressions
Matching Through Metacharacters
Wildcard Matching
Grouping Through Parentheses
Character Classes
Indicating a Range
Negation
Some More Complicated Examples
Summary of Metacharacters
General Modifiers
Using Regular Expressions in JavaScript
Using Regular Expressions in PHP
Redisplaying a Form After PHP Validation
Questions
17. Using Asynchronous Communication
The Fetch API
Your First Asynchronous Program
The Server Half of the Asynchronous Process
Cross-Origin Resource Sharing (CORS)
Using GET Instead of POST
Sending JSON Requests
Using XMLHttpRequest
Using Frameworks for Asynchronous Communication
Questions
18. Advanced CSS
Attribute Selectors
The ^= Operator
The $= Operator
The *= Operator
The box-sizing Property
CSS Backgrounds
The background-clip Property
The background-origin Property
The background-size Property
Using the auto Value
Multiple Backgrounds
CSS Borders
The border-color Property
The border-radius Property
Box Shadows
Element Overflow
Multicolumn Layout
Colors and Opacity
HSL Colors
HSLA Colors
RGB Colors
RGBA Colors
The opacity Property
Text Effects
The text-shadow Property
The text-overflow Property
The word-wrap Property
Web Fonts
Google Web Fonts
Transformations
Transitions
Properties to Transition
Transition Duration
Transition Delay
Transition Timing
Shorthand Syntax
Flexbox
Flex Items
Flow Direction
Justifying Content
Aligning Items
Aligning Content
Resizing Items
Flex Wrap
Order
Item Gaps
CSS Grid
Grid Container
Grid Columns and Rows
Grid Flow
Placing Grid Items
Grid Gaps
Alignment
Questions
19. Accessing CSS from JavaScript
Revisiting the getElementById Function
The byId Function
The style Function
The by Function
Including the Functions
Accessing CSS Properties from JavaScript
Some Common Properties
Other Properties
Inline JavaScript
The this Keyword
Attaching Events to Objects in a Script
Attaching to Other Events
Adding New Elements
Removing Elements
Alternatives to Adding and Removing Elements
Time-based Events
Using setTimeout
Using setInterval
Using Time-Based Events for Animation
Questions
20. Introduction to React
What Is the Point of React Anyway?
Accessing the React Files
Including babel.js
Our First React Project
Using a Class Instead of a Function
Pure and Impure Code: A Golden Rule
Using Both a Class and a Function
Props and Components
The Differences Between Using a Class and a Function
React State and Life Cycle
Events in React
Inline JSX Conditional Statements
Using Lists and Keys
Unique Keys
Handling Forms
Using Text Input
Using textarea
Using select
React Native
Questions
21. Introduction to Node.js
Installing Node.js on Windows
Installing Node.js on macOS
Installing Node.js on Linux
Getting Started with Node.js
Building a Functioning Web Server
Working with Modules
Built-in Modules
Installing Modules with npm
Accessing MySQL
Further Information
Questions
22. Bringing It All Together
Designing a Social Networking App
Online Repository
functions.php
header.php
setup.php
index.php
signup.php
Checking for Username Availability
Logging In
checkuser.php
login.php
profile.php
Adding the “About Me” Text
Adding a Profile Image
Processing the Image
Displaying the Current Profile
members.php
Viewing a User’s Profile
Adding and Dropping Friends
Listing All Members
friends.php
messages.php
logout.php
styles.css
javascript.js
Questions
A. Solutions to the Chapter Questions
Index
About the Author
Colophon
