PHP and MySQL 24-Hour Trainer

SECTION I: GETTING STARTED WITH PHP

LESSON 1: SETTING UP YOUR WORKSPACE 3

LESSON 2: ADDING PHP TO A WEB PAGE 23

LESSON 3: LEARNING PHP SYNTAX 33

LESSON 4: WORKING WITH VARIABLES 45

LESSON 5: DEBUGGING CODE 57

LESSON 6: WORKING WITH COMPLEX DATA 71

SECTION II: WORKING WITH PHP CONTROLS, FUNCTIONS, AND FORMS

LESSON 7: MAKING DECISIONS 91

LESSON 8: REPEATING PROGRAM STEPS 107

LESSON 9: LEARNING ABOUT SCOPE 119

LESSON 10: REUSING CODE WITH FUNCTIONS 125

LESSON 11: CREATING FORMS 141

SECTION III: OBJECTS AND CLASSES

LESSON 12: INTRODUCING OBJECT-ORIENTED PROGRAMMING 161

LESSON 13: DEFINING CLASSES 167

LESSON 14: USING CLASSES 177

LESSON 15: USING ADVANCED TECHNIQUES 187

SECTION IV: PREVENTING PROBLEMS

LESSON 16: HANDLING ERRORS 205

LESSON 17: WRITING SECURE CODE 217

SECTION V: USING A DATABASE

LESSON 18: INTRODUCING DATABASES 227

LESSON 19: INTRODUCING MYSQL 239

LESSON 20: CREATING AND CONNECTING TO THE DATABASE 263

LESSON 21: CREATING TABLES 275

LESSON 22: ENTERING DATA 295

LESSON 23: SELECTING DATA 313

LESSON 24: USING MULTIPLE TABLES 331

LESSON 25: CHANGING DATA 343

LESSON 26: DELETING DATA 361

LESSON 27: PREVENTING DATABASE SECURITY ISSUES 387

SECTION VI: PUTTING IT ALL TOGETHER

LESSON 28: CREATING USER LOGINS 399

LESSON 29: TURN THE CASE STUDY INTO A CONTENT MANAGEMENT SYSTEM 419

LESSON 30: CREATING A DYNAMIC MENU 443

LESSON 31: NEXT STEPS 461

APPENDIX : WHAT’S ON THE DVD? 463

INDEX 467