PHP Web Development with MySQL A Hands On Approach to Application Programming

✍ Scribed by Kenneth E. Marks

• Tongue: English
• Leaves: 515
• Category: Library

✦ Table of Contents

Introduction
The Life and Times of a PHP Script
Static Vs. Dynamic Websites
The Browser and the Server
The Server and PHP
Writing Your First PHP Script
Setting Up a Development Environment
Hello World!
Exercises
Why Variables Matter
Variables in PHP
Types of Variables
Constants
Exercises
Basic String Interpretation
Concatenation
Interpolation
Escaping
Heredoc
Exercises
Operators, Expressions, and Basic Arithmetic
Operators and Expressions
Math Functions
Arrays
Simple Arrays in PHP
Associative Arrays
Adding Values
Explicit Versus Short Array Syntax
Useful Array Functions
Multidimensional Arrays
Exercises
Truth, Comparisons, Conditions, and Compound Conditions
Comparison Operators
Conditional Logic
Compound Conditional Logic Using Logical Operators
Exercises
Verifying Variables and Type Checking
Verifying Variables
Verifying and Checking Variable Types
Exercises
Looping
Counting Loops
Sentinel Loops
Exiting and Continuing a Loop
Exercises
Functions
Simple Function
Function Parameters/Arguments
Returning Values from a Function
Further Advice On Writing Good Functions
Exercises
Working with HTML Forms
A Simple Form
Processing Our Form and Outputting Back to the Web Page
Cleaning It Up Using a Self Referencing Page
Exercise: Badlibs, Part 1
Inserting Data Into a MySQL Database
Using the MySQL CLI
Create a PHP Application to Insert Data
Exercises
Returning Data from a MySQL Database
Returning Database Rows in a PHP Application
Exercise: Badlibs, Part 2
Validating Form Data and Creating Sticky Fields
Modifying FullName Behavior Based On Validation
Adding Field Validation
Making the First and Last Name Fields Sticky
Testing Our Script with Sticky Fields
Exercise: Contact Form
Displaying a List of Item Details
Designing the Database
Creating the Database
Adding Movie Data
Creating the Main Movie Listing Page
Creating the Movie Details Page
Exercises
Adding Data Using the Web Application
Creating a Page to Add Movies
Complete Code Listing
Link to the “Add a Movie” Page from the Listing Page
Exercises
Removing Data Using the Web Application
Adding Deletion Links to Movie Listings
Creating a “Remove a Movie Page”
Complete Code Listing
Exercises
Editing Data Using the Web Application
Linking Movie Details to the Edit Page
Create the Editing Page
Complete Code Listing
Exercises
Working With Files and Feature Additions to Existing Code
Add a Field for File Information
Create a Folder for Uploaded Movie Image Files
Adding File Upload Capability
Displaying Thumbnail Images of Movies on Main Page
Displaying Movie Image on Details Page
Add Image File Uploads to the Editing Page
Displaying Image on Deletion Page
Exercises
Basic HTTP Authentication
Password Protection with HTTP Authentication
How Does HTTP Authentication Work?
Create authorizeaccess.php
Adding Authorization to Pages
Exercises
Persistence
Cookies
Session Variables
Cookies and Session Variables
The Database
Best Practices in Solving the Persistence Problem
Exercises
Creating Secure Web Applications
Secure Password Protection for Authenticating
Guarding Against SQL Injection
Leaking Information to Hackers
Preventing Cross-Site Scripting Attacks
File Uploads
Securing Your Session
Final Thoughts
Exercises
Adding User Logins
Create a user Table
Create a Signup.php script
Create a login.php Script
Create a logout.php Script
Allow Users with Administrative Access
Exercises
Adding a Navigation Menu
Create Navbar Logic
Add the Navigation Bar
Add Navigation Bar to Details Page
Add Login Link to Navigation Bar
Add Logout Link to Navigation Bar
Add Sign Up Link to Navigation Bar
Add Navigation Bar to addmovie.php
Add Navigation Bar to Unauthorizedaccess.php
Add Navigation Bar to editmovie.php
Add Navigation Bar to removemovie.php
Complete Code Listings
Exercises
Adding Reservation Features
Add Number of Copies and Number Reserved
Persisting Movie Reservations for Users
Checking Movies Reserved by Users
Modify Homepage Based On Access Privileges
Refactoring to Remove Duplicate Inclusions
Script for Reserving Movies
Adding Cart to Navigation Menu
Add a Script for a Shopping Cart
Navigating to Reserved Movies
Showing and Returning Reserved Movies
Features to Add
Flaws in This Application
Exercises
Introduction to Object-Oriented Programming in PHP
Classes
Properties
Encapsulation Using Access Modifiers
Accessor Methods
The $this Variable
General Purpose Methods
Instantiating and Using a Class
Validating Input to a Setter Method
Inheritance
Overriding Methods
Constructors
Creating Parameterized Queries Using OOP
Exercises