Specifications
databases
820
privilege system, 246-247
columns_priv table,
249-250
db table, 248-249
grant table, 250-251
host table, 248-249
privileges, updating,
251
tables_priv table,
249-250
user table, 247-248
queries
EXPLAIN statement,
257-260
indexes, 261
records
deleting, 225
updating, 223
relational databases. See
relational databases
relationships, 175
many-to-many relation-
ships, 175
one-to-many relation-
ships, 175
one-to-one relation-
ships, 175
rows, returning, 222-223
schemas, 175
security, 251
operating system, 252
passwords, 252-253
user privileges, 253
Web issues, 253-254
selecting in MySQL,
193-194
setting up, 660-663
Shopping Cart application,
547-548
SQL (Structured Query
Language), 208
subscribers, 657
tables, 173
altering, 223-225
Cartesian product, 215
column types, 196-205
columns, 173
creating in MySQL,
194-199
dropping, 226
equi-joins, 215
joins, 214
keywords, 196
left joins, 217-218
rows, 173
types, 180, 262-263
values, 173
viewing, 198-199
viewing in MySQL,
198-199
vote
code to update,
422-423
results, code to
retrieve, 422-423
Warm Mail application
(email client), 622-623
Web databases
architecture, 180-181
designing, 176-180
Web databases. See Web
databases
Web forum application,
716-718
data_valid_fns.php, 501,
660
date and time
converting between PHP
and MySQL formats,
396-398
in MySQL
DATE_FORMAT()
function, 396-397
MySQL Web site, 400
UNIX_TIMESTAMP
function, 397-398
in PHP, 392-396
calendar functions, 399
checkdate() function,
396
date calculations,
398-399
date() function,
392-395
floor() function, 399
getdate() function, 395
mktime() function,
394-395, 398
PHP Web site, 400
date and time column
types, 203
TIMESTAMP display
types, 203
date and time data types,
203
date() function, 17-18,
363, 392-395
format codes, 392-394
UNIX time stamps,
394-395
DATE_FORMAT() function,
396-397
db fns.php, 597, 605
db table, 247-249
mysql database, 248-249
db_connect() function,
513
db_fns.php, 502, 660
db_result_to_array() func-
tion, 552
DDoS (Distributed Denial
of Service), 287
debugging, remote, 494
debugging variables,
486-489
declaring functions,
132-133
decoct() function, 363
40 7842 index 3/6/01 4:22 PM Page 820