Specifications
column types (tables)
815
script to make HTTPS
connections, 388
script to verify URL and
email address, 376
scripts
list of extensions and
functions in PHP, 452
PHP script to call GPG
and send encrypted
email, 343
resetting variables from
the php.ini file, 453
sessions
ending, 437
starting and registering
variables, 435
variables, accessing
and deregistering, 436
Shopping Cart application
admin.php script, 577
book_sc database,
creating, 546
calculate_items()
function, 564
calculate_price()
function, 564
checkout.php script,
567
db_result_to_array()
function, 552
display_book_form()
function, 581
display_cart() function,
561
display_categories()
function, 553
get_categories()
function, 552
get_category_name()
function, 554
index.php script, 551
insert_book.php script,
579
insert_order() function,
570
process.php script, 573
purchase.php script,
568
show_book.php script,
555
show_cart.php script,
559
show_cat.php script,
553
SQL to create tables for
Book-O-Rama applica-
tion, 195
Warm Mail application
database, creating, 622
delete_account() func-
tion, 636
delete_message() func-
tion, 648
display_account_setup(
) function, 633
display_list() function,
640
get_accounts() func-
tion, 634
index script, 623
number_of_accounts()
function, 637
open_mailbox() func-
tion, 642
retrieve_message()
function, 645
send_message()
function, 650
store_account_
settings() function,
635
Web forum application
add_quoting() function,
737
article view, 721
discussion database,
717
display_tree() function,
724
expand_all() function,
723
get_post() function, 733
get_post_title()
function, 736
individual articles,
displaying, 732
new articles, adding,
735
posts, adding to data-
base, 738
store_new_post()
function, 739
treenode class, 725
code modules (Shopping
Cart application), 543
collapsing threads (Web
forum application), 719,
723
colors
buttons, 414
text, colors and fonts,
411
RGB (red, green, and
blue), 406
column types (tables),
196-205
date and time types, 203
TIMESTAMP display
types, 203
numeric types, 201-202
floating point data
types, 201-202
integral data types, 201
string types, 204-205
ENUM type, 205
regular string data
types, 204
SET type, 205
TEXT types, 205
40 7842 index 3/6/01 4:22 PM Page 815