php file,
592, 612
presentation/checkout_info.php file, 612
presentation/products_list.php file, 264
presentation/store_admin.php file, 275
presentation/store_front.php file, 165
Pretty Good Privacy (PGP), 484
price field, 123
PRIMARY KEY constraint, 72??“74, 76, 119
primary keys, 72??“74
PRIOR_AUTH_CAPTURE, 643, 650
private constructor, 99
process( ) function, 406??“407
?– INDEX 700
Process( ) method, 592??“594
processing orders, 8??“9
product access, 63??“67
product attributes, 175??“188
implementing business tier, 182
implementing data tier, 176??“181
implementing presentation tier,
182??“188
overview, 175??“176
product catalog, 63??“174
business tier, 87??“101, 139??“147
activating sessions, 140??“141
connecting to MySQL, 87??“93
defining product list constants and
activating session, 140??“141
GetCategoriesInDepartment,
141??“142
GetCategoryDetails, 142
GetDepartmentDetails, 141
GetProductDetails, 147
GetProductLocations, 147
GetProductsInCategory, 144??“145
GetProductsOnCatalog, 146??“147
GetProductsOnDepartment,
145??“146
HowManyPages, 142??“144
writing code for, 93??“101
data storage, 70??“80, 113??“126
data tables, 71??“78
database diagrams, 125??“126
department tables, 78??“80
populating data tables, 121??“123
relating products to categories, 123??“125
relational databases, 114??“120
data tier, 81??“86
MySQL stored procedures, 84??“86
SQL, 81??“84
link factories, 112
overview, 63, 113
presentation tier, 101??“110, 148??“174
department/category details, 148??“154
front page contents, 165??“168
lists of categories, 154??“157
product details, 168??“174
product lists, 157??“165
Smarty plug-ins, 102??“110
product access, 63??“67
querying data, 126??“130
displaying products page by page, 129??“130
joining data tables, 127??“129
retrieving short descriptions, 126??“127
stored procedures, 131??“139
catalog_count_products_in_category,
133??“134
catalog_count_products_on_catalog, 137
catalog_count_products_on_department,
135??“136
catalog_get_categories_list, 133
catalog_get_category_details, 133
catalog_get_department_details,
132??“133
catalog_get_product_details, 138
catalog_get_product_locations,
138??“139
catalog_get_products_in_category,
134??“135
catalog_get_products_on_catalog,
137??“138
catalog_get_products_on_department,
136??“137
product componentized template, 174
product details, displaying, 168??“174
product list constants, 140??“141
product lists, displaying, 157??“165
product recommendation system,
461??“474
dynamic recommendations, 461??“463
overview, 461
selecting recommendations from database,
464??“471
product reviews feature, 655??“663
implementing, 657??“663
overview, 655??“656
planning, 656??“657
product table, 123??“134, 227, 468
product_attribute data table, 177
product_attribute table, 179??“180
product_category table, 119??“134
product_id column, 129
product_id field, 119??“123, 366, 436
product_id value, 465
product_images folder, 342
product_list template, 243
product.
Pages:
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813