Specifications

statements
858
echo statements, 20-21
else statements, 39-40
elseif statements, 40
exit statement, 47
EXPLAIN, 257-260
column values, 259
join types, 258
output, 257-260
GRANT, 246, 255
if statements, 38
include() statement,
127-129
INSERT, 209
LOAD DATA INFILE, 263
PHP statements, 15-16
require() statement,
119-129
auto_append_file
(php.ini file), 126-127
auto_prepend_file
(php.ini file), 126-127
filename extensions,
120-121
PHP tags, 121
Web site templates,
121-126
return statement, 140
SELECT, 211
LIMIT clause, 222
ORDER BY clause, 219
SHOW, 254-257
syntax, 255-257
SHOW COLUMNS, 255
SHOW GRANTS, 255
output, 255
SHOW TABLES, 254
switch statements, 41-42
UPDATE, 223
status, variable status, 37
STD (column) function,
221
STDDEV (column) func-
tion, 221
stock quotes, retrieving
for Web pages, 371-373
storage of files, content
management systems,
590
store account() function,
674
store list() function, 694
store_account_settings()
function, 634-635
store_new_post() func-
tion, 739, 741
stories.php, 596
stories.php files, 602-611
storing
bookmarks, 500
passwords, 252
passwords (authentica-
tion), 308-310
redundant data (Web
databases), 176-178
strings, formatting for
storage, 100-101
session IDs in cookies,
432-433
storing data, files.
See files
storing sensitive data,
secure storage, 336-337
credit card numbers, 338
story submit.php, 596
story.php, 596
strcasecmp() function, 105
strcmp() function, 104
str replace() function,
108, 761
strategies, commercial
Web sites, 280
string column types,
204-205
ENUM type, 205
regular string data types,
204
SET type, 205
TEXT types, 205
string concatenation
operator, 20-21
string operators, 27
strings
comparing, 104-105
length of strings,
testing, 105
strcasecmp() function,
105
strcmp() function, 104
strnatcmp() function,
105
evaluating, 449
formatting, 96-101
AddSlashes() function,
101
case, changing, 99-100
chop() function, 97
conversion specifica-
tions, 98-99
for printing, 97-99
for storage, 100-101
HTML formatting, 97
ltrim() function, 97
nl2br() function, 97
StripSlashes() function,
101
trim() function, 96
trimming excess
whitespace, 96-97
joining
implode() function, 102
join() function, 102
length, testing, 105
40 7842 index 3/6/01 4:22 PM Page 858