Specifications
Web issues, database security
865
messages, 643-647
selecting accounts,
637-640
script architecture, 623-629
sending mail, 649-652
forwarding messages,
651-652
new messages, 649-651
replying to messages,
651-652
solution components,
619-620
solution overview, 620-621
WBMP (Wireless Bitmap),
403
Web 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
Web browsers
authentication, 292-293
secure transactions,
329-330
Web database architecture,
180-181
Web databases
architecture, 180-181,
228-231
designing, 176-180
atomic column values,
178
keys, creating, 179
null values, avoiding,
179-180
real-world objects,
modeling, 176
redundant data,
avoiding, 176-178
table types, 180
update anomalies,
avoiding, 177-178
querying, 232
connections, setting up,
234-235
disconnecting from
databases, 238
input data, 232-233
inserting new informa-
tion into databases,
238-241
mysql_db_query()
function, 236
mysql_query() function,
235-236
retrieving results,
236-237
selecting databases,
235
selecting in MySQL, 193
tables
column types, 196-205
creating, 194-199
keywords, 196
viewing, 198-199
users, setting up, 193
viewing in MySQL,
198-199
Web development, Philip
and Alex’s Guide to Web
Publishing Web site, 806
Web forum application,
712
article list, 718-731
collapsing threads, 719,
723
displaying articles, 724
expanding threads,
719-723
individual articles,
viewing, 731-734
new articles, adding,
734-741
plus symbols, 719
treenode class, 725-731
database design, 716-718
extensions, 741
files, 715
posters, 716
solution components,
712-714
solution overview, 714-715
tree of articles, 729
tree structure, 713-714
tree_node class, 713
Web forum projects
phorum, 741
phpslash, 741
Web forums, threads, 712
Web issues, database
security, 253-254
40 7842 index 3/6/01 4:22 PM Page 865