PHP & MYSQL GUIDE
ABOUT THIS BOOK CONVENTIONS USED IN THIS BOOK WHAT YOU’RE NOT TO READ FOOLISH ASSUMPTIONS HOW THIS BOOK IS ORGANIZED PART I: DEVELOPING A WEB DATABASE APPLICATION USING PHP AND MYSQL PART II: MYSQL DATABASE PART III: PHP PART IV: APPLICATIONS PART V: THE PART OF TENS PART VI: APPENDIXES ICONS USED IN THIS BOOK WHERE TO GO FROM HERE WHAT IS A WEB DATABASE APPLICATION? THE DATABASE THE APPLICATION: MOVING DATA INTO AND OUT OF THE DATABASE MYSQL, MY DATABASE ADVANTAGES OF MYSQL HOW MYSQL WORKS COMMUNICATING WITH THE MYSQL SERVER PHP, A DATA MOVER ADVANTAGES OF PHP HOW PHP WORKS MYSQL AND PHP, THE PERFECT PAIR ADVANTAGES OF THE RELATIONSHIP HOW MYSQL AND PHP WORK TOGETHER KEEPING UP WITH PHP AND MYSQL CHANGES THE REQUIRED TOOLS FINDING A PLACE TO WORK A COMPANY WEB SITE A WEB HOSTING COMPANY SETTING UP AND RUNNING A WEB SITE ON YOUR LOCAL COMPUTER TESTING, TESTING, 1, 2, 3 UNDERSTANDING PHP/MYSQL FUNCTIONS TESTING PHP TESTING MYSQL PLANNING YOUR WEB DATABASE APPLICATION IDENTIFYING WHAT YOU WANT FROM THE APPLICATION TAKING THE USER INTO CONSIDERATION MAKING THE SITE EASY TO USE LEAVING ROOM FOR EXPANSION WRITING IT DOWN PRESENTING THE TWO RUNNING EXAMPLES IN THIS BOOK STUFF FOR SALE MEMBERS ONLY DESIGNING THE DATABASE CHOOSING THE DATA ORGANIZING THE DATA DESIGNING THE SAMPLE DATABASES PET CATALOG DESIGN PROCESS MEMBERS ONLY DESIGN PROCESS TYPES OF DATA CHARACTER DATA NUMERICAL DATA DATE AND TIME DATA ENUMERATION DATA MYSQL DATA TYPE NAMES TAKING A LOOK AT THE SAMPLE DATABASE DESIGNS STUFF FOR SALE DATABASE TABLES MEMBERS ONLY DATABASE TABLES DEVELOPING THE APPLICATION BUILDING THE DATABASE WRITING THE PROGRAMS COMMUNICATING WITH MYSQL BUILDING SQL QUERIES SENDING SQL QUERIES BUILDING A DATABASE CREATING A NEW DATABASE DELETING A DATABASE ADDING TABLES TO A DATABASE CHANGING THE DATABASE STRUCTURE PHP AND MYSQL FOR DUMMIES, 3RD EDITION MOVING DATA INTO AND OUT OF THE DATABASE ADDING INFORMATION RETRIEVING INFORMATION COMBINING INFORMATION FROM TABLES UPDATING INFORMATION REMOVING INFORMATION CONTROLLING ACCESS TO YOUR DATA UNDERSTANDING ACCOUNT NAMES AND HOSTNAMES FINDING OUT ABOUT PASSWORDS TAKING A LOOK AT ACCOUNT PERMISSIONS SETTING UP MYSQL ACCOUNTS IDENTIFYING WHAT ACCOUNTS CURRENTLY EXIST ADDING ACCOUNTS ADDING AND CHANGING PASSWORDS CHANGING PERMISSIONS REMOVING ACCOUNTS AND PERMISSIONS BACKING UP YOUR DATA RESTORING YOUR DATA UPGRADING MYSQL ADDING A PHP SECTION TO AN HTML PAGE WRITING PHP STATEMENTS USING PHP VARIABLES NAMING A VARIABLE CREATING AND ASSIGNING VALUES TO VARIABLES DEALING WITH NOTICES USING PHP CONSTANTS WORKING WITH NUMBERS WORKING WITH CHARACTER STRINGS SINGLE-QUOTED STRINGS VERSUS DOUBLE-QUOTED STRINGS JOINING STRINGS WORKING WITH DATES AND TIMES SETTING LOCAL TIME FORMATTING A DATE STORING A TIMESTAMP IN A VARIABLE USING DATES WITH MYSQL COMPARING VALUES MAKING SIMPLE COMPARISONS MATCHING CHARACTER STRINGS TO PATTERNS JOINING COMPARISONS WITH AND/OR/XOR ADDING COMMENTS TO YOUR PROGRAM USEFUL SIMPLE STATEMENTS USING ECHO STATEMENTS USING ASSIGNMENT STATEMENTS USING INCREMENT STATEMENTS USING EXIT USING FUNCTION CALLS USING PHP ARRAYS CREATING ARRAYS VIEWING ARRAYS REMOVING VALUES FROM ARRAYS SORTING ARRAYS GETTING VALUES FROM ARRAYS WALKING THROUGH AN ARRAY MULTIDIMENSIONAL ARRAYS USEFUL CONDITIONAL STATEMENTS USING IF STATEMENTS USING SWITCH STATEMENTS USING LOOPS USING FOR LOOPS USING WHILE LOOPS USING DOWHILE LOOPS INFINITE LOOPS BREAKING OUT OF A LOOP USING FUNCTIONS USING VARIABLES IN FUNCTIONS PASSING VALUES BETWEEN A FUNCTION AND THE MAIN PROGRAM USING BUILT-IN FUNCTIONS PHP AND MYSQL FUNCTIONS MAKING A CONNECTION CONNECTING TO THE MYSQL SERVER SELECTING THE RIGHT DATABASE GETTING INFORMATION FROM A DATABASE SENDING A SELECT QUERY GETTING AND USING THE DATA USING FUNCTIONS TO GET DATA GETTING INFORMATION FROM THE USER USING HTML FORMS MAKING FORMS DYNAMIC USING THE INFORMATION FROM THE FORM CHECKING THE INFORMATION GIVING USERS A CHOICE WITH MULTIPLE SUBMIT BUTTONS PUTTING INFORMATION INTO A DATABASE PREPARING THE DATA ADDING NEW INFORMATION UPDATING EXISTING INFORMATION PHP AND MYSQL FOR DUMMIES, 3RD EDITION GETTING INFORMATION IN FILES USING A FORM TO UPLOAD THE FILE PROCESSING THE UPLOADED FILE PUTTING IT ALL TOGETHER MOVING YOUR USER FROM ONE PAGE TO ANOTHER MOVING INFORMATION FROM PAGE TO PAGE ADDING INFORMATION TO THE URL STORING INFORMATION VIA COOKIES PASSING INFORMATION WITH HTML FORMS USING PHP SESSIONS OPENING SESSIONS USING PHP SESSION VARIABLES SESSIONS WITHOUT COOKIES MAKING SESSIONS PRIVATE CLOSING PHP SESSIONS ORGANIZING THE APPLICATION ORGANIZING AT THE APPLICATION LEVEL ORGANIZING AT THE PROGRAM LEVEL KEEPING IT PRIVATE ENSURE THE SECURITY OF THE COMPUTER DON’T LET THE WEB SERVER DISPLAY FILENAMES HIDE THINGS DON’T TRUST INFORMATION FROM USERS USE A SECURE WEB SERVER COMPLETING YOUR DOCUMENTATION DESIGNING THE APPLICATION SHOWING PETS TO THE CUSTOMERS ADDING PETS TO THE CATALOG BUILDING THE DATABASE BUILDING THE PET TABLE BUILDING THE PETTYPE TABLE BUILDING THE COLOR TABLE ADDING DATA TO THE DATABASE DESIGNING THE LOOK AND FEEL WRITING THE PROGRAMS BUILDING THE MEMBER TABLE BUILDING THE LOGIN TABLE STOREFRONT PAGE LOGIN PAGE NEW MEMBER WELCOME PAGE MEMBERS ONLY SECTION WRITING PETSHOPFRONT WRITING LOGIN WRITING NEW_MEMBER WRITING THE MEMBERS ONLY SECTION PLANNING FOR GROWTH COMMUNICATE WITH MYSQL SEND E-MAIL USE PHP SESSIONS STOP YOUR PROGRAM HANDLE ARRAYS CHECK FOR VARIABLES FORMAT VALUES COMPARE STRINGS TO PATTERNS FIND OUT ABOUT STRINGS CHANGE THE CASE OF STRINGS MISSING SEMICOLONS NOT ENOUGH EQUAL SIGNS MISSPELLED VARIABLE NAMES MISSING DOLLAR SIGNS TROUBLING QUOTES INVISIBLE OUTPUT NUMBERED ARRAYS INCLUDING PHP STATEMENTS MISSING MATES CONFUSING PARENTHESES AND BRACKETS