III
Contents
The Missing Credits ....................................... vii
Introduction
............................................... xi
Part One: PHP and MySQL Basics
CHAPTER 1:
PHP: What, Why, and Where? .............................. 3
Gathering Your Tools ................................................3
Writing Your First Program. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Running Your First Program .........................................16
Writing Your Second Program .......................................17
Upload Your HTML, CSS, and PHP ...................................20
Running Your Second Program ......................................21
CHAPTER 2:
PHP Syntax: Weird and Wonderful ........................ 25
Get Information from a Web Form ...................................25
Working with Text in PHP ...........................................32
The
$_REQUEST
Variable ...........................................46
What Do You Do with User Information? ..............................53
CHAPTER 3:
MySQL and SQL: Database and Language................. 55
What Is a Database?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
Installing MySQL ...................................................59
SQL Is a Language for Talking to Databases ...........................76
Part Two: Dynamic Web Pages
CHAPTER 4:
Connecting PHP to MySQL ................................ 91
Writing a Simple PHP Connection Script ..............................91
Cleaning Up Your Code with Multiple Files ...........................103
Building a Basic SQL Query Runner .................................109
CHAPTER 5:
Better Searching with Regular Expressions .............. 127
String Matching, Double-Time ......................................128
