COUNTrewritecond

$metacharacter,197$$delimiter,131–133$1variable,198$2variable,198$3variable,198&(ampersand),643&$rHowManyPagesparameter,144*(asterisk),82*metacharacter,196[]metacharacter,197|(pipe)character,643+metacharacter,196(questionmark)metacharacter,196301redirects,203–2083DES(TripleDES),484404statuscodes,213–220500statuscodes,213–220AA()function,91,403abortproperty,405ACCEPTEDstring,628accepted_wordsarray,237actionObjectattribute,424AddCCDetailslink,502AddtoCartfeature,415–426add_deptbuttontype,293ADD_PRODUCTconstant,392add_product_if_availableprocedure,18add_to_cartelement,423AddDepartmentreturn,294added_onfield,367AddProduct()method,372addProductToCart()function,415admin_attribute_valuescomponentizedtemplate,321admin_attribute_values.
phpfile,321admin_attribute_values.
tplfile,321admin_attributescomponentizedtemplate,321admin_attributes.
phpfile,321admin_attributes.
tplfile,321admin_categoriesSmartycomponentizedtemplate,304admin_departmentscomponentizedtem-plate,287–293admin_departmentsSmartytemplate,269admin_departments.
tpltemplate,292admin_logintemplate,285admin_menutemplate,321admin_menu.
tplpage,445admin_order_detailscomponentizedtem-plate,454,617admin_order_detailstemplate,443,554admin_order_details.
phpfile,460admin_order_details.
tplfile,460admin_orderscomponentizedtemplate,447admin_orderstemplate,443,553admin_orders.
tplpresentationtiertemplate,551admin_orders.
tpltemplatefile,454ADMIN_PASSWORDobject,286admin_product_detailstemplate,328admin_product_details.
tpltemplate,341admin_productstemplate,328admin_products.
phpfile,328admin_products.
tplfile,328ADMIN_USERNAMEobject,286AdminDepartmentsclass,293AdminDepartmentspresentationobject,293administeringcustomerorders,443–460,547–560displayingorderdetails,454–460displayingpendingorders,447–454modifyingbusinesstier,551–552modifyingdatatier,547–550modifyingpresentationtier,553–560overview,547shoppingcart,392–398buildingpage,393–398deletingproducts,392Index689administrators,authenticating,276–286AdminLoginpresentationobject,286AdminOrderDetailsclass,460,623admin.
phppage,270,443–447AdminProductDetailsclass,341AES(AdvancedEncryptionStandard),484AJAX,399–430overview,399quickstart,400–413DOM,401JavaScript,400–401whensuitable,412–413writingdegradablecode,409–410XMLHttpRequestobject,402–409shoppingcart,413–430enhancing,426–430enhancingAddtoCartfeature,415–426AjaxRequestparameter,424alert()function,423aliases,34–38,129$allWordsparameter,236all-wordssearches,222,231–232ALTERPROCEDUREcommand,85ALTERTABLEcommand,120Amazonclass,688AmazonWebServices(AWS),665–688accessing,667–677creatingaccounts,668obtainingassociateIDs,669–670overview,667–668usingREST,670–675usingSOAP,676–677defined,665–667integratingwithTShirtShop,678–688businesstier,679–684presentationtier,684–688overview,665AMAZON_METHODconstant,682$amazon_xmlvariable,683Amazon.
comstandarditemnumber(ASIN),671AmazonProductsListclass,688ampersands(&),643AND/ORlogic,231any-wordssearches,222,228–230ApacheFriends,274API(applicationprogramminginterface),88,401,496,623Applicationclass,48applicationprogramminginterface(API),88,401,496,623ASIN(Amazon.
comstandarditemnumber),671AssignAttributeValueToProductmethod,343AssignProductToCategorymethod,343associateIDs,Amazon.
comwebservices,669–670associatetable,118asterisk(*),82asymmetricencryption,483attributedatatable,176attributetable,178–179attribute_valuedatatable,176attribute_valuetable,178–179attributesfield,367auditdatabasetable,571auditentry,594AUTH_CAPTUREtype,643auth_codefield,544AUTH_ONLYtransaction,650AUTH_ONLYtype,643$auth_only_responsearray,650authenticatingadministrators,276–286authenticationmechanism,276authorization,625authorizationmechanism,276Authorize.
net,643–653integratingwithTShirtShop,651–653overview,624–625AuthorizeNetRequestclass,648AUTO_INCREMENTcolumn,437AUTO_INCREMENTcolumns,367AUTO_INCREMENToption,83autoincrementcolumns,76–77AWS.
SeeAmazonWebServicesAWSECommerceServiceobject,676BB()function,91,403BACKSLASHmetacharacter,197element,401Build()method,112businessfolder,505,594,596–599businessparameter,253INDEX690businesstier,15,87–101,139–147activatingsessions,140–141addingfunctionalitytoTShirtShop,505–509Amazon.
comwebservices,679–684catalogdepartments,293–295catalogsearches,234–238connectingtoMySQL,87–93issuingcommandsusingconnection,92–93openingandclosingconnections,87–88usingPHPPDOfordatabaseoperations,88–92definingproductlistconstants,140–141encryptionfunctionalityin,483–489GetCategoriesInDepartment,141–142GetCategoryDetails,142GetDepartmentDetails,141GetProductDetails,147GetProductLocations,147GetProductsInCategory,144–145GetProductsOnCatalog,146–147GetProductsOnDepartment,145–146hashingfunctionalityin,480–483HowManyPages,142–144implementing,182implementingorder-placementsystem,438–439modifying,551–552fortaxandshippingcharges,565productdetails,343–348storingshoppingcartinformation,372–378updatingordersadministrationpage,616writingcodefor,93–101businesstierlevel,pagingat,130business/catalog.
phpfile,141business/customer.
phpfile,505business/orders.
phpfile,616buy_nowfield,367CC()function,91,403Crewriteruleoption,198callstack,91Cancelbutton,269CardNotPresent(CNP)transactions,625CardNumberXmember,499cart_detailscomponentizedtemplate,432,478cart_detailstemplatefile,439cart_details.
phppresentationobjectfile,385cart_details.
tpltemplate,385cart_idfield,366–378cart_summarycomponentizedtemplate,381cart_summary.
tpltemplate,425CartActionparameter,379–381$cartProductsTypeparameter,378cart-summaryelement,426cart-summaryelement,426cascadingstylesheets(CSS),51,400catalogadministration,267–360categories,297–304departments,286–296businesstier,293–295datatier,295–296presentationtier,287–293in-storeadministrationlinks,353–360overview,267–268,305previewingpage,268–271products,321–328attributes,306–321details,328–353settinguppage,271–286authenticatingadministrators,276–286configuringTShirtShopforSSL,274–275enforcingSSLconnections,275–276obtainingSSLcertificate,275secureconnections,272–274Catalogclass,87,93,139–141,182,211,343,471catalogpagination,updating,211–214catalogsearches,221–248businesstier,234–238implementing,224–234MySQLFULLTEXTindexes,226–234WHEREclauseandLIKEoperator,225overview,221presentationtier,238–248displayingsearchresults,243–248search_boxcomponentizedtemplate,239–243selectingmethod,221–224INDEX691catalog_count_products_in_categorydata-basestoredprocedure,145catalog_count_products_in_categorystoredprocedure,133–134catalog_count_products_on_catalogstoredprocedure,137catalog_count_products_on_departmentstoredprocedure,135–136catalog_count_search_resultstoredprocedure,234catalog_create_product_reviewstoredprocedure,657catalog_delete_productfunction,392catalog_get_categories_liststoredprocedure,133catalog_get_category_detailsstoredprocedure,133catalog_get_department_detailsstoredprocedure,132–133,141catalog_get_departments_liststoredprocedure,85catalog_get_product_attributesprocedure,181–186catalog_get_product_attributesstoredprocedure,176,178–180catalog_get_product_detailsstoredprocedure,138catalog_get_product_locationsstoredprocedure,138–139catalog_get_product_reviewsstoredprocedure,657catalog_get_products_in_categorystoredprocedure,134–135catalog_get_products_on_catalogstoredprocedure,137–138catalog_get_products_on_departmentstoredprocedure,136–137catalog_get_recommendationsstoredprocedure,469catalog_searchstoredprocedure,234Catalog::GetProductAttributes()method,186catchblock,90,404catchkeyword,90categories,64–67,121–123catalogadministration,297–304displayingdetails,148–154displayinglistsof,154–157relatingproductsto,123–125categories_listcomponentizedtemplate,157categories_listtemplate,154CategoriesListclass,157categorytable,127category_idfield,119–121CategoryIdobject,164CategoryIdparameter,158CategoryIdquerystringparameter,153,164CHECKconstraints,120checkoutfunctionality,252–265checkoutpages,530–539,612–615checkout_infocomponentizedtemplate,531checkout_info.
phpfile,612CheckoutInfoclass,538CheckRequest()method,208CleanUrlText()method,203clickevent,410,430client-serverarchitecture,20CNP(CardNotPresent)transactions,625COALESCEconditionalexpression,370codeeditors,30codingstandards,27–28Colorattribute,306columnsautoincrement,76–77datatypesand,74–76NOTNULL,76UNIQUE,74configfile,280config_loadfile="site.
conf"directory,51config.
phpfile,58,280configsfolder,40connectingtoMySQL,87–93issuingcommandsusingconnection,92–93opening/closingconnections,87–88PHPPDO,88–92constraint,72__construct()function,50,56,286__constructor()method,540contentscell,43ContinueShoppinglink,66controlpanel,64,268COUNTclause,467CREATEPROCEDUREcommand,133CreateAudit()method,592created_onfield,435,468CreateOrdermethod,438,442CreateOrder()method,565INDEX692CreateSubpageQuery()method,145CreateXml()method,497createXmlHttpRequestObject()function,403,415createXmlHttpRequestObjectobject,405creditcardtransactionsauthorization,571,643–653DataCash,626–643exchangingXMLdatawith,630–639fulfillmentrequests,629fulfillmentresponses,629–630integratingwithTShirtShop,639–643liveaccounts,643preauthenticationrequests,627–628preauthenticationresponses,628gatewayorganizations,624–625overview,623principlesof,625–626storinginformationusingSecureCardclass,490–500crossjoin,179CROSSJOINsyntax,180Cross-Selling,462CSS(cascadingstylesheets),51,400CURLOPT_RETURNTRANSFERparameter,637customeraccounts,477–541addingcustomerordersto,544–547addingfunctionalitytoTShirtShop,500–529businesstier,505–509datatier,502–504overview,500–502presentationtier,509–529checkoutpages,530–539overview,477securityclasses,480–500encryptionfunctionalityinbusinesstier,483–489hashingfunctionalityinbusinesstier,480–483overview,480storingcreditcardinformationusingSecureCardclass,490–500SSLconnections,540–541storing,478–480customer/shipping_regiontables,479–480overview,478TShirtShop,478–479Customerclass,505customernotification,571customerorders,431–460,543–568addingtocustomeraccounts,544–547administering,547–560modifyingbusinesstier,551–552modifyingdatatier,547–550modifyingpresentationtier,553–560overview,547administeringorders,443–460displayingorderdetails,454–460displayingpendingorders,447–454implementingorder-placementsystem,432–443businesstier,438–439datatier,436–438presentationtier,439–442storingorderdetails,433–436overview,431,543processing,8–9reducingcostsoffulfilling,5taxandshippingcharges,560–568implementing,561–568issueswith,560–561overview,560customertable,478customer_addresscomponentizedtemplate,479,510customer_credit_cardcomponentizedtemplate,479,510customer_detailscomponentizedtemplate,479,509customer_emailfield,544customer_idfield,544customer_loggedcomponentizedtemplate,509customer_logincomponentizedtemplate,479,509customer_namefield,544customer.
phpfile,505customersencouragingspending,4–5gettingmore,3–4Customersclass,551customer/shipping_regiontables,479–480customizingpagetitles,208–211C:xamppapachebinfolder,630INDEX693Dd([0-9]+)character,197DataEncryptionStandard(DES),484dataintegrity,72datastorage,70–80,113–126datatables,71–78autoincrementcolumns,76–77columnsanddatatypes,74–76defaultvalues,76indexes,77–78NOTNULLcolumns,76primarykeys,72–74UNIQUEcolumns,74databasediagrams,125–126departmenttables,78–80populatingdatatables,121–123relatingproductstocategories,123–125relationaldatabases,114–120datatables,70,71–78columnsautoincrement,76–77anddatatypes,74–76NOTNULL,76UNIQUE,74defaultvalues,76indexes,77–78joining,127–129populating,121–123primarykeys,72–74datatier,15,81–86addingfunctionalitytoTShirtShop,502–504catalogdepartments,295–296implementing,176–181implementingorder-placementsystem,436–438modifying,547–550,562–564MySQLstoredprocedures,84–86productdetails,348–353SQL,81–84DELETEcommand,84INSERTstatement,83SELECTstatement,81–82UPDATEstatement,84storingshoppingcartinformation,367–371updatingordersadministrationpage,615–616datatypes,columnsand,74–76databasediagrams,125–126databasefunctions,26databasetier,15DatabaseHandlerclass,87,93–101databases,preparing,60–61DataCash,626–643exchangingXMLdatawith,630–639fulfillment,629–630integratingwithTShirtShop,639–643liveaccounts,643overview,624–625preauthentication,627–628_DataFormat()method,683datetimedatatype,75$db_hostvariable,89$db_namevariable,89$db_passvariable,89$db_uservariable,89DEBUGGINGconstant,59,218decimaldatatype,75Decrypt()method,488DecryptData()method,496defaultvalues,76degradablecode,409–410DELETEcommand,81,84delete_deptbuttontype,293DeleteDepartmentreturn,294DeleteProductmethod,343deletingproductsfromshoppingcart,392DELIMITERstatement,131Departmentclass,152departmentcomponentizedtemplate,151–153departmentSmartytemplate,165departmenttable,71–82,127,292departmenttables,78–80department_idcolumn,73department_iddatatype,74department_idfield,121department_idparameter,294department_idvalue,293department_listtemplate,154department-categoryrelation,116DepartmentIdobject,164DepartmentIdparameter,108,148–158,270DepartmentIdquerystringparameter,153,164INDEX694department.
phpobject,152departments,64–67catalogadministration,286–296businesstier,293–295datatier,295–296presentationtier,287–293displayingdetails,148–154departments_listcomponentizedtemplate,103,684departments_listfile,102departments_listSmartytemplate,107–110departments_list.
tplfile,102–112department.
tplfile,151department.
tpltemplatefile,152,168DES(DataEncryptionStandard),484DESCoption,229descriptionfield,121–123designingforgrowth,14–20long-termrequirements,14–15three-tierarchitecture,15–20shoppingcart,364–366DigitalSignatureAlgorithm(DSA),484discounted_pricefield,123displayfield,124displayingdepartment/categorydetails,148–154frontpagecontents,165–168listsofcategories,154–157orderdetails,454–460pendingorders,447–454productdetails,168–174productlists,157–165productspagebypage,129–130searchresults,243–248shoppingcartdetails,385–392shoppingcartsummary,381–385DISTINCTclause,136element,401documentobject,401DocumentObjectModel(DOM),400,401,496document.
getElementById()method,401document.
write()method,401DOM(DocumentObjectModel),400,401,496DOMDocument,630DOMDocumentclass,496downloadingcode,61DROPPROCEDUREcommand,85DSA(DigitalSignatureAlgorithm),484dynamicproductrecommendations,461–463dynamicURL,191EErewriteruleoption,198E_NOTICEtype,59E_USER_NOTICEmessage,100E_USER_NOTICEtype,59E_WARNINGconstant,59E_WARNINGerrormessagetype,52e-commercesites,3–11designphases,7–9addingfeatures,8–9creatingshoppingcart,8gettingsiteup,7–8processingorders,8–9overview,3pre-designanalysis,5–6reasonstogoonline,3–5encouragingspending,4–5gettingmorecustomers,3–4reducingcostoffulfillingorders,5risks/threats,6–7TShirtShop,10–11EditAttributeValueslink,306EditDepartmentDetailsbutton,353EditProductDetailsbutton,353edit_catbuttontype,293edit_deptbuttontype,293Emacs,30encouragingspending,4–5Encrypt()method,488EncryptData()method,496EncryptedDataclass,498encryptionfunctionality,inbusinesstier,483–489enctype="multipart/form-data"attribute,341enforcingSSLconnections,275–276errorhandling/reporting,52–60error_log()function,58ErrorHandlerclass,52INDEX695ErrorHandler::GetBacktrace()method,58ErrorHandler::Handler()function,52–60ErrorHandler::SetHandler()method,58Exact-matchsearch,222Exceptionclass,91exceptions,90,403EXECUTEcommand,135Execute()method,93executeCartAction()function,430explode()PHPfunction,650ExtractXml()method,497FFrewriteruleoption,198features,adding,8–9file_get_contents()function,673,683filenameparameter,102$_FILESsuperglobalvariable,342$_FILES['ImageUpload']['error']variable,342$_FILES['ImageUpload']['name']variable,342first_page_contentscomponentizedtemplate,165,168first_page_contents.
tpltemplatefile,168flexiblearchitecture,14foreignkey,119FOREIGNKEYconstraint,119foreignkeys,119–120frontpagecontents,displaying,165–168frontpages,43–52FT_MIN_WORD_LENconstant,236ft_min_word_lenservervariable,230FULFILLEDOKstring,629fulfillment,creditcard,629–630FULLTEXTindexes,226–234all-wordssearches,231–232any-wordssearches,228–230creatingdatastructuresthatenablesearching,227–228writingstoredprocedures,232–234GGrewriteruleoption,198Garrett,JesseJames,400gatewayorganizations,624–625Authorize.
net,643–653integratingwithTShirtShop,651–653overview,624–625DataCash,626–643exchangingXMLdatawith,630–639fulfillmentrequests,629fulfillmentresponses,629–630goinglive,643integratingwithTShirtShop,639–643overview,624–625preauthenticationrequests,627–628preauthenticationresponses,628__get()function,498GETrequest,406,665,683GET_CART_PRODUCTSconstant,378GET_CART_SAVED_PRODUCTSconstant,378GetAll()method,93–99getAllResponseHeaders()method,405GetAttributesNotAssignedToProductmethod,343GetAuditTrail()method,616GetBacktrace()method,58GetCartId()method,372–377GetCartProducts()method,372–378GetCategories()method,93,343GetCategoriesForProductmethod,343GetCategoriesInDepartmentmethod,141–142GetCategoryDetails()method,142,153GetCategoryName()method,211_GetCurrentPipelineSection()method,592_GetDataWithRest()method,682_GetDataWithSoap()method,682GetDepartmentDetails()method,141,153GetDepartmentName()method,211GetDepartments()method,87,93,100GetEncryptedData()method,498GetMailBody()method,595,600,602GetOne()method,93GetProductDetailsmethod,147GetProductInfomethod,343GetProductLocationsmethod,147GetProductName()method,211GetProducts()method,682,688GetProductsInCategory()method,144–145,164GetProductsOnCatalogmethod,146–147GetProductsOnDepartment()method,145–146,164GetRecommendationsmethod,471INDEX696GetRequest()method,637GetResponse()method,637,648getResponseHeader("headerLabel")method,405GetRow()method,93,99GetTotalAmount()method,372GROUPBYclause,77growth,designingfor,14–20long-termrequirements,14–15three-tierarchitecture,15–20HhandleAddProductToCart()function,415handleError()function,415,423,425handleExecuteCartAction()function,430Handler()function,52handleRequestStateChange()function,407Hash()method,482hashingfunctionality,inbusinesstier,480–483HEAP,120how_many_pagesvariable,144HowManyPages()method,141,142–144,145.
htaccessfile,195,220.
htaccessrules,199,248HTML(HypertextMarkupLanguage),17HTTPauthentication,276HTTP_SERVER_PORTconstant,112httpd.
confApacheconfigurationfile,195httpd.
conffile,195HTTPS(HypertextTransportProtocol,Secure)protocol,272HypertextMarkupLanguage(HTML),17HypertextPreprocessor(PHP)code,7HypertextTransportProtocol,Secure(HTTPS)protocol,272IIDE(integrateddevelopmentenvironment),30idx_ft_product_name_descriptionindex,229ifconditionalstatement,188ignored_wordsarray,237imagefield,123image_2field,124implementsoperator,592inAttributesparameter,369inCartIdparameter,369inCategoryIDparameter,134include/config.
phpfile,99,140,142,275,540,643,674,682–688inDepartmentIdinputparameter,133inDepartmentIdparameter,133indexes,77–78index.
htmlfile,190index.
phpfile,140,154,190,381index.
phppage,271index.
phpscript,424init()method,109,153,168,341,460,538,621,688initializationvector(IV),484InnoDB,120inProductIdparameter,369inProductsPerPageparameter,134input-outputparameter,133INSERTINTOcommand,179INSERTstatement,81,83,437inShortProductDescriptionLengthparameter,134installingSmarty,38–40XAMPP,30–34inStartItemparameter,134in-storeadministrationlinks,353–360intdatatype,75integerrecord,76integrateddevelopmentenvironment(IDE),30interactivestate,408Internetpaymentserviceproviders,250–251IP(InternetProtocol),625IPipelineSectionclass,572IPipelineSectioninterface,592,594IS_WARNING_FATALconstant,59item_idfield,366,436ItemLookupoperation,673ItemSearch,676,677,684ItemSearchRequestobject,676IV(initializationvector),484JJavaScript,400–401JavaScriptObjectModel(JSON),400JOINclause,128joiningdatatables,127–129INDEX697JSON(JavaScriptObjectModel),400junctiontable,118Kkeyword-richURLsgenerating,199–203supporting,191–195LLrewriteruleoption,198[L]flag,199LAST_INSERT_ID()function,83,437LEFT(str,len)function,126libsfolder,39LIKEoperator,225,226LIMITclause,135LIMITkeyword,130,467Linkclass,165,168,199,321linkfactories,112Link::Build()method,165linkingtable,118Link::ToCategory()method,157Link::ToProduct()method,165Link::ToSearchResults()method,242Linux,preparingaliaseson,37–38LiveHTTPHeadersplug-in,264load_presentation_objectSmartyplug-infunction,152–153LoadEncryptedDataAndDecrypt()function,495LoadPlainDataAndEncrypt()function,495MMailAdmin()method,592MakeXmlFulfill()method,637MakeXmlPre()method,636–637many-to-manyrelationships,116,117–119,125MATCHrule,229$_mCartIdmember,376$mCategoriesparameter,157$_mCategoryIdmember,164$_mCategoryIdprivatemember,153$mContentsCellfield,152–165$mContinueNowfield,592mcryptfunctions,484mcryptlibrary,484mcrypt_decrypt()function,489mcrypt_encrypt()function,487–488MCRYPT_MODE_CBCmethod,489MD5()encryptionfunction,483md5()method,377$_mDepartmentIdmember,164$_mDepartmentIdprivatemember,153$mDescriptionpublicmember,153$mEditEnabledclassmember,460$_mEncryptedDatamember,498MerchantServiceslink,251metacharacter,196metacharacter,196()metacharacter,197middletier,15$_mIsDecryptedflag,499$_mIsEncryptedflag,498m,nmetacharacter,196$mNamepublicmember,153mod_rewritemodule,195–199$mOrderInfoarray,592MOVE_PRODUCT_TO_CARTconstant,392move_uploaded_file()PHPfunction,342MoveProductToCart()method,372MoveProductToCategorymethod,343$mProcessButtonTextmember,623$mSelectedCategoryparameter,157$mSelectedDepartmentparameter,157$_msHexaIvvariable,488$_msSecretKeyvariable,488MyISAM,120,227MySQL,23–26connectingto,87–93issuingcommandsusingconnection,92–93opening/closingconnections,87–88PHPPDO,88–92datatables,80FULLTEXTindexes,226–234all-wordssearches,231–232any-wordssearches,228–230creatingdatastructuresthatenablesearching,227–228writingstoredprocedures,232–234PDOs,23–26SQLqueries,23storedprocedures,84–86tabletypes,120three-tierarchitecture,26INDEX698NNrewriteruleoption,198namecolumn,72namefield,121,123namingstandards,27–28NCrewriteruleoption,198NOTNULLcolumns,76NSrewriteruleoption,198n-tierarchitecture,19NULLIFconditionalexpression,370Oobjvariable,109$obj-&closeang,293objectdetection,404object-orientedprogramming(OOP),90,403on_catalogfield,165onclickattribute,424one-to-manyrelationships,116–117onreadystatechangemethod,405onsubmitattribute,424OOP(object-orientedprogramming),90,403open()method,406/opt/lampp/etcfolder,487,630ORDERBYclause,77,82,229,467ORDERkeyword,434orderpipelinefunctionality,569–624defined,570designing,571–592implementingsections,593–602PsCheckFundsclass,596PsCheckStockclass,596–598PsFinalNotificationclass,601–602PsInitialNotificationclass,594–595PsShipGoodsclass,599–600PsShipOkclass,600–601PsStockOkclass,598PsTakePaymentclass,598–599layinggroundworkfor,592overview,569–570,593testingpipeline,603–612updatingcheckoutpage,612–615updatingordersadministrationpage,615–623businesstier,616datatier,615–616presentationtier,617–623updatingordersprocessingcode,592order_detailtable,434–464,562order_idfield,435OrderIdparameter,460order-order_detailtable,116OrderProcessorclass,572,592–593OrderProcessor::Process()method,612OrderProcessor::SetOrderAuthCodeAndReference()method,639,651OrderProcess::Process()method,615orders.
Seecustomerordersordersadministrationpageupdating,615–623businesstier,616datatier,615–616presentationtier,617–623Ordersclass,453,551,616orders_create_auditdatabase,592orders_get_audit_trailstoredprocedure,616orders_update_orderprocedure,615orders_update_statusstoredprocedure,592Orders::CreateAudit()method,592Orders::GetOrderDetails()method,460Orders::GetOrderInfo()method,460outputparameter,133Ppparameter,181Prewriteruleoption,198pack()function,489Pageobject,164Pageparameter,165pagetitles,customizing,208–211$pageNoparameter,236PASSWORD()encryptionfunction,483password_hasher.
phpfile,480PasswordHasherclass,481,482payment,571PayPal,249–266checkoutfunctionality,252–265costof,8Internetpaymentserviceproviders,250–251overview,251–252shoppingcart,252–265SingleItemPurchasesfeature,266PayPalDeveloperNetwork,The,251PayPalSingleItemPurchases,266INDEX699PayPalWebsitePaymentsStandard,7PayPalDev,251PDOobject,89PDO::prepare()method,92PDOs(PHPDataObjects),23–26,88–92PDOStatement::execute()method,92PDOStatement::fetch()method,92PDOStatement::fetchAll()method,92$persistentvariable,89PGP(PrettyGoodPrivacy),484PHPDataObjects(PDOs),23–26,88–92PHPDesigner2006,30PHPerrors,90.
phpfiles,22,40PHP:HypertextPreprocessor(PHP),20–21php_soap.
dllreference,676phpEclipse,30php.
inifile,487,630phpMyAdmin,181,615pipe(|)character,643pipelinesystems,569–624defined,570designing,571–592implementingsections,593–602PsCheckFundsclass,596PsCheckStockclass,596–598PsFinalNotificationclass,601–602PsInitialNotificationclass,594–595PsShipGoodsclass,599–600PsShipOkclass,600–601PsStockOkclass,598PsTakePaymentclass,598–599layinggroundworkfor,592overview,569–570,593testingpipeline,603–612updatingcheckoutpage,612–615updatingordersadministrationpage,615–623businesstier,616datatier,615–616presentationtier,617–623updatingordersprocessingcode,592PlaceOrderbutton,266,431platforms,35populatingdatatables,121–123POSTmethod,637postAddProductToCartProcess()function,415postalt-shirtkeywords,673,678postal+t-shirtkeywords,677postExecuteCartActionProcess()function,430PostgreSQL-specificfunctions,25preauthentication,creditcard,627–628pre-designanalysis,5–6PREPAREcommand,135preparedstatements,92,135Presentationobject,102presentationtier,15,101–110,148–174addingfunctionalitytoTShirtShop,509–529Amazon.
comwebservices,684–688catalogdepartments,287–293catalogsearches,238–248displayingsearchresults,243–248search_boxcomponentizedtemplate,239–243department/categorydetails,148–154frontpagecontents,165–168implementing,182–188implementingorder-placementsystem,439–442listsofcategories,154–157modifying,553–568productdetails,168–174,330–342productlists,157–165Smartyplug-ins,102–110storingshoppingcartinformation,378–392displayingcartdetails,385–392displayingcartsummary,381–385updatingAddtoCartbutton,379–381updatingordersadministrationpage,617–623presentation/admin_order_details.
phpfile,592,612presentation/checkout_info.
phpfile,612presentation/products_list.
phpfile,264presentation/store_admin.
phpfile,275presentation/store_front.
phpfile,165PrettyGoodPrivacy(PGP),484pricefield,123PRIMARYKEYconstraint,72–74,76,119primarykeys,72–74PRIOR_AUTH_CAPTURE,643,650privateconstructor,99process()function,406–407INDEX700Process()method,592–594processingorders,8–9productaccess,63–67productattributes,175–188implementingbusinesstier,182implementingdatatier,176–181implementingpresentationtier,182–188overview,175–176productcatalog,63–174businesstier,87–101,139–147activatingsessions,140–141connectingtoMySQL,87–93definingproductlistconstantsandactivatingsession,140–141GetCategoriesInDepartment,141–142GetCategoryDetails,142GetDepartmentDetails,141GetProductDetails,147GetProductLocations,147GetProductsInCategory,144–145GetProductsOnCatalog,146–147GetProductsOnDepartment,145–146HowManyPages,142–144writingcodefor,93–101datastorage,70–80,113–126datatables,71–78databasediagrams,125–126departmenttables,78–80populatingdatatables,121–123relatingproductstocategories,123–125relationaldatabases,114–120datatier,81–86MySQLstoredprocedures,84–86SQL,81–84linkfactories,112overview,63,113presentationtier,101–110,148–174department/categorydetails,148–154frontpagecontents,165–168listsofcategories,154–157productdetails,168–174productlists,157–165Smartyplug-ins,102–110productaccess,63–67queryingdata,126–130displayingproductspagebypage,129–130joiningdatatables,127–129retrievingshortdescriptions,126–127storedprocedures,131–139catalog_count_products_in_category,133–134catalog_count_products_on_catalog,137catalog_count_products_on_department,135–136catalog_get_categories_list,133catalog_get_category_details,133catalog_get_department_details,132–133catalog_get_product_details,138catalog_get_product_locations,138–139catalog_get_products_in_category,134–135catalog_get_products_on_catalog,137–138catalog_get_products_on_department,136–137productcomponentizedtemplate,174productdetails,displaying,168–174productlistconstants,140–141productlists,displaying,157–165productrecommendationsystem,461–474dynamicrecommendations,461–463overview,461selectingrecommendationsfromdatabase,464–471productreviewsfeature,655–663implementing,657–663overview,655–656planning,656–657producttable,123–134,227,468product_attributedatatable,177product_attributetable,179–180product_categorytable,119–134product_idcolumn,129product_idfield,119–123,366,436product_idvalue,465product_imagesfolder,342product_listtemplate,243product.
phpfile,264INDEX701products,5,321–328attributes,306–321deletingfromshoppingcart,392details,328–353businesstier,343–348datatier,348–353presentationtier,330–342displayingpagebypage,129–130relatingtocategories,123–125productsarray,237products_listcomponentizedtemplate,157,163–165,223products_listSmartycomponentizedtemplate,168products_list.
phpfile,164products_list.
tpltemplate,186–188,379,415PRODUCTS_PER_PAGEconstant,140–142,164ProductsListclass,168product.
tpltemplate,188,264,415projectdevelopment,13–28codingstandards,27–28designingforgrowth,14–20long-termrequirements,14–15three-tierarchitecture,15–20namingstandards,27–28overview,13technologies/tools,20–26MySQL,23–26PHP,20–21Smarty,21–22ps_check_funds.
phpfile,596ps_check_stock.
phpfile,596ps_final_notification.
phpfile,601ps_initial_notification.
phpfile,594ps_ship_goods.
phpfile,599ps_ship_ok.
phpfile,601ps_stock_ok.
phpfile,598ps_take_payment.
phpfile,598PsCheckFundsclass,572,596,639,651PsCheckStockclass,572,596–598,599PsDummyclass,592–593PsFinalNotificationclass,572,601–602PsInitialNotificationclass,572,594–595PSPad,30PsShipGoodsclass,572,599–600PsShipOkclass,572,600–601PsStockOkclass,572,598PsTakePaymentclass,572,598–599,651PsTakePaymentsclass,639PTrewriteruleoption,198QQSArewriteruleoption,198quantityfield,367queryingdata,126–130joiningdatatables,127–129retrievingshortdescriptions,126–127showingproductspagebypage,129–130questionmark()metacharacter,196quickstartAJAX,400–413DOM,401quickstart,AJAXJavaScript,400–401whensuitable,412–413writingdegradablecode,409–410XMLHttpRequestobject,402–409RRrewriteruleoption,198rand()method,377RDBMSs(relationaldatabasemanagementsystems),23,81,114readyStatemethod,405readyStateproperty,408readystatechangeevent,408recommendations,product,461–474dynamicrecommendations,461–463overview,461selectingrecommendationsfromdatabase,464–471records,71referencefield,544referencedtable,119referencingtable,119refund,625regularexpressions,195–199relationaldata,114relationaldatabasemanagementsystems(RDBMSs),23,81,114relationaldatabases,114–120INDEX702MySQLtabletypes,120tablerelationships,115–119enforcingusingforeignkeys,119–120many-to-many,117–119one-to-many,116–117reliability,15REMOVE_PRODUCTconstant,392RemoveProduct()method,372RemoveProductAttributeValuemethod,343RemoveProductFromCategorymethod,343REPAIRTABLEindexes,230reportingerrors,52–60RepresentationalStateTransfer(REST),665,670–675responsegroup,671responseTextmethod,405responseXmlmethod,405REST(RepresentationalStateTransfer),665,670–675reviews.
tplfile,662RewriteBasecommand,195RewriteCondcommand,195,199RewriteRulecommand,195,198–199$rHowManyPagesparameter,145,236risks,6–7Rivest-Shamir-Adleman(RSA),484RSA(Rivest-Shamir-Adleman),484SSrewriteruleoption,198SAVE_PRODUCT_FOR_LATERconstant,392SaveProductForLater()method,372scalablearchitecture,15SciTe,30searchengineoptimization(SEO),189–220customizingpagetitles,208–211keyword-richURLsgenerating,199–203supporting,191–195mod_rewritemodule,195–199overview,189–190regularexpressions,195–199TShirtShop,190–191updatingcatalogpagination,211–214Search()method,234,236,248search_box.
tpltemplate,238,239–243$search_resultarray,236search_resulttemplate,238,244search_resultstemplate,238$search_stringvariable,238SearchBoxclass,242$searchStringparameter,236secretaccesskey,668secureconnections,272–274SecureHashAlgorithm(SHA1),481SecureSocketLayer.
SeeSSLsecure_card.
phpfile,480SecureCardclass,490–500SecureCardobject,499securitycertificate,272securityclasses,480–500encryptionfunctionalityinbusinesstier,483–489hashingfunctionalityinbusinesstier,480–483overview,480storingcreditcardinformation,490–500SELECTclause,129SELECTquery,135,142,179,464SELECTstatement,81–82,127,130,180,225element,188self-describingcode,131self-documentingcode,131send()method,406SEO.
Seesearchengineoptimizationset_error_handler()function,52,58SetCartId()method,372,376,377SetImage1method,343SetImage2method,343SetProductDisplayOptionmethod,343SetRequest()method,648setRequestHeader("label","value")method,405SetThumbnailmethod,343SHA1(SecureHashAlgorithm),481SHA1()encryptionfunction,483shipped_onfield,435shippingcharges,560–568implementing,561–568issueswith,561overview,560shipping_addressfield,544INDEX703shipping_regiontable,478,561shoppingcart,252–265,363–398administering,392–398buildingpage,393–398deletingproducts,392AJAX,413–430enhancing,426–430enhancingAddtoCartfeature,415–426creating,8designing,364–366overview,363storinginformation,366–392businesstier,372–378datatier,367–371presentationtier,378–392shopping_carttable,366,393,436shopping_cart_add_productstoredproce-dure,367–369shopping_cart_count_old_cartsstoredprocedure,398shopping_cart_create_orderstoredprocedure,436–439,544shopping_cart_delete_old_cartsstoredprocedure,398shopping_cart_emptystoredprocedure,436–438shopping_cart_get_productsstoredprocedure,367shopping_cart_get_recommendationsstoredprocedure,469shopping_cart_get_saved_productsstoredprocedure,368shopping_cart_get_total_amountstoredprocedure,368shopping_cart_move_product_to_cartstoredprocedure,368shopping_cart_remove_productstoredprocedure,367shopping_cart_save_product_for_laterstoredprocedure,368shopping_cart_updatestoredprocedure,367shopping_cart.
phpfile,372ShoppingCartclass,372,438–442,471SHORT_PRODUCT_DESCRIPTION_LENGTHconstant,140ShowCertificate,274showErrorsvariable,423SimpleMailTransferProtocol(SMTP),59,592SimpleObjectAccessProtocol(SOAP),665,676–677SimpleXMLextension,630simplexml_load_string()function,683SimpleXMLElementobject,683SingleItemPurchasesfeature,266sitearchitecture,7–8siteskeleton,40–60buildingfrontpage,43–52handling/reportingerrors,52–60site_titlevariable,51#site_title#directory,51site.
conffile,51Smarty,21–22,48Smartyplug-ins,102–110Smartytemplate,176smarty_function_load_presentation_object()plug-infunction,109$smarty.
configvariable,51SMTP(SimpleMailTransferProtocol),59,592SOAP(SimpleObjectAccessProtocol),665,676–677__soapCall()function,677SoapFaultexceptionclass,677SoapFaulttype,677SQL(StructuredQueryLanguage),7,23,81–84DELETEcommand,84INSERTstatement,83queries,23SELECTstatement,81–82UPDATEstatement,84SSL(SecureSocketLayer),9,272configuringTShirtShopfor,274–275connections,540–541enforcingconnections,275–276obtainingcertificates,275staticmethods,99statusmethod,405statusTextmethod,405stockcheck,571store_adminSmartycomponentizedtemplate,304INDEX704store_admintemplate,285store_admin.
phpfile,285store_frontcomponentizedtemplate,148store_front.
tplfile,109–112,151store_front.
tpltemplate,42,379storedprocedures,81,131–139,232–234catalog_count_products_in_category,133–134catalog_count_products_on_catalog,137catalog_count_products_on_department,135–136catalog_get_categories_list,133catalog_get_category_details,133catalog_get_department_details,132–133catalog_get_product_details,138catalog_get_product_locations,138–139catalog_get_products_in_category,134–135catalog_get_products_on_catalog,137–138catalog_get_products_on_department,136–137StoreFrontclass,165,208–211,540storingcustomeraccounts,478–480customer/shipping_regiontables,479–480overview,478TShirtShop,478–479orderdetails,433–436strftimefunction,453StructuredQueryLanguage.
SeeSQLsubmitevent,430submitEditparameter,460subscriptionID,668substringmethod,426symmetricencryption,483symmetric_crypt.
phpfile,480SymmetricCryptclass,485–489TTrewriteruleoption,198tablejoins,127tablerelationships,115–119enforcingusingforeignkeys,119–120many-to-many,117–119one-to-many,116–117taxes,customerorders,560–568implementing,561–568issueswith,560–561overview,560TCP/IP(TransmissionControlProtocol/InternetProtocol),623templateengines,21templatesfolder,40templates_cfolder,40TESTmode,628test_datacash.
phpfile,638test_encryption.
phpfile,487test_encryption.
phptestfile,489test_rest.
phpfile,673test_soap.
phpfile,676–677testingorderpipeline,603–612textdatatype,75threats,6–7three-tierarchitecture,15–20example,16–17logic,18–19moretiers,19–20MySQL,26numbers,18TShirtShop,19thumbnailfield,124tag,191ToCategory()method,203ToDepartment()method,203ToIndex()method,168,203ToProduct()method,203total_amountfield,435total_amountstoredprocedure,438.
tpltemplates,22,40TransmissionControlProtocol/InternetProtocol(TCP/IP),623trigger_error()function,60,100,677triggers,120TripleDES(3DES),484tryblock,90,404,677trykeyword,90try-catchblock,91,403,408,677INDEX705TShirtShop,10–11addingcustomerordersto,547addingfunctionalityto,500–529businesstier,505–509datatier,502–504overview,500–502presentationtier,509–529Amazon.
comwebservices,678–688businesstier,679–684presentationtier,684–688Authorize.
net,651–653configuringforSSL,274–275DataCash,639–643SEO,190–191storingcustomeraccounts,478–479three-tierarchitecture,19tshirtshopdatabase,68,78,107,178–181,392,592,615tshirtshopdirectory,673tshirtshopfolder,195TShirtShopproject,29–61codeeditors,30downloadingcode,61installingSmarty,38–40XAMPP,30–34overview,29–30preparingalias,34–38preparingdatabase,60–61siteskeleton,40–60buildingfrontpage,43–52handling/reportingerrors,52–60tshirtshopadminuser,107tshirtshop.
csspage,447UUI(userinterface),656UNION,180uniqid()method,377UNIQUEcolumns,74UNIQUEconstraint,74,119Updatebutton,269Update()method,372UPDATEstatement,81,84update_deptbuttontype,293UPDATE_PRODUCTS_QUANTITIESconstant,392updateCartSummary()function,425UpdateOrder()method,551UpdateOrderStatus()method,592UpdateProductmethod,343updatingAddtoCartbutton,379–381catalogpagination,211–214checkoutpage,612–615ordersadministrationpage,615–623businesstier,616datatier,615–616presentationtier,617–623ordersprocessingcode,592Up-Selling,462urlencode()function,254,649URLscanonicalization,190correctionwith301redirects,203–208keyword-richgenerating,199–203supporting,191–195rewriting,191USE_SSLconstant,275–276userinterface(UI),656Vvarchardatatype,76varcharvariabledatatype,75ViewCartbutton,252,364VIRTUAL_LOCATIONconstant,112WwebservicesAmazon.
com,665–688accessing,667–677integratingwithTShirtShop,678–688overview,665defined,665–667WebServicesDefinitionLanguage(WSDL)file,677Webmonkey,7welcome.
htmldocument,61WHEREclause,77,82,84,133,225,466Windows,preparingaliaseson,37–38WITHQUERYEXPANSIONqueryexpansion,232WSDL(WebServicesDefinitionLanguage)file,677INDEX706XXMLdata,exchangingwithDataCash,630–639XMLHttpRequestobject,400–415xmlHttp.
send()function,407YYahooUserInterfaceLibrary(YUI),41ZZendStudio,30INDEX707