Specifications

syntax
859
ordering
strcasecmp() function,
105
strcmp() function, 104
strnatcmp() function,
105
printing
formatting strings for
printing, 97-99
print() function, 97
printf() function, 98-99
sprintf() function, 98
splitting
explode() function, 102
strtok() function,
102-103
substr() function,
103-104
with regular expres-
sions, 115-116
storing, formatting strings
for storage, 100-101
substrings
accessing, 103-104
finding, 105-107,
114-115
numerical position of,
finding, 107-108
replacing, 108-109, 115
tokens, 102
stripslashes() function,
101, 233, 254, 336
strip_tags() function, 336
stristr() function, 107
strlen() function, 105
strnatcmp() function, 105
str_replace() function, 108
Stronghold, 298
Strpos() function, 107-108
Strrpos() function, 107
strstr() function, 106-107,
528
strtok() function, 102-103
strtolower() function, 100
strtoupper() function, 100
structure, content man-
agement systems, 592
Structured Query
Language. See SQL
structures
component, 467
directory, 467
component structures,
467
subclasses (object-ori-
ented development),
150, 156-157
subexpressions, 111-112
submit button, users
(votes), 421
subscribe() function, 688
subscribers, databases,
657
subscribing (MLM),
687-689
substr() function, 103-104
substrings
accessing, substr()
function, 103-104
finding, 105-107
numerical position,
107-108
strpos() function,
107-108
strrpos() function,
106-107
strstr() function,
106-107
with regular expres-
sions, 114-115
replacing, with regular
expressions, 115
substr_replace() function,
108-109
subtraction operator, 26
SUM(column) function,
221
Summary Web site, 271
superclasses (object-ori-
ented development),
150, 156-157
supporting images in PHP,
402
switch statements, 41-42
switches, mysql command
-h switch, 186
-p switch, 186
-u switch, 186
syntactic sugar, 462
syntax, 478
ADD INDEX [index] (col-
umn,...), 224
ADD PRIMARY KEY
(column,...), 224
ADD UNIQUE [index]
(column,...), 224
ADD [COLUMN] (col-
umn_description, col-
umn_description,...), 224
ADD [COLUMN] col-
umn_description [FIRST
| AFTER column ], 224
ALTER [COLUMN] col-
umn {SET DEFAULT
value | DROP
DEFAULT}, 224
CHANGE [COLUMN]
column new_column
description, 224
DESCRIBE statement, 257
DROP INDEX index, 224
DROP PRIMARY KEY,
224
DROP [COLUMN]
column, 224
extended, 222
40 7842 index 3/6/01 4:22 PM Page 859