PHP & MYSQL EVERYDAY APPS GUIDE
ABOUT THIS BOOK CONVENTIONS USED IN THIS BOOK FOOLISH ASSUMPTIONS HOW THIS BOOK IS ORGANIZED PART I: INTRODUCING APPLICATION DEVELOPMENT PART II: BUILDING A USER AUTHENTICATION APPLICATION PART III: BUILDING ONLINE SALES APPLICATIONS PART IV: BUILDING OTHER USEFUL APPLICATIONS PART V: THE PART OF TENS PART VI: APPENDIXES ABOUT THE CD ICONS USED IN THIS BOOK WHERE TO GO FROM HERE UNDERSTANDING PHP AND MYSQL VERSIONS MYSQL PHP PHP AND MYSQL TOGETHER USING THE APPLICATION SOURCE CODE CHOOSING A LOCATION UNDERSTANDING THE PHP CODE PROCEDURAL VERSUS OBJECT-ORIENTED PROGRAMS MODIFYING THE SOURCE CODE PROGRAMMING EDITORS INTEGRATED DEVELOPMENT ENVIRONMENT (IDE) PLANNING YOUR APPLICATION PLANNING THE SOFTWARE ADDITIONAL PLANNING UNDERSTANDING SECURITY RISKS BUILDING SECURITY INTO YOUR PHP SCRIPTS DON’T TRUST ANY INFORMATION FROM AN OUTSIDE SOURCE STORING INFORMATION USING SYSTEM CALLS HANDLING ERRORS MYSQL SECURITY SETTING UP ACCOUNTS AND PASSWORDS ACCESSING MYSQL FROM PHP SCRIPTS UNDERSTANDING SQL INJECTION ATTACKS BACKING UP YOUR DATABASES USING A SECURE WEB SERVER UNDERSTANDING HTTP AUTHENTICATION UNDERSTANDING HOW THE WWW WORKS REQUESTING A PASSWORD-PROTECTED FILE AUTHORIZING ACCESS USING HTTP AUTHENTICATION WITH APACHE CONFIGURING APACHE CREATING THE HTACCESS FILE CREATING THE PASSWORD FILE APACHE HTTP AUTHENTICATION IN ACTION DESIGNING AN HTTP AUTHENTICATION APPLICATION IN PHP CREATING A USER DATABASE DESIGNING THE USER DATABASE CREATING THE USER DATABASE ACCESSING THE USER DATABASE BUILDING THE AUTHENTICATION APPLICATION IN PHP: THE PROCEDURAL APPROACH BUILDING THE AUTHENTICATION APPLICATION IN PHP: THE OBJECT-ORIENTED APPROACH DEVELOPING THE OBJECTS WRITING THE PASSWORDPROMPTER CLASS WRITING THE DATABASE CLASS WRITING THE ACCOUNT CLASS WRITING THE WEBPAGE CLASS WRITING THE AUTH-OO SCRIPT DESIGNING THE LOGIN APPLICATION CREATING THE USER DATABASE DESIGNING THE DATABASE BUILDING THE DATABASE ACCESSING THE DATABASE ADDING DATA TO THE DATABASE BUILDING THE LOGIN WEB PAGE DESIGNING THE LOGIN WEB PAGE WRITING THE CODE FOR THE LOGIN PAGE DISPLAYING THE LOGIN WEB PAGE BUILDING THE LOGIN APPLICATION: THE PROCEDURAL APPROACH WRITING THE APPLICATION SCRIPT PROTECTING YOUR WEB PAGES BUILDING THE LOGIN APPLICATION: THE OBJECT-ORIENTED APPROACH WRITING THE WEBFORM CLASS WRITING THE SESSION CLASS WRITING THE EMAIL CLASS WRITING THE LOGIN APPLICATION SCRIPT ADDING FEATURES TO THE APPLICATION DESIGNING THE ONLINE CATALOG APPLICATION CREATING THE CATALOG DATABASE DESIGNING THE CATALOG DATABASE BUILDING THE CATALOG DATABASE ACCESSING THE FOOD DATABASE BUILDING THE CATALOG WEB PAGES DESIGNING THE CATALOG WEB PAGES WRITING THE CODE FOR THE INDEX PAGE WRITING THE CODE FOR THE PRODUCTS PAGE DISPLAYING THE CATALOG WEB PAGES BUILDING THE ONLINE CATALOG APPLICATION: PROCEDURAL APPROACH BUILDING THE ONLINE CATALOG APPLICATION: THE OBJECT-ORIENTED APPROACH DEVELOPING THE OBJECTS WRITING THE CATALOG CLASS WRITING THE CATALOG APPLICATION SCRIPT GROWING THE CATALOG CLASS DESIGNING THE SHOPPING CART APPLICATION BASIC APPLICATION DESIGN DECISIONS APPLICATION FUNCTIONALITY DESIGN CREATING THE SHOPPING CART DATABASE DESIGNING THE SHOPPING CART DATABASE BUILDING THE SHOPPING CART DATABASE ACCESSING THE SHOPPING CART DATABASE ADDING DATA TO THE SHOPPING CART DATABASE BUILDING THE SHOPPING CART WEB PAGES DESIGNING THE SHOPPING CART WEB PAGES WRITING THE CODE FOR THE PRODUCT INFORMATION PAGE WRITING THE CODE FOR THE SHOPPING CART WEB PAGE WRITING THE CODE FOR THE SHIPPING INFORMATION FORM WRITING THE CODE FOR THE SUMMARY PAGE BUILDING THE SHOPPING CART APPLICATION: THE PROCEDURAL APPROACH WRITING SHOPCATALOG PHP WRITING SHOPPINGCART PHP WRITING PROCESSORDER PHP BUILDING THE SHOPPING CART APPLICATION: THE OBJECT-ORIENTED APPROACH WRITING THE ITEM CLASS WRITING THE SHOPPINGCART CLASS WRITING THE ORDER CLASS WRITING THE EMAIL CLASS WRITING THE SHOPPING CART APPLICATION SCRIPT DESIGNING THE CMS APPLICATION CREATING THE CMS DATABASE DESIGNING THE CMS DATABASE BUILDING THE CMS DATABASE ACCESSING THE CMS DATABASE DESIGNING THE CMS WEB PAGES BUILDING THE CMS APPLICATION: PROCEDURAL APPROACH WRITING THE LOGIN CODE WRITING COMPANYHOME PHP, A DATA RETRIEVAL FILE WRITING COMPANY INC, THE MAIN HTML DISPLAY FILE WRITING THE CONTENT DETAIL CODE WRITING ADMIN PHP, THE DATA MANIPULATION CODE BUILDING THE CMS APPLICATION: OBJECT-ORIENTED APPROACH WRITING THE OBJECT MODEL WRITING A BASIC DATA CLASS WRITING THE DEPARTMENT CLASS WRITING THE CONTENTTYPE CLASS WRITING THE CONTENTITEM CLASS WRITING THE CONTENTDOWNLOAD CLASS WRITING FIELDS_CONTENT INC AND CONTENT_FORM INC WRITING THE DISPLAY CODE WRITING ADMIN-OO PHP, THE DATA MANIPULATION CODE ENHANCING THE CONTENT MANAGEMENT SYSTEM DESIGNING THE FORUM APPLICATION CREATING THE FORUM DATABASE DESIGNING THE FORUM DATABASE BUILDING THE FORUM TABLES ACCESSING THE FORUM TABLES BUILDING THE FORUM WEB PAGES DESIGNING THE FORUM WEB PAGES WRITING THE CODE FOR THE FORUMS PAGE WRITING THE CODE FOR THE THREADS PAGE WRITING THE CODE FOR THE MESSAGES PAGE WRITING THE CODE FOR THE NEW MESSAGE PAGE WRITING THE CODE FOR THE REPLY PAGE BUILDING THE FORUM APPLICATION: PROCEDURAL APPROACH WRITING VIEWFORUMS PHP WRITING VIEWTOPIC PHP WRITING VIEWTHREAD PHP WRITING POSTMESSAGE PHP WRITING POSTREPLY PHP WRITING THE SUPPORTING FUNCTIONS BUILDING THE FORUM APPLICATION: THE OBJECT-ORIENTED APPROACH WRITING THE TABLEACCESSOR CLASS WRITING THE THREAD CLASS WRITING THE POST CLASS WRITING THE FORUM APPLICATION SCRIPTS POSSIBLE ENHANCEMENTS PLAN FIRST BE CONSISTENT TEST CODE INCREMENTALLY REMEMBER THOSE WHO FOLLOW USE CONSTANTS WRITE REUSABLE CODE SEPARATE PAGE LAYOUT FROM FUNCTION DON’T REINVENT THE WHEEL USE THE DISCUSSION LISTS FREQUENTLY, BUT WISELY DOCUMENT EVERYTHING SOURCEFORGE NET WEBERDEV PHP CLASSES CODEWALKERS PHP BUILDER HOTSCRIPTS COM ZEND PHP FREAKS PX: THE PHP CODE EXCHANGE FREE PHP AND MYSQL HOSTING DIRECTORY