Specifications
columns
816
columns
DESCRIBE statement, 257
values, EXPLAIN state-
ment, 259
columns (tables), 173
keys, 173-175
creating for Web
databases, 179
foreign keys, 175
values, atomic column val-
ues, 178
columns_priv table,
247-250
mysql database, 250
combination assignment
operators, 28
comma operator, 32
commands
configure, 785
DESCRIBE command,
198-199
GRANT, 188-189,
192-193, 246
mysql command, 186
NET START MySQL, 794
phpinfo() command, 25
REVOKE command,
192-193
running on Web servers,
functions, 365-367
SHOW command, 198-199
SQL commands, CREATE
TABLE command,
194-195
traceroute (UNIX), 285
commenting code, 465
comments, 16-17
commercial Web sites,
268-280
adding value to goods or
services, 276
authentication, 284
cutting costs, 276-277
firewalls, 300
importance of stored infor-
mation, 282-283
online brochures, 269-271
common pitfalls,
269-271
tracking success of
sites, 270-271
orders for goods or
services, 271-275
obstacles to potential
customers, 273-275
privacy policies, 273
providing services and
digital goods, 275-276
risks, 277-280
competition, 278
computer hardware
failure, 278
crackers, 277-278
failure to attract
business, 278
legislation and taxes,
279
service provider
failures, 278
software errors, 279
system capacity limits,
279
Secure Electronic
Transaction standard,
290
security, 282-291
authentication, 291-293
backing up data, 301
Certificate Signing
Request (CSR), 299
Certifying Authorities
(CAs), 297
compromises, 290
Denial of Service
(DoS), 287
digital certificates,
297-298
digital signatures,
296-297
encryption, 293-296
errors in software,
288-289
exposure of confidential
data, 283-285
hash function, 296
log files, 299-300
loss or destruction of
data, 285-286
modification of data,
286
passwords, 291-292
physical security, 302
repudiation, 289-290
Secure Web servers,
298-299
security policies, creat-
ing, 291
threats, 283-290
strategies, selecting, 280
user interface design, 274
comparing
Apache for Windows and
UNIX, 798-799
Strings, 104-105
Length, testing, 105
Strcasecmp() function,
105
Strcmp() function, 104
Strnatcmp() function,
105
comparison operators,
29-30
equals operator, 29-30
WHERE clauses, 212-213
40 7842 index 3/6/01 4:22 PM Page 816