Specifications

architecture
809
aliases for tables, 218-219
ALL privilege, 191
ALTER privilege, 190
ALTER TABLE statement,
223
syntaxes, 224
ALTER [COLUMN] column
{SET DEFAULT value |
DROP DEFAULT} syntax,
224
altering tables, 223-225
AMANDA (Advanced
Maryland Automated
Network Disk Archiver),
301
Amazon.com, 278
ampersand (&) reference
operator, 29
Analog Web site, 271
and operator, 31
anomalies, avoiding (Web
databases), 177-178
anonymous login (FTP),
381
ANSI Web site (SQL stan-
dard), 226
anti-aliasing text, 408
Apache
for UNIX, 798-799
for Windows, 798-799
installing, 787-789
UNIX environment,
787-789
Windows environment,
795-796
parameters, MaxClients,
235
resources, 806
running, 790, 796
as services, 797-798
from console window,
797
Windows environment,
796
Apache Software Web
site, 806
Apache Today Web site,
806
Apache Web server
basic authentication
(HTTP)
in PHP, 314-315
with .htaccess files,
316-319
htpasswd program,
318-319
mod_auth module, 316
mod_auth_mysql module,
322-324
documentation Web
sites, 324
installing, 322-323
Apache Web site, 784
Apache Week Web site,
806
applications
content management sys-
tems, files, 595-596
Shopping Cart. See
Shopping Cart applica-
tion
application architectures,
Warm Mail application
(email client), 621
application layer proto-
cols, 333
application projects
content, 471
separating from logic,
472
development environment,
469
documentation, 470
logic, 471
separating from
content, 472
optimizations, 472-473
Zend Optimizer, 473
planning, 461-462
prototypes, 471
rewriting code, 462-463
software engineering, 460
testing code, 474-475
version control, 467-468
writing maintainable code,
463
coding standards,
463-467
directory structures,
467
functions, 467
applications
Bob’s Auto Parts applica-
tion, 11-13
Book-O-Rama application,
173
Database Search page,
229
designing, 176-180
schema, 184, 194
Web database architec-
ture, 180-181
content management
systems
files, 596-598
PHPBookmark, 498-500
files, 501-502
Smart Form Mail, 94-96
Smart Form Mail applica-
tion, regular expressions,
113-114
Warm Mail. See Warm
Mail application
Web forum application.
See Web forum applica-
tion
architecture
script, 663-672
footers, 663
headers, 663
40 7842 index 3/6/01 4:22 PM Page 809