php file, 505
customers
encouraging spending, 4??“5
getting more, 3??“4
Customers class, 551
customer/shipping_region tables,
479??“480
customizing page titles, 208??“211
C:xamppapachebin folder, 630
?– INDEX 693
D
d([0-9]+) character, 197
Data Encryption Standard (DES), 484
data integrity, 72
data storage, 70??“80, 113??“126
data tables, 71??“78
autoincrement columns, 76??“77
columns and data types, 74??“76
default values, 76
indexes, 77??“78
NOT NULL columns, 76
primary keys, 72??“74
UNIQUE columns, 74
database diagrams, 125??“126
department tables, 78??“80
populating data tables, 121??“123
relating products to categories, 123??“125
relational databases, 114??“120
data tables, 70, 71??“78
columns
autoincrement, 76??“77
and data types, 74??“76
NOT NULL, 76
UNIQUE, 74
default values, 76
indexes, 77??“78
joining, 127??“129
populating, 121??“123
primary keys, 72??“74
data tier, 15, 81??“86
adding functionality to TShirtShop, 502??“504
catalog departments, 295??“296
implementing, 176??“181
implementing order-placement system,
436??“438
modifying, 547??“550, 562??“564
MySQL stored procedures, 84??“86
product details, 348??“353
SQL, 81??“84
DELETE command, 84
INSERT statement, 83
SELECT statement, 81??“82
UPDATE statement, 84
storing shopping cart information,
367??“371
updating orders administration page,
615??“616
data types, columns and, 74??“76
database diagrams, 125??“126
database functions, 26
database tier, 15
DatabaseHandler class, 87, 93??“101
databases, preparing, 60??“61
DataCash, 626??“643
exchanging XML data with, 630??“639
fulfillment, 629??“630
integrating with TShirtShop, 639??“643
live accounts, 643
overview, 624??“625
preauthentication, 627??“628
_DataFormat( ) method, 683
datetime data type, 75
$db_host variable, 89
$db_name variable, 89
$db_pass variable, 89
$db_user variable, 89
DEBUGGING constant, 59, 218
decimal data type, 75
Decrypt( ) method, 488
DecryptData( ) method, 496
default values, 76
degradable code, 409??“410
DELETE command, 81, 84
delete_dept button type, 293
DeleteDepartment return, 294
DeleteProduct method, 343
deleting products from shopping cart, 392
DELIMITER statement, 131
Department class, 152
department componentized template, 151??“153
department Smarty template, 165
department table, 71??“82, 127, 292
department tables, 78??“80
department_id column, 73
department_id data type, 74
department_id field, 121
department_id parameter, 294
department_id value, 293
department_list template, 154
department-category relation, 116
DepartmentId object, 164
DepartmentId parameter, 108, 148??“158, 270
DepartmentId query string parameter, 153,
164
?– INDEX 694
department.
Pages:
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811