Specifications
variable variables
863
user feedback (commer-
cial Web sites), 271
user input, screening, 336
user interface design
(commercial Web sites),
274
user personalization
bookmarks, adding, 526-
529
bookmarks, deleting, 530-
532
bookmarks, displaying,
529-530
bookmarks, recommend-
ing, 500
bookmarks, storing, 500
defined, 498
recommendations, imple-
menting, 532-536
solution components, 499-
500
system requirements, 498
usernames, 499
user privileges, database
security, 253
user table, 247-248
mysql database, 247
user view (Shopping Cart
application), 542-543
userfile field (HTML
form), 354
usernames, 499
users
administrative users
privileges, 191
setting up, 192
authentication, 304-325
access control, imple-
menting, 305-312
basic authentication.
See basic authentica-
tion
digest authentication,
313
encrypting passwords,
310-311
identifying users,
304-305
mod_auth_mysql mod-
ule, 322-324
multiple pages,
protecting, 312
storing passwords,
308-310
Web sites, 324
privileges, 188-193
global privileges, 189
GRANT command,
188-189, 192-193
principle of least
privilege, 188
REVOKE command,
192-193
types, 190-191
secure transactions,
329-330
setting up in MySQL,
187-188, 192-193
GRANT command,
188-189, 192-193
votes
casting, 421
code to cast, 420-421
results, drawing, 421
user_auth_fns.php, 502,
660
user_auth_fns.php library,
check_auth_user()
function, 630
Using mkdir() function,
361
usort() function, 80-82
utilities
myisamchk, 260
EXPLAIN statement
output, 260
PHP Web application
projects, 470
V
valid email() function,
510-511
validating user authenti-
cation input data, 510
values
array elements, 71
assigning to variables, 22
atomic column values
(databases), 178
columns, EXPLAIN
statement, 259
default, database optimiza-
tion, 262
null values, avoiding (Web
databases), 179-180
returning, 81
assignment operator, 27
returning from functions,
141-142
values (tables), 173
variable functions, 36-38
re-interpreting variables,
37
type testing functions, 36
variable status, testing, 37
variable names, code,
463-464
variable scope, 136-138
variable status, testing,
37
variable variables, 23-24
40 7842 index 3/6/01 4:22 PM Page 863