Product Overview

Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition

Index Listing

Symbols

!, not operator, PHP, (Many Templates, One Controller), (Connecting to MySQL with PHP)
!=, not equal operator, PHP, (Control Structures)
$, (Variables, Operators, and Comments)
(see also variables, PHP)
prefix identifying PHP variables, (Variables, Operators, and Comments)
use in regular expressions, (Regular Expressions)
$srcurl, (Semi-dynamic Pages)
%
modulus operator, MySQL, (Mathematical Functions)
wild card for LIKE operator, (Viewing Stored Data)
wild card in hostnames, (Granting Privileges)
&&, and operator, PHP, (Control Structures)
&, query string variable separator, (User Interaction and Forms)
()
calling PHP functions, (Basic Syntax and Statements)
in regular expressions, (Regular Expressions)
*
in regular expressions, (Regular Expressions)
multiplication operator, PHP, (Variables, Operators, and Comments)
wild card in myisamchk, (Checking and Repairing MySQL Data Files)
+
addition operator, PHP, (Variables, Operators, and Comments)
in regular expressions, (Regular Expressions)
++, signifying increment by one, (Control Structures)
-
subtraction operator, PHP, (Variables, Operators, and Comments)
--delete-master-logs command, (Incremental Backups Using Binary Logs)
--flush-logs option, (Incremental Backups Using Binary Logs)
--log-bin option, (Incremental Backups Using Binary Logs)
--master-data=2 option, (Incremental Backups Using Binary Logs)
--skip-grant-tables command, (Locked Out?)
.
concatenation operator, PHP, (Variables, Operators, and Comments)
in regular expressions, (Regular Expressions)
.=, append operator, PHP, (Searching for Jokes)
/
division operator, PHP, (Variables, Operators, and Comments)
file path separator, (Assigning Unique Filenames)
// and /* */, comment indicators, PHP, (Variables, Operators, and Comments)
;
on the MySQL command prompt, (Logging On to MySQL)
terminating PHP statements, (Basic Syntax and Statements)
<, less than, PHP, (Control Structures)
<=, less than or equal to, PHP, (Control Structures)
<?php ?> code delimiters, (Introducing PHP)
=, assignment operator, PHP, (Variables, Operators, and Comments)
==, equal operator, PHP, (Control Structures)
>(=), greater than (or equal to), PHP, (Control Structures)
?
in regular expressions, (Regular Expressions)
introducing a query string, (User Interaction and Forms)
\c, on the MySQL command prompt, (Logging On to MySQL)
^, in regular expressions, (Regular Expressions)
| in regular expressions, (Regular Expressions)
||, or operator, PHP, (Control Structures)

A

absolute paths, include file location, (Shared Include Files)
access control, (Access Control)
controller code, (Controller Code)
database design, (Database Design)
function library, (Function Library)
managing passwords and roles, (Managing Passwords and Roles)
access control, MySQL, (MySQL Access Control)
anonymous user problem, (Access Control Tips)
further resource, (MySQL Access Control)
tips, (Access Control Tips)
unrestricted access, (Locked Out?)
access privileges
GRANT command and, (Granting Privileges)
level of application, (Granting Privileges)
REVOKE command and, (Revoking Privileges)
addition operator, PHP, (Variables, Operators, and Comments)
addslashes function, PHP
mysqli_escape_string and, (mysqli_real_escape_string)
administration area security, (Access Control)
administration interface
content management systems as, (A Content Management System)
managing authors example, (Managing Authors)
airline booking system example, (Column and Table Name Aliases)
aliases (temporary names), (Column and Table Name Aliases)
aliasing
columns and tables, (Column and Table Name Aliases)
summary function results, (GROUPing SELECT Results)
ALL privilege, GRANT command, (Granting Privileges)
ALTER TABLE ADD UNIQUE command, (Database Design)
ALTER TABLE command, (Giving Credit Where Credit is Due), (ALTER TABLE)
adding indexes using, (Sorting SELECT Query Results)
dropping columns, (Rule of Thumb: Keep Entities Separate)
ampersand, query string variable separator, (User Interaction and Forms)
ANALYZE TABLE command, (ANALYZE TABLE)
and operator, PHP, (Control Structures)
anonymous users, MySQL access control, (Access Control Tips)
Apache Service Monitor, (Installing PHP)
Apache web server, (All-in-one Installation), (Connecting to MySQL with PHP)
apostrophes in form fields, (User Interaction and Forms)
append operator, PHP, (Searching for Jokes)
areas of rectangles, example calculation
using a custom function, (Custom Functions and Function Libraries)
arguments, (mysqli_connect)
arithmetic operators, (Variables, Operators, and Comments)
array function, PHP, (Arrays)
arrays, (Arrays)
(see also variables, PHP)
associative, (Arrays), (Handling SELECT Result Sets)
processing when submitted, (Adding and Editing Jokes)
submitting in a form, (Adding and Editing Jokes)
super-global arrays, (Variable Scope and Global Access)
use with checkboxes, (Adding and Editing Jokes)
AS keyword, SELECT queries, (Column and Table Name Aliases)
use with summary functions, (GROUPing SELECT Results)
assignment operator, PHP, (Variables, Operators, and Comments)
associative arrays, (Arrays)
rows in result sets, (Handling SELECT Result Sets)
asterisk wild card in myisamchk, (Checking and Repairing MySQL Data Files)
AUTO_INCREMENT columns, (Creating a Table)
obtaining last assigned value, (Adding and Editing Jokes)
automatic content submission, (Real World Content Submission)

B

backslashes
avoiding in path notation, (Shared Include Files), (Assigning Unique Filenames)
escaping special characters, (Regular Expressions), (Boldface and Italic Text)
backups, MySQL
binary logs and incremental backups, (Incremental Backups Using Binary Logs)
importance of, (MySQL Administration)
inadequacy of standard file backups, (Backing Up MySQL Databases)
using mysqldump, (Database Backups Using mysqldump)
BBCode, (Boldface and Italic Text)
BINARY attribute, MySQL, (MySQL Column Types)
binary data files, (Binary Data), (PHP Script Timeout)
MySQL column types tabulated, (Binary Column Types)
binary logs, (Incremental Backups Using Binary Logs)
managing, (Incremental Backups Using Binary Logs)
BLOB (Binary Large Object) column types, (Recording Uploaded Files in the Database), (Binary Column Types), (Character Types)
boldface text, (Boldface and Italic Text), (Matching Tags)
bookmarking queries, (User Interaction and Forms)
braces, use in custom functions, (Custom Functions and Function Libraries)
brackets (see parentheses) (see square brackets)
break command, (A Simple Shopping Cart)
browsers
limits on cookies, (Cookies)
built-in functions, PHP, (Basic Syntax and Statements), (Custom Functions and Function Libraries), (PHP Functions for Working with MySQL), (mysqli_use_result)
(see also custom functions)
array function, (Arrays)
mysqli_connect, (Connecting to MySQL with PHP)
number_format, (A Simple Shopping Cart)
str_ireplace, (Paragraphs)
strlen, (Viewing Stored Files)

C

cancelling a query, (Logging On to MySQL)
caret, use in regular expressions, (Regular Expressions)
carriage returns, platform-specific issues, (Paragraphs)
Cascading Style Sheets (CSS), (Deleting Data from the Database)
case-sensitivity
function names, (Custom Functions and Function Libraries)
in SQL queries, (Logging On to MySQL)
TEXT and BLOB column types, (Binary Column Types)
categories
assigning to CMS items with PHP, (Managing Jokes)
database design and, (Many-to-Many Relationships)
managing with PHP, (Managing Categories)
CGI (Common Gateway Interface), (Shared Include Files)
character column types, MySQL, (Character Types)
checkboxes, (Managing Passwords and Roles)
passing values to variables, (Adding and Editing Jokes)
selecting multiple categories, (Adding and Editing Jokes)
checking and repairing files, (Checking and Repairing MySQL Data Files)
chmod command, (Semi-dynamic Pages)
CMS (see content management systems)
code delimiters, PHP, (Introducing PHP)
column attributes, MySQL column tyes, (MySQL Column Types)
column types, MySQL
binary data storage, (Recording Uploaded Files in the Database), (Binary Column Types)
character types, (Character Types)
date/time types, (Date/Time Types)
ENUM, (A Challenge: Joke Moderation)
full listing, (MySQL Column Types), (Date/Time Types)
INT, (Creating a Table)
numerical types, (Numerical Types)
TEXT, (Creating a Table)
TEXT vs. BLOB types, (Binary Column Types)
columns, (An Introduction to Databases), (Column and Table Name Aliases)
(see also fields)
access privileges on, (Granting Privileges)
adding, (Giving Credit Where Credit is Due)
renaming, using aliases, (Column and Table Name Aliases)
setting data types, (Creating a Table)
commands, MySQL (see queries)
comments, PHP, (Variables, Operators, and Comments)
Common Gateway Interface (CGI), (Shared Include Files)
concatenation operators, (Variables, Operators, and Comments)
concurrent operations, locking tables, (LOCKing TABLES)
conditional structures, PHP (see control structures)
configuration files, creating binary logs, (Incremental Backups Using Binary Logs)
connecting to MySQL, (Connecting to MySQL with PHP)
using global variables, (Variable Scope and Global Access)
using include files, (Including PHP Code)
using include_once, (Types of Includes)
connection identifiers (see link identifiers)
constraints
checking, search engine example, (Searching for Jokes)
foreign key constraints, (Deleting Authors)
NOT NULL constraints, (Creating a Table)
content formatting, (Content Formatting with Regular Expressions)
content management system example
adding and editing authors, (Adding and Editing Authors)
deleting authors, (Deleting Authors)
formatting stage, (Content Formatting with Regular Expressions)
front page, (The Front Page)
managing authors, (Managing Authors)
managing categories, (Managing Categories)
managing jokes, (Managing Jokes), (Deleting Jokes)
content management systems, (A Content Management System), (Summary)
content submission by visitors, (Real World Content Submission)
content-disposition header, HTTP, (Viewing Stored Files)
Content-length header, HTTP, (Viewing Stored Files)
content-type header, HTTP, (Viewing Stored Files)
control flow functions, MySQL, (Control Flow Functions)
control structures, PHP, (Control Structures)
for loops, (Control Structures)
if-else statements, (Control Structures)
short-circuit evaluation, (Assigning Unique Filenames)
while loops, (Control Structures)
controller code, (Controller Code)
cookies, (Cookies)
browser-enforced limits, (Cookies)
session alternative to, (PHP Sessions)
setting and deleting, (Cookies)
square brackets indicate optional code, (Cookies)
copy function, (Semi-dynamic Pages), (Assigning Unique Filenames)
copyright notices, (Including HTML Content)
corrupted data recovery, (Checking and Repairing MySQL Data Files)
COUNT function, MySQL, (Viewing Stored Data), (GROUPing SELECT Results), (Functions for Use with GROUP BY Clauses)
omitting NULLs, (LEFT JOINs)
count function, PHP, (A Simple Shopping Cart)
CREATE DATABASE command, (Creating a Database), (CREATE DATABASE)
CREATE INDEX command, (Sorting SELECT Query Results), (CREATE INDEX)
CREATE TABLE command, (Creating a Table), (CREATE TABLE)
binary file details, (Binary Column Types)
nondestructive alternative, (Rule of Thumb: Keep Entities Separate)
CREATE TABLE queries, (Advanced SQL Queries)
CREATE TABLE statements, (Incremental Backups Using Binary Logs)
cron utility
updating semi-dynamic pages, (Semi-dynamic Pages)
CURDATE function, MySQL, (Inserting Data into the Database)
currency information display, (A Simple Shopping Cart)
custom functions, (Custom Functions and Function Libraries), (Variable Scope and Global Access)
accessing global variables, (Variable Scope and Global Access)
difference from include files, (Variable Scope and Global Access)
function libraries and, (Custom Functions and Function Libraries)
naming, (Custom Functions and Function Libraries)
variable scope, (Variable Scope and Global Access)
custom markup languages, (String Replacement with Regular Expressions)

D

data
deleting from the database, (Deleting Data from the Database)
deleting stored, (Deleting Stored Data)
inserting into the database, (Inserting Data into the Database)
modifying stored, (Modifying Stored Data)
viewing stored, (Viewing Stored Data)
data relationships (see relationships)
data types, (Creating a Table)
(see also column types, MySQL)
PHP as a loosely-typed language, (Variables, Operators, and Comments)
database administration, (MySQL Administration), (Checking and Repairing MySQL Data Files)
database design, (Relational Database Design), (One for Many, and Many for One), (Database Design)
delete anomalies, (Rule of Thumb: Keep Entities Separate)
further resources on, (Relational Database Design)
relationships, (Simple Relationships)
update anomalies, (Rule of Thumb: Keep Entities Separate)
database servers, (An Introduction to Databases)
database, MySQL, (mysqli_connect)
database-driven web sites
role of content management systems, (A Content Management System)
role of scripting languages, (The Big Picture)
semi-dynamic pages and performance, (Semi-dynamic Pages)
databases, (An Introduction to Databases), (Connecting to MySQL with PHP)
(see also MySQL)
adding items with PHP, (Adding and Editing Authors)
binary data storage, (Recording Uploaded Files in the Database)
creating, (Creating a Database)
deleting data from, (Deleting Data from the Database)
inserting data into, (Inserting Data into the Database)
inserting data using PHP, (Inserting Data into the Database)
listing available, (Logging On to MySQL)
management using a CMS, (A Content Management System)
mysql and test databases, (Logging On to MySQL)
recording uploaded files, (Recording Uploaded Files in the Database)
selection, in PHP, (Connecting to MySQL with PHP)
storing web site content in, (An Introduction to Databases), (The Big Picture)
using, (Creating a Database)
date and time functions, MySQL, (Date and Time Functions)
CURDATE function, (Inserting Data into the Database), (Date and Time Functions)
DATE_FORMAT symbols, (Date and Time Functions)
interval types for date addition/subtraction, (Date and Time Functions)
modes for week calculation, (Date and Time Functions)
date function, PHP, (Basic Syntax and Statements)
date/time column types, MySQL, (Date/Time Types)
delete anomalies, (Rule of Thumb: Keep Entities Separate)
Delete button, (Deleting Jokes)
DELETE command, (Deleting Stored Data), (Deleting Data from the Database), (DELETE)
Delete hyperlink, (Deleting Data from the Database)
DELETE queries
confirmation page, (Deleting Authors)
rows affected by, (Deleting Stored Data), (Sending SQL Queries with PHP)
DELETE query, (Deleting Data from the Database)
deleting items with PHP, (Deleting Data from the Database), (Deleting Authors)
DESC keyword, (Sorting SELECT Query Results)
DESCRIBE command, (Creating a Table), (Giving Credit Where Credit is Due), (DESCRIBE/DESC)
DISTINCT keyword, (Rule of Thumb: Keep Entities Separate)
division operator, PHP, (Variables, Operators, and Comments)
“do nothing” WHERE clauses, (Searching for Jokes)
document root, (Shared Include Files)
document root tracking, include files, (Shared Include Files)
dollar sign
PHP variable prefix, (Variables, Operators, and Comments)
use in regular expressions, (Regular Expressions)
double equals sign, (Control Structures)
DROP DATABASE command, (Logging On to MySQL), (DROP DATABASE)
DROP INDEX command, (DROP INDEX)
DROP TABLE command, (Creating a Table), (Incremental Backups Using Binary Logs), (DROP TABLE)
recovering from unintentional, (Incremental Backups Using Binary Logs)
drop-down lists and checkboxes, (Adding and Editing Jokes)
duplication
avoiding, using DISTINCT, (Rule of Thumb: Keep Entities Separate)
avoiding, using include files, (Include Files)

E

echo statement, PHP, (Basic Syntax and Statements)
example, (Basic Syntax and Statements)
parentheses and, (Use PHP Templates)
echo statements, (The Big Picture)
enctype attribute, form tag, (Handling File Uploads)
ENUM column type, (A Challenge: Joke Moderation), (Character Types)
equal operator, PHP, (Control Structures)
equals sign, as PHP assignment operator, (Variables, Operators, and Comments)
error checking
include files and, (Including PHP Code)
using myisamchk, (Checking and Repairing MySQL Data Files)
error messages
require statement and, (Types of Includes)
simple join example, (SELECT with Multiple Tables)
errors due to file permissions, (Semi-dynamic Pages)
exclamation mark, as PHP not operator, (Many Templates, One Controller)
exit command, MySQL, (Logging On to MySQL)
exit function, PHP, (Connecting to MySQL with PHP)
expiry time, cookies, (Cookies)
EXPLAIN command, (EXPLAIN)

F

fields, (An Introduction to Databases)
(see also columns)
as database components, (An Introduction to Databases)
inadvisability of multiple values, (Simple Relationships), (Many-to-Many Relationships)
file permissions, errors due to, (Semi-dynamic Pages)
file sizes
problems with large files, (Large File Considerations)
uploading files and, (Handling File Uploads)
file_exists function, (Semi-dynamic Pages)
file_get_contents function, (Semi-dynamic Pages)
file_put_contents function, (Semi-dynamic Pages)
filenames, assigning unique, (Assigning Unique Filenames)
files, (Include Files)
(see also include files)
assigning unique names, (Assigning Unique Filenames)
downloading stored files, (Viewing Stored Files)
file access functions in PHP, (Semi-dynamic Pages)
large file considerations, (Large File Considerations)
storing in MySQL, (Storing Files)
uploaded, recording in the database, (Recording Uploaded Files in the Database)
uploading, (Handling File Uploads), (Recording Uploaded Files in the Database)
viewing stored files, (Viewing Stored Files)
Firefox, (Installation)
flow of control (see control structures)
for loops, (Control Structures)
logical flow through, (Control Structures)
forced rows, (LEFT JOINs)
foreach loop, (Handling SELECT Result Sets), (A Simple Shopping Cart)
foreign key constraints, (Deleting Authors)
form fields, apostrophes in, (User Interaction and Forms)
form tags and file uploads, (Handling File Uploads)
formatting content, (Content Formatting with Regular Expressions)
forms submission methods, (User Interaction and Forms)
forward slash path separator, (Shared Include Files), (Assigning Unique Filenames)
front pages (see index pages)
function calls used as conditions, (Connecting to MySQL with PHP)
function keyword, PHP, (Custom Functions and Function Libraries)
function libraries, PHP, (Custom Functions and Function Libraries), (Function Library)
function scoped variables, (Variable Scope and Global Access)
functions, MySQL, (MySQL Functions)
control flow functions, (Control Flow Functions)
COUNT function, (Viewing Stored Data), (GROUPing SELECT Results), (Functions for Use with GROUP BY Clauses)
date and time functions, (Date and Time Functions)
LEFT function, (Viewing Stored Data)
listed by type, (MySQL Functions), (Functions for Use with GROUP BY Clauses)
mathematical functions, (Mathematical Functions)
miscellaneous functions, (Miscellaneous Functions)
string functions, (String Functions)
use with GROUP BY clauses, (Functions for Use with GROUP BY Clauses)
functions, PHP, (Basic Syntax and Statements)
(see also built-in functions)
custom functions, (Custom Functions and Function Libraries), (Variable Scope and Global Access)
expression, (Regular Expressions)
parameters, (Basic Syntax and Statements)
return values, (Connecting to MySQL with PHP)
session management functions, (PHP Sessions)
working with MySQL, reference, (PHP Functions for Working with MySQL), (mysqli_use_result)

G

global scope, (Variable Scope and Global Access)
global statement, (Variable Scope and Global Access)
global variables, (Variable Scope and Global Access)
GRANT command, (Granting Privileges), (GRANT)
examples of use, (Granting Privileges)
“greedy” special characters, (Matching Tags)
GROUP BY clause, SELECT queries, (GROUPing SELECT Results), (SELECT)
GROUP BY clauses, (Functions for Use with GROUP BY Clauses)
group-by functions (see summary functions)

H

HAVING clause, SELECT command, (Limiting Results with HAVING), (SELECT)
header function, PHP, (Viewing Stored Files)
hidden form fields
MAX_FILE_SIZE, (Handling File Uploads)
host, MySQL, (mysqli_connect)
.htaccess file
protecting directories with, (A Content Management System)
HTML
embedding in PHP output text, (Basic Syntax and Statements)
forms, user interaction with, (User Interaction and Forms)
include files containing, (Including HTML Content)
markup, (Deleting Data from the Database)
PHP code conversion to, (Introducing PHP)
static pages from URL requests, (Semi-dynamic Pages)
tags, PHP code to match, (Matching Tags)
HTTP headers
cookie, (Cookies)
sending file details, (Viewing Stored Files)
set-cookie, (Cookies)
HTTP methods (see variables, $_GET) (see variables, $_POST)
HTTP redirect, (Inserting Data into the Database)
hyperlinks, (Deleting Data from the Database)
hyperlinks within content, (Hyperlinks)

I

ID columns, (An Introduction to Databases), (Creating a Table)
(see also primary keys)
if statements, error handling, (Connecting to MySQL with PHP)
if-else statements, (Control Structures)
importing global variables, (Variable Scope and Global Access)
include command, (Structured PHP Programming)
include files, (Include Files), (Shared Include Files)
containing HTML, (Including HTML Content)
database connection example, (Including PHP Code)
difference from custom functions, (Variable Scope and Global Access)
locating, (Shared Include Files)
naming, (Including PHP Code)
PHP statements usable with, (Types of Includes)
shared, (Shared Include Files)
include statement, PHP, (Including PHP Code)
require statement and, (Types of Includes)
include_once statement, PHP, (Types of Includes), (Custom Functions and Function Libraries)
incrementing values by one, (Control Structures), (Setting LIMITs)
index pages
as semi-dynamic pages, (Semi-dynamic Pages)
indexes, (Arrays)
adding and removing, (Sorting SELECT Query Results)
further resources on, (Sorting SELECT Query Results)
regenerating after corruption, (Checking and Repairing MySQL Data Files)
sorting and, (Sorting SELECT Query Results)
inner joins, (LEFT JOINs)
InnoDB tables, (Deleting Authors), (LOCKing TABLES)
INSERT command, (Let PHP Do the Typing), (INSERT)
REPLACE command compared to, (REPLACE)
TIMESTAMP columns and, (Date/Time Types)
two forms of, (Inserting Data into a Table)
INSERT command., (A Challenge: Joke Moderation)
INSERT function, MySQL, (String Functions)
INSERT queries, (Let PHP Do the Typing), (Inserting Data into the Database), (Rule of Thumb: Keep Entities Separate), (Adding and Editing Jokes), (Advanced SQL Queries)
rows affected by, (Sending SQL Queries with PHP)
storing uploaded files, (Storing Files)
INSERT statements, (Real World Content Submission), (Incremental Backups Using Binary Logs)
installation, (Installation)
all-in-one, (Incremental Backups Using Binary Logs)
Linux installation, (Linux Installation)
Mac OS X installation, (Mac OS X Installation)
MySQL, (Your Own Web Server), (Incremental Backups Using Binary Logs)
PHP, (Your Own Web Server)
post-installation set-up tasks, (Post-Installation Set-up Tasks)
toolbox, (Full Toolbox, Dirty Hands)
what to ask your web host, (What to Ask Your Web Host)
Windows installation, (Windows Installation)
your first PHP script, (Your First PHP Script)
your own web server, (Your Own Web Server)
INT MySQL column type, (Creating a Table), (Numerical Types)
Internet Explorer, (Installation)
INTO clause, SELECT queries, (SELECT)
is_uploaded_file function, (Assigning Unique Filenames), (Storing Files)
isset function, (Many Templates, One Controller)
italic text, (Boldface and Italic Text), (Matching Tags)

J

JavaScript, (Installation), (Introducing PHP), (User Interaction and Forms), (Cookies)
JavaScript and server-side languages, (Introducing PHP)
joins, (SELECT with Multiple Tables), (Joins)
airline booking system example, (Column and Table Name Aliases)
inner, (LEFT JOINs)
inner joins, (Joins)
left joins, (LEFT JOINs), (Joins)
MySQL supported types, (Joins)
natural joins, (Joins)
outer joins, (Joins)
self joins, (Column and Table Name Aliases)

K

killing servers, (Locked Out?)

L

LEFT function, MySQL, (Viewing Stored Data), (String Functions)
left joins, (LEFT JOINs)
LIKE operator, SQL, (Viewing Stored Data), (Searching for Jokes)
LIMIT clause, SELECT queries, (Setting LIMITs)
LIMIT command, (UPDATE)
line breaks as platform-specific issues, (Paragraphs)
link identifiers, (Connecting to MySQL with PHP)
links within content, (Hyperlinks)
Linux installation, (Linux Installation)
installing MySQL, (Installing MySQL)
installing PHP, (Installing PHP)
LOAD DATA INFILE command, (LOAD DATA INFILE)
localhost access privileges, (Access Control Tips)
LOCK TABLES command, (LOCKing TABLES), (LOCK/UNLOCK TABLES)
locking functions, MySQL, (Miscellaneous Functions)
login credentials, access control example, (Access Control)
lookup tables, (Many-to-Many Relationships)
queries using, (Many-to-Many Relationships)

M

Mac OS X installation, (Mac OS X Installation)
all-in-one installation, (All-in-one Installation)
installing individual packages, (Installing Individual Packages)
installing MySQL, (Installing MySQL)
installing PHP, (Installing PHP)
magic quotes, (User Interaction and Forms), (Inserting Data into the Database)
magic quotes feature
mysqli_escape_string and, (mysqli_real_escape_string)
MAMP, (Connecting to MySQL with PHP), (Incremental Backups Using Binary Logs)
Manage Authors, (Function Library)
many-to-many relationships, (Many-to-Many Relationships), (One for Many, and Many for One)
many-to-one relationships, (Simple Relationships), (One for Many, and Many for One)
markup languages, (String Replacement with Regular Expressions)
(see also HTML)
custom markup languages, (String Replacement with Regular Expressions)
markup, imperfect, (Deleting Data from the Database)
mathematical functions, MySQL, (Mathematical Functions)
max_allowed_packet option, my.cnf/my.ini, (MySQL Packet Size)
MAX_FILE_SIZE field, (Handling File Uploads)
MEDIUMTEXT and MEDIUMBLOB column types, (Binary Column Types)
method attribute, form tag, (User Interaction and Forms)
MIME type checking, uploadable files, (Handling File Uploads)
miscellaneous functions, MySQL, (Miscellaneous Functions)
modifying data (see UPDATE command)
multiplication operator, PHP, (Variables, Operators, and Comments)
my.cnf file, (Incremental Backups Using Binary Logs)
max_allowed_packet option, (MySQL Packet Size)
my.ini file, (Incremental Backups Using Binary Logs)
max_allowed_packet option, (MySQL Packet Size)
MyISAM table format, (Deleting Authors)
myisamchk utility, (Checking and Repairing MySQL Data Files)
MySQL, (Installation), (The Sky’s the Limit), (The End)
access control, (MySQL Access Control)
administration, (Logging On to MySQL), (MySQL Administration), (Checking and Repairing MySQL Data Files)
backing up data, (Backing Up MySQL Databases), (Incremental Backups Using Binary Logs)
command line, (Mission Accomplished)
command-line client, mysql, (Logging On to MySQL), (Incremental Backups Using Binary Logs)
connecting to a remote server, (Logging On to MySQL)
connecting to, from PHP, (Connecting to MySQL with PHP)
using global variables, (Variable Scope and Global Access)
using include files, (Including PHP Code)
using include_once, (Types of Includes)
controlling access to, (MySQL Access Control)
data directory structure, (Checking and Repairing MySQL Data Files)
data files, checking and repairing, (Checking and Repairing MySQL Data Files)
database, (mysqli_connect)
getting started with, (Introducing MySQL), (Deleting Stored Data)
host, (mysqli_connect)
installation, (Your Own Web Server), (Installing MySQL), (Installing MySQL), (Installing MySQL), (Incremental Backups Using Binary Logs)
killing server process, (Locked Out?)
link identifier, (Connecting to MySQL with PHP)
logging on to, (Logging On to MySQL)
lost password recovery, (Locked Out?)
mysql and test databases, (Logging On to MySQL)
packet size, (MySQL Packet Size)
password, (phpMyAdmin), (mysqli_connect)
password prompts, (Logging On to MySQL)
port, (mysqli_connect)
repairing corrupt data files, (Checking and Repairing MySQL Data Files)
restoring backed up data, (Database Backups Using mysqldump), (Incremental Backups Using Binary Logs)
socket, (mysqli_connect)
syntax, (MySQL Syntax Reference), (USE)
transaction support, (LOCKing TABLES)
username, (phpMyAdmin), (mysqli_connect)
MySQL column types (see column types, MySQL)
MySQL database, (Creating a Database), (Let PHP Do the Typing), (Introducing PHP), (Bring On the Database), (Publishing MySQL Data on the Web), (The Big Picture), (Mission Accomplished), (Relational Database Design), (One for Many, and Many for One)
access control and, (MySQL Access Control)
backing up, (Backing Up MySQL Databases)
backups using mysqldump, (Database Backups Using mysqldump)
function in MySQL, (Logging On to MySQL)
incremental backups using binary logs, (Incremental Backups Using Binary Logs)
MySQL functions (see functions, MySQL)
MySQL program, (Logging On to MySQL)
mysql program
restoring the database using, (Incremental Backups Using Binary Logs)
MySQL queries (see queries, MySQL)
MySQL Relational Database Management System (RDBMS), (MySQL Administration)
MySQL server, (Connecting to MySQL with PHP), (Inserting Data into the Database), (MySQL Administration), (phpMyAdmin), (Incremental Backups Using Binary Logs), (mysqli_connect)
MySQL syntax, (MySQL Syntax Reference), (USE)
ALTER TABLE, (ALTER TABLE)
ANALYZE TABLE, (ANALYZE TABLE)
CREATE DATABASE, (CREATE DATABASE)
CREATE INDEX, (CREATE INDEX)
CREATE TABLE, (CREATE TABLE)
DELETE, (DELETE)
DESCRIBE DESC, (DESCRIBE/DESC)
DROP DATABASE, (DROP DATABASE)
DROP INDEX, (DROP INDEX)
DROP TABLE, (DROP TABLE)
EXPLAIN, (EXPLAIN)
GRANT, (GRANT)
INSERT, (INSERT)
joins, (Joins)
LOAD DATA INFILE, (LOAD DATA INFILE)
LOCK/UNLOCK TABLES, (LOCK/UNLOCK TABLES)
OPTIMIZE TABLE, (OPTIMIZE TABLE)
RENAME TABLE, (RENAME TABLE)
REPLACE, (REPLACE)
REVOKE, (REVOKE)
SELECT, (SELECT)
SET, (SET)
SHOW, (SHOW)
TRUNCATE, (TRUNCATE)
unions, (Unions)
UNLOCK TABLES, (UNLOCK TABLES)
UPDATE, (UPDATE)
USE, (USE)
mysql_affected_rows function, (Sending SQL Queries with PHP)
mysql_error function, (Sending SQL Queries with PHP)
mysqladmin commands, (Logging On to MySQL)
mysqldump, (Database Backups Using mysqldump)
mysqldump utility, (Database Backups Using mysqldump)
mysqli_* functions, PHP, listed, (mysqli_affected_rows), (mysqli_use_result)
mysqli_affected_rows function, (mysqli_affected_rows)
mysqli_character_set_name function, (mysqli_character_set_name)
mysqli_close function, (mysqli_close)
mysqli_connect function, (Connecting to MySQL with PHP), (mysqli_connect)
mysqli_connect_errno function, (mysqli_connect_errno)
mysqli_connect_error function, (mysqli_connect_error)
mysqli_data_seek function, (mysqli_data_seek)
mysqli_errno function, (mysqli_errno)
mysqli_error function, (mysqli_error)
mysqli_fetch_all function, (mysqli_fetch_all)
mysqli_fetch_array function, (Handling SELECT Result Sets), (mysqli_fetch_array)
mysqli_fetch_assoc function, (mysqli_fetch_assoc)
mysqli_fetch_field function, (mysqli_fetch_field)
mysqli_fetch_field_direct function, (mysqli_fetch_field_direct)
mysqli_fetch_fields function, (mysqli_fetch_fields)
mysqli_fetch_lengths function, (mysqli_fetch_lengths)
mysqli_fetch_object function, (mysqli_fetch_object)
mysqli_fetch_row function, (mysqli_fetch_row)
mysqli_field_count function, (mysqli_field_count)
mysqli_field_seek function, (mysqli_field_seek)
mysqli_field_tell function, (mysqli_field_tell)
mysqli_free_result function, (mysqli_free_result)
mysqli_get_client_info function, (mysqli_get_client_info)
mysqli_get_client_version function, (mysqli_get_client_version)
mysqli_get_host_info function, (mysqli_get_host_info)
mysqli_get_proto_info function, (mysqli_get_proto_info)
mysqli_get_server_info function, (mysqli_get_server_info)
mysqli_get_server_version function, (mysqli_get_server_version)
mysqli_info function, (mysqli_info)
mysqli_insert_id function, (Adding and Editing Jokes), (INSERT), (mysqli_insert_id)
mysqli_num_fields function, (mysqli_num_fields)
mysqli_num_rows function, (mysqli_num_rows)
mysqli_ping function, (mysqli_ping)
mysqli_query function, (Sending SQL Queries with PHP), (mysqli_query)
insert queries, (Inserting Data into the Database)
using result sets from, (Handling SELECT Result Sets)
mysqli_real_escape_string function, (mysqli_real_escape_string)
mysqli_real_query function, (mysqli_real_query)
mysqli_select_db function, (Connecting to MySQL with PHP), (mysqli_select_db)
mysqli_set_charset function, (Connecting to MySQL with PHP), (mysqli_set_charset)
mysqli_stat function, (mysqli_stat)
mysqli_store_result function, (mysqli_store_result)
mysqli_thread_id function, (mysqli_thread_id)
mysqli_use_result function, (mysqli_use_result)

N

naming conventions
custom functions, (Custom Functions and Function Libraries)
include files, (Including PHP Code)
nested tags, (Matching Tags)
new line characters
platform-specific issues, (Paragraphs)
no browser compatibility issues, (Introducing PHP)
NOT NULL column constraint, (Creating a Table), (A Challenge: Joke Moderation)
not operator, PHP, (Many Templates, One Controller), (Connecting to MySQL with PHP)
NULL values and LEFT JOINs, (LEFT JOINs)
number_format function, PHP, (A Simple Shopping Cart)
numerical column types, MySQL, (Numerical Types)

O

one-to-many relationships, (Simple Relationships), (One for Many, and Many for One)
one-to-one relationships, (Simple Relationships)
OOP (object oriented programming), (Structured PHP Programming), (The Best Way)
operators, PHP, (Variables, Operators, and Comments)
append operator, (Searching for Jokes)
comparative and not equal operators, (Control Structures)
equal and logical operators, (Control Structures)
not operator, (Many Templates, One Controller), (Connecting to MySQL with PHP)
OPTIMIZE TABLE command, (OPTIMIZE TABLE)
optional parameters, MySQL column types, (MySQL Column Types)
or operator, PHP, (Control Structures)
ORDER BY clause, SELECT queries, (Sorting SELECT Query Results), (SELECT)

P

packet size, MySQL, (MySQL Packet Size)
paging result sets, (Setting LIMITs)
paragraph tags, custom markup language, (Paragraphs)
parameters, (Custom Functions and Function Libraries)
(see also arguments)
in PHP functions, (Basic Syntax and Statements), (Custom Functions and Function Libraries)
MySQL column types, (MySQL Column Types)
parentheses
in PHP functions, (Basic Syntax and Statements), (Custom Functions and Function Libraries)
in regular expressions, (Regular Expressions), (Hyperlinks)
password authentication, (Access Control)
password, MySQL, (mysqli_connect)
passwords
changing, using GRANT, (Granting Privileges)
instructing MySQL to prompt for, (Logging On to MySQL)
managing, (Managing Passwords and Roles)
recovery from losing, (Locked Out?)
specifying using GRANT, (Granting Privileges)
pattern modifiers, (Regular Expressions)
period
concatenation operator, PHP, (Variables, Operators, and Comments)
in regular expressions, (Regular Expressions)
personalized welcome messages, (User Interaction and Forms)
without query strings, (User Interaction and Forms)
PHP, (Basic Syntax and Statements), (Control Structures), (The Sky’s the Limit), (The End)
(see also control structures)
(see also functions, PHP)
(see also PHP installation)
and sending SQL queries, (Sending SQL Queries with PHP)
automatic disconnection, (Connecting to MySQL with PHP)
avoid advertising your technology choices, (Avoid Advertising Your Technology Choices)
basic syntax, (Basic Syntax and Statements)
code, (Including PHP Code)
code delimiters, (Introducing PHP)
commands, (The Big Picture)
configuration, (Connecting to MySQL with PHP)
error display, (Connecting to MySQL with PHP)
getting started with, (Introducing PHP), (Bring On the Database)
hiding the seams, (Hiding the Seams)
installation, (Your Own Web Server), (Installing PHP), (Installing PHP), (Installing PHP)
interpreter, (The Big Picture)
many templates, one controller, (Many Templates, One Controller)
object oriented features, (Structured PHP Programming), (The Best Way)
Perks and Pitfalls of UTF-8, (User Interaction and Forms)
programming language, (Hiding the Seams)
script, (Installation), (Let PHP Do the Typing), (The Big Picture), (PHP Script Timeout)
script timeout, (PHP Script Timeout)
security, (User Interaction and Forms)
sessions, (PHP Sessions)
templates, (Use PHP Templates), (Including HTML Content), (Structure in Practice: Template Helpers), (A Simple Shopping Cart)
PHP functions (see functions, PHP)
php.exe file, (Semi-dynamic Pages)
php.ini file
effects of disabling errors, (Types of Includes)
post_max_size setting, (Handling File Uploads)
session setup, (PHP Sessions)
upload_max_filesize setting, (Handling File Uploads)
upload_tmp_dir setting, (Handling File Uploads)
phpMyAdmin, (phpMyAdmin)
pipe character, in regular expressions, (Regular Expressions)
port, MySQL, (mysqli_connect)
post_max_size setting, php.ini file, (Handling File Uploads)
preg_match function, PHP, (Regular Expressions)
preg_replace function
example using, (Boldface and Italic Text)
preg_replace function, PHP, (String Replacement with Regular Expressions), (Hyperlinks)
str_replace and, (Paragraphs)
primary keys, (Many-to-Many Relationships)
product catalog, shopping cart example, (A Simple Shopping Cart)

Q

queries, MySQL, (Structured Query Language)
advanced SQL, (Advanced SQL Queries)
cancelling, (Logging On to MySQL)
case sensitivity, (Logging On to MySQL)
depending on lookup tables, (Many-to-Many Relationships)
search engine example, (Searching for Jokes)
semicolon terminator, (Logging On to MySQL)
sending, using PHP, (Sending SQL Queries with PHP)
query strings, (User Interaction and Forms)
question marks, introducing query strings, (User Interaction and Forms)
quit command, MySQL, (Logging On to MySQL)
quotes
double, as PHP string delimiter, (Variables, Operators, and Comments)
single, around PHP strings, (Basic Syntax and Statements)
single, around strings in PHP, (Variables, Operators, and Comments)

R

read locks, (LOCKing TABLES)
rectangles
calculate area example
using a custom function, (Custom Functions and Function Libraries)
referential integrity, (Deleting Authors)
Refresh button, (Deleting Data from the Database)
regular expressions, (Regular Expressions), (Matching Tags), (Putting It All Together)
capturing matched text, (Hyperlinks)
in double quoted strings, (Paragraphs)
matching hyperinks, (Hyperlinks)
matching paired tags, (Matching Tags)
string replacement with, (String Replacement with Regular Expressions)
validating MIME types, (Handling File Uploads)
relational database management system (RDBMS), (Installation)
relationships
example, (Rule of Thumb: Keep Entities Separate)
many-to-many relationships, (Many-to-Many Relationships)
preserving referential integrity, (Deleting Authors)
relationship types, (Simple Relationships)
RENAME TABLE command, (RENAME TABLE)
REPLACE command, (REPLACE)
require statement, PHP
include statement and, (Types of Includes)
require_once statement, PHP, (Types of Includes), (Custom Functions and Function Libraries)
required columns (see NOT NULL)
restoring MySQL databases
from mysqldump backups, (Database Backups Using mysqldump)
using binary logs, (Incremental Backups Using Binary Logs)
result sets, (Handling SELECT Result Sets)
paging, (Setting LIMITs)
processing order in MySQL, (Limiting Results with HAVING)
restricting the size of, (Setting LIMITs), (Limiting Results with HAVING)
sorting, (Sorting SELECT Query Results)
return statement, PHP, (Custom Functions and Function Libraries)
return values, PHP functions, (Connecting to MySQL with PHP)
REVOKE command, (Revoking Privileges), (REVOKE)
role-based access control, (Database Design)
role-based access control system, (Access Control)
rows, (An Introduction to Databases)
affected by deletes and updates, (Sending SQL Queries with PHP)
counting, in MySQL, (Viewing Stored Data)
deleting, (Deleting Stored Data)
updating, (Modifying Stored Data)

S

script timeouts, PHP, (PHP Script Timeout)
scripting languages, role, (The Big Picture)
search engine example, (Searching for Jokes)
security, (Database Design)
access control example, (Access Control)
upload_max_filesize setting, (Handling File Uploads)
using is_uploaded_file, (Assigning Unique Filenames)
security, PHP, (User Interaction and Forms)
SELECT command, (Viewing Stored Data), (Handling SELECT Result Sets), (SELECT), (Unions)
(see also SELECT queries)
DISTINCT keyword, (Rule of Thumb: Keep Entities Separate)
GROUP BY clause, (SELECT)
HAVING clause, (SELECT)
INTO clause, (SELECT)
LIKE operator, (Viewing Stored Data), (Searching for Jokes)
ORDER BY clause, (SELECT)
WHERE clauses, (Viewing Stored Data), (SELECT)
“do nothing” WHERE clauses, (Searching for Jokes)
select multiple tag, (Adding and Editing Jokes)
SELECT queries, (Handling SELECT Result Sets), (Deleting Data from the Database)
aliases in, (Column and Table Name Aliases)
building dynamically with PHP, (Searching for Jokes)
from multiple tables, (SELECT with Multiple Tables)
grouping results, (GROUPing SELECT Results)
limiting number of results, (Setting LIMITs), (Limiting Results with HAVING)
search engine example, (Searching for Jokes)
sorting results, (Sorting SELECT Query Results)
table joins and, (SELECT with Multiple Tables)
using result sets from, (Handling SELECT Result Sets)
with multiple tables, (SELECT with Multiple Tables)
SELECT statement, (Sorting SELECT Query Results)
SELECT statements, (Incremental Backups Using Binary Logs)
self-closing tags, (User Interaction and Forms)
semi-dynamic pages, (Semi-dynamic Pages)
semicolon
PHP statement terminator, (Basic Syntax and Statements)
semicolon, on the MySQL command prompt, (Logging On to MySQL)
server restarts
update log flushing, (Incremental Backups Using Binary Logs)
with unrestricted access, (Locked Out?)
server-side languages, (Introducing PHP)
advantages, (Introducing PHP)
server-side resources, access to, (Introducing PHP)
server-side scripting language, (Installation)
session ID, (PHP Sessions)
session management functions, PHP, (PHP Sessions)
session_destroy function, PHP, (PHP Sessions)
session_start function, PHP, (PHP Sessions), (A Simple Shopping Cart)
sessions, (PHP Sessions)
shopping cart example, (A Simple Shopping Cart)
SET command, (SET)
Set password field, (Managing Passwords and Roles)
set_time_limit function, PHP, (PHP Script Timeout)
setcookie function, PHP, (Cookies)
shopping cart example, (A Simple Shopping Cart)
product catalog, (A Simple Shopping Cart)
short-circuit evaluation, (Assigning Unique Filenames)
SHOW DATABASES command, (Logging On to MySQL)
SHOW GRANTS command, (Granting Privileges)
SHOW queries, (SHOW)
SHOW TABLES command, (Creating a Table)
SitePoint Forums, (Logging On to MySQL)
socket, MySQL, (mysqli_connect)
sorting result sets, (Sorting SELECT Query Results)
special characters
escaping, in regular expressions, (Regular Expressions), (Boldface and Italic Text), (Hyperlinks)
SQL
advanced queries, (Advanced SQL Queries)
case sensitivity in queries, (Logging On to MySQL)
column and table name aliases, (Column and Table Name Aliases)
locking tables, (LOCKing TABLES)
MySQL and, (Structured Query Language)
MySQL command syntax, (MySQL Syntax Reference), (USE)
queries, (Let PHP Do the Typing)
queries, sending with PHP, (Sending SQL Queries with PHP)
setting limits, (Setting LIMITs)
SQL injection attack, (Inserting Data into the Database)
square brackets
array indices, (Arrays)
use in regular expressions, (Regular Expressions)
square brackets indicate optional code, (Cookies)
SSIs (Server-Side Includes), (Including HTML Content)
state preservation (see cookies)
statements, PHP, (Basic Syntax and Statements)
static includes, (Including HTML Content)
static or semi-dynamic pages, (Semi-dynamic Pages)
str_ireplace function, (Paragraphs)
str_replace function, PHP, (Paragraphs)
string functions, MySQL, (String Functions)
string replacement with regular expressions, (String Replacement with Regular Expressions)
boldface and italic text, (Boldface and Italic Text)
hyperlinks, (Hyperlinks)
matching tags, (Matching Tags)
paragraphs, (Paragraphs)
putting it all together, (Putting It All Together)
strlen function, PHP, (Viewing Stored Files)
structured programming, (Structured PHP Programming), (Structure in Practice: Template Helpers)
Structured Query Language (see SQL)
subtraction operator, PHP, (Variables, Operators, and Comments)
summary functions, (Functions for Use with GROUP BY Clauses)
summary functions, MySQL, (GROUPing SELECT Results), (Functions for Use with GROUP BY Clauses)
super-global variables
super-global arrays, (Variable Scope and Global Access)

T

table formats, (Deleting Authors)
table joins (see joins)
tables
as database components, (An Introduction to Databases)
checking with myisamchk, (Checking and Repairing MySQL Data Files)
counting number of entries, (Viewing Stored Data)
creating, (Creating a Table)
deleting, (Creating a Table)
deleting entries, (Deleting Stored Data)
inserting data, (Inserting Data into a Table)
listing, (Creating a Table)
locking, (LOCKing TABLES)
recovery after corruption, (Checking and Repairing MySQL Data Files)
relationships between (see relationships)
renaming, using aliases, (Column and Table Name Aliases)
repairing damaged tables, (Checking and Repairing MySQL Data Files)
separating data with, (Rule of Thumb: Keep Entities Separate)
structural overview, (An Introduction to Databases)
temporary, (CREATE TABLE)
updating entries, (Modifying Stored Data)
using different names, (Column and Table Name Aliases)
viewing entries, (Viewing Stored Data)
Task Scheduler, Windows, (Semi-dynamic Pages)
updating semi-dynamic pages, (Semi-dynamic Pages)
templates, PHP, (Use PHP Templates)
test database, in MySQL, (Logging On to MySQL)
text formatting, (Content Formatting with Regular Expressions)
boldface and italic text, (Boldface and Italic Text)
hyperlinks, (Hyperlinks)
paragraphs, (Paragraphs)
string replacement with regular expressions, (String Replacement with Regular Expressions)
TEXT MySQL column types, (Character Types)
TEXT type, (Creating a Table)
text string, (Inserting Data into a Table)
time function, PHP
constructing unique names, (Assigning Unique Filenames)
cookie expiry and, (Cookies)
time functions, MySQL (see date and time functions)
TIMESTAMP, (Further Reading)
transactions, (LOCKing TABLES)
TRUNCATE command, (TRUNCATE)

U

unions, (Unions)
unique file names, (Assigning Unique Filenames)
unlink function, (Semi-dynamic Pages)
UNLOCK TABLES command, (LOCKing TABLES), (LOCK/UNLOCK TABLES), (UNLOCK TABLES)
unset function, PHP, (PHP Sessions), (A Simple Shopping Cart)
UNSIGNED attribute, MySQL, (MySQL Column Types)
update anomalies, (Rule of Thumb: Keep Entities Separate)
UPDATE command, (Modifying Stored Data), (UPDATE)
TIMESTAMP columns and, (Date/Time Types)
WHERE clause, (Modifying Stored Data)
UPDATE queries, (Giving Credit Where Credit is Due), (Rule of Thumb: Keep Entities Separate), (Adding and Editing Jokes)
rows affected by, (Sending SQL Queries with PHP), (UPDATE)
UPDATE statements, (Incremental Backups Using Binary Logs)
upload_max_filesize setting, php.ini file, (Handling File Uploads)
upload_tmp_dir setting, php.ini file, (Handling File Uploads)
uploading files, (Handling File Uploads), (Recording Uploaded Files in the Database)
unique file names, (Assigning Unique Filenames)
USAGE privilege, GRANT command, (Granting Privileges)
USE command, (Creating a Database), (USE)
user accounts, restricting access, (MySQL Access Control)
user interaction in PHP, (User Interaction and Forms)
user privileges
granting, (Granting Privileges)
revoking, (Revoking Privileges)
username authentication, (Access Control)
username, MySQL, (mysqli_connect)
users
removing, (Revoking Privileges)
specifying in GRANT commands, (Granting Privileges), (Access Control Tips)
UTF-8, (User Interaction and Forms)
utility programs, MySQL, (Database Backups Using mysqldump)

V

variable interpolation, (Variables, Operators, and Comments)
variable scope, (Variable Scope and Global Access)
variable-length character string, (Giving Credit Where Credit is Due)
variables, PHP, (Variables, Operators, and Comments), (Arrays)
(see also arrays)
$_COOKIE, (Cookies)
$_FILES array, (Handling File Uploads), (Storing Files)
$_GET and query strings, (User Interaction and Forms)
$_POST array, (User Interaction and Forms)
$_REQUEST array, (User Interaction and Forms)
$_SERVER array, (Inserting Data into the Database)
DOCUMENT_ROOT, (Shared Include Files)
$_SESSION array, (PHP Sessions), (A Simple Shopping Cart)
$GLOBALS array, (Variable Scope and Global Access)
custom function declarations, (Custom Functions and Function Libraries)
embedding in text strings, (Variables, Operators, and Comments)
incrementing by one, (Control Structures)
super-global arrays, (Variable Scope and Global Access)

W

WampServer, (All-in-one Installation), (Logging On to MySQL), (Connecting to MySQL with PHP), (Incremental Backups Using Binary Logs)
Web servers, (Installation), (Your Own Web Server)
restricting access to administration pages, (A Content Management System)
web servers, (A Content Management System)
(see also Apache web server)
welcome pages, personalizing, (User Interaction and Forms)
WHERE clause, (Sorting SELECT Query Results)
WHERE clauses
“do nothing” WHERE clauses, (Searching for Jokes)
SELECT command, (Viewing Stored Data), (SELECT)
simple joins, (SELECT with Multiple Tables)
UPDATE command, (Modifying Stored Data)
WHERE command, (UPDATE)
while loop, (Deleting Data from the Database)
while loops, (Control Structures)
processing result sets, (Handling SELECT Result Sets)
wild cards
control problems from, (Access Control Tips)
for LIKE operator, (Viewing Stored Data)
in hostnames, (Granting Privileges)
myisamchk utility, (Checking and Repairing MySQL Data Files)
Windows
and filename extensions, (Installing PHP)
Windows Essentials (AMD64 / Intel EM64T), (Installing MySQL)
Windows Essentials (x86), (Installing MySQL)
Windows installation, (Windows Installation)
all-in-one installation, (All-in-one Installation)
installing individual packages, (Installing Individual Packages)
installing MySQL, (Installing MySQL)
installing PHP, (Installing PHP)
Windows Task Scheduler, (Semi-dynamic Pages)
Windows x64, (Installing MySQL)
WITH GRANT OPTION clause, (Granting Privileges)
write locks, (LOCKing TABLES)

X

XHTML (Extensible HTML), (User Interaction and Forms)

Z

ZEROFILL attribute, MySQL, (MySQL Column Types)
ZEROFILL column, (MySQL Column Types)

Product Information

Features

Features

Latest Update: July 2009

  • Fully updated for PHP 5.3 and SQL 5.1.
  • Easy-to-read tutorial style
  • Free download of all code used in the book
  • No-risk money back guarantee

3rd Edition Owners

Have the 3rd edition?

Resources for the third edition are available here:

Got an older edition? Customer Support can still help you

Customer Reviews

Live, unmoderated reviews from our customers, typos and all.

If you're wanting to learn PHP/MySQL from the ground up, this is certainly the way to do it. The book came highly recommended, and I now know why.

Excellent layout, step-by-step instruction, and carefully crafted examples that really bring the points of the text home.

If you're like me, you've looked at many books on this subject. I had great difficulty finding one that not only TAUGHT me how to use PHP, but did so with real-world examples AND attention to standards!

I can't say this enough... buy it, you won't be disappointed!

Bryan D, USA 5 stars

Well Kevin you have done it again only better. I thought Vol.3 was as good as it could get but this has improved on that. The screen prints with arrows showing what to click on were a real help to me. Keep up the good work.
One critisism though ;-( Is there some way you can put on this site something to show when a URL or the filename changes as in PHP has changed from 5.2 to 5.3.
Still I would recommend this to anyone who wants to learn PHP/MySQL from the ground up.

Kenneth Hart, Canada 4.5 stars

See More Reviews or Write Your Own

 

Here are some reviews for the previous edition.

This book is pretty good, except you need to have many more example followed by what it looks like on a site when executed.

Ray Attebery, USA 3.5 stars
[written for previous edition]

It was really easy to go through the step by step. thanks a really useful book

BRUCE ANTO ANTONYAPPAN, USA 5 stars
[written for previous edition]

This publication and others I have bought from you are simply outstanding. Thank you.

Maros Kvasnak, USA 5 stars
[written for previous edition]

... each Edition time is better.

Elton Gomez, USA 5 stars
[written for previous edition]

To the point and easy to understand.
Keep up the good work.

ALAA KUTBI, USA 4 stars
[written for previous edition]

Great book, helped me get up and running very quickly. Thanks.

Guest, USA 4.5 stars
[written for previous edition]

This was just what I needed. A down to earth, lets do it kind of book. Not a lot of extra fluff.

I really enjoyed using it to create several database pages for The Weekend Chef website.

Raymond Laubert, USA 5 stars
[written for previous edition]

Very easy to read and I am in no way an expert at PHP.

I am using it in slow time and it is sinking in

Andrew Hampson, USA 5 stars
[written for previous edition]

Started with new linux server, followed steps in the book, website still not functioning at all.

Al, USA 1.5 stars
[written for previous edition]

Great resource. Excellent Shipping. Can't find a single thing to complain about... :-)

Deanna Lee, USA 5 stars
[written for previous edition]

This book is awesome. I like how it does challenge you to learn some things on your own (if you do the exercises). Overall, I think it was a great book for beginners (like me).

Geoff Owen, USA 5 stars
[written for previous edition]

good good good good good good good good good good good good good good good good good good good good good good good good good

Jennifer Householder, USA 5 stars
[written for previous edition]
Download the FREE Sample!

Product Details


Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition
[+] Enlarge Image
Edition:
4th 
Price: $39.95
Pages: 479
ISBN: 978-0-9805768-1-8
Last Updated: July 2009

Special Bonus

Bonus $9.95 PHP Poster!

FREE with every purchase of ‘Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition’ made through sitepoint.com (Hard copy only)

PHP Poster

Features:

  • Large, time-saving, format (17” x 24”)
  • Lists all the most commonly-used Array, MySQL, String functions and more.
  • Includes a complete PHP date & time format reference
  • Puts tricky Regular Expressions syntax (POSIX and PCRE) at your fingertips
  • Is ONLY available while stocks last
Take a closer look »
* Note: Hard copy purchases only

Questions?

Claim Your PDF

Bought a SitePoint PDF? Download the PDF here.

Code Archive

Bought this SitePoint book? Download it's code archive for free.

SitePoint Books

  • advocate best practice techniques
  • lead you through practical examples
  • provide working code for your web site
  • make learning easy and fun

100% Money Back Guarantee