Specifications
statements
857
software, errors (security
threats), 288-289
software engineering,
460-462
defined, 460-462
software errors (commer-
cial Web sites), 279
solution components,
user personalization,
499-500
sort() function, 79
sorting
associative arrays, 79-80
asort() function, 79-80
ksort() function, 79-80
reverse sort functions,
80
sort() function, 79
multidimensional arrays,
80
reverse sorts, 82
user defined sorts,
80-82
Source Forge Web site,
806
SourceForge Web site,
389, 470
spam, reverse spam, 287
special characters
literal special characters,
112
regular expressions, 113
special privileges, 191
specifications (CGI), 368
split() function, 115-116,
614
splitting strings
explode() function, 102
strtok() function, 102-103
substr() function, 103-104
with regular expressions,
115-116
sprintf() function, 98
SQL (Structured Query
Language), 208
ANSI standard, Web site,
226
Book-O-Rama database
setting up, 208
tables, code to
populate, 210
data, inserting into
databases, 209-211
databases, 208
data, aggregating,
220-222
data, grouping,
220-222
data, inserting,
209-211
data, retrieving,
211-212
data, retrieving from
multiple tables,
214-219
data, retrieving in a
particular order,
219-220
data, retrieving with
specific criteria,
212-214
dropping, 226
joins, 219
records, deleting, 225
records, updating, 223
rows unmatched,
217-218
rows, returning,
222-223
tables, aliases, 218-219
tables, altering,
223-225
tables, dropping, 226
tables, joining, 216-217
two-table joins,
214-216
MySQL
aggregate functions,
221
join types, 219
RDBMSs (relational
database management
systems), 208
resources, 806
SQL commands, CREATE
TABLE command,
194-195
SQL Course Web site, 806
SQL Pro Web site, 806
SQL tutorial Web site, 806
SSL (Secure Sockets
Layer), 285, 331-335, 782
compression, 335
encryption, 346-347
handshaking, 334
installing, 783-787
protocol stacks, 333
sending data, 334-335
testing, 792-793
standards, code, 463
starting sessions, 433
startup parameters, 794
stat() function, 364
statements
ALTER TABLE, 223
syntaxes, 224
break statement, 47
continue statement, 47
DELETE, 225
DESCRIBE, 257
syntax, 257
describe user [edit, OK],
247
DROP DATABASE, 226
DROP TABLE, 226
40 7842 index 3/6/01 4:22 PM Page 857