The Joy of PHP · A Beginner's Guide to Programming Interactive Web Applications With PHP and mySQL by Forbes, Alan -- Read -- Imperial Library of Trantor

Index

Table of Contents Introduction

Introduction

What is PHP?

Introducing PHP Example A little history

Installing and Configuring PHP

Introduction Windows Users Using Wampserver Mac Users How Do I Know it is Working? Oracle VM Virtual Box Installing for a Web Site Exercise

Introduction to HTML

Introduction Basic HTML Basic Elements of HTML

Tags Nested Tags

Required tags

DocType Head

Optional Tags

Meta Tags

Useful Tags

Headers DIV Images/Picture Links Lists

Exercise HTML Tables

HTML Table Headers

HTML Forms

The Input tag HTML Form Actions & Methods

Introduction - Basic PHP Syntax Your first PHP-enabled page – Hello World!

Some Fun Right Away

A Countdown Counter Exercise

Editors and Staying Organized

Editors

Microsoft Expression Web PhpDesigner EditRocket

Free Editors Includes

Basic example HTML example Code example Best Practices

Variables, Numbers, Dates, and Strings

Variables Variable Naming Conventions and Best Practices Numbers

Basic Arithmetic Common Arithmetic Shortcuts Useful Numeric Functions

Strings

Useful String Functions

Sources of Documentation

Exercise How to Interpret PHP.NET documentation Return Value Function Name Parameters

Dates

Example: Calculating Age in Years

Variable Scope

Control Structures

Introduction if if... else Exercise: Open Hours PHP Switch PHP Looping

PHP while PHP for

How to use a database, such as mySQL

Introduction What are Databases? Getting Started with phpMyAdmin

What is phpMyAdmin? Using phpMyAdmin to create a database Introduction to SQL Using phpMyAdmin to create a Table in a database

Defining our first table

What defines an automobile?

Datatypes

Numbers Characters Dates Exercise: Create a Table

Working with SQL Statements

INSERT Statements SELECT Statements WHERE Statements Comparison Operators ORDER BY UPDATE Statements DELETE Statements

Using mySQL and PHP Together

Introduction Code!

Code Listing: createdb.php

Code Explained: createdb.php

Hey, where's the HTML?

Creating forms to Display, Add, Edit, and Delete data

Introduction Forms that Add Data to a Database

A Basic Form HTML Code Form Action PHP Code

A Brief Time Out...include files and SQL Injection

Include Files SQL Injection

Forms that Display Summary Data Code

Code Explained Exercise: Tweaking the SELECT Improving the look of the table with CSS CSS Explained Modifying the form to link to the detail page

Forms that Display Detail Data

Code Code Explained

Forms that Edit Data Forms that Delete Data

Code to delete data

Code Explained Exercise

Session Variables

Introduction Sessions Starting a PHP Session Using Session Variables

Store a variable Retrieve a variable Checking for a variable Destroying a Session

Working with Images

Introduction

Exercise: Viewing Images

Pulling an unknown number of images from a database

Exercise: Create a Database Table to store images Exercise: Modify the viewcar.php page to show multiple images

Code explained

PHP File Uploads

Introduction Create an Upload File form Create a Script to Process the Uploaded File Code: ViewCarsAddImage.php Code Explained

PHP Quirks and Tips

Introduction Single Quotes vs Double Quotes The Equal Sign Comparison Operators

Security Considerations

Introduction Balancing Security and Usability SQL Injection Additional Resources

Appendix A: Installing PHP on a Website

How to install on a Windows Server How to install on a Linux Server

Author's Note A Note from one of my Kickstarter Backers....

- Pasha Kagan, soon-to-be PHP Developer

← Prev
Back
Next →

← Prev
Back
Next →