PHP and MySQL 24-Hour Trainer

This book teaches the web site developers the basics of programming and PHP and MySQL in individual lessons starting with the installation of the necessary programs to run PHP. Starting with a static website, PHP functionality is added as the reader works through the lessons. When working with databases, the MySQL database is introduced and then shows the reader how you interact with it. An accompanying video walks the reader through the exercises and all code will be available for download. Covered in the book: Setting Up the Workspace, Installing XAMPP, Installing the Editor, Installing the Debugger, Adding PHP to a Web Page, Learning PHP Syntax , Working with Variables, Debugging Code, Working with Complex Data Types, Controlling What Happens When, Repeating Program Steps, Learning about Scope, Reusing Code with Functions, Objects and Classes, Introducing Object Oriented Programming, Defining a Class: the Basics, Using Classes: the Basics, Defining a Class: Advanced, Using Classes: Advanced, Preventing Errors, Handling Errors, Security Issues, Using a Database , Introducing MySQL, Connecting to the Database, Creating Databases & Tables, Entering Data, Selecting Data, Changing Data, Preventing Database Security Issues, Creating User Logins

Andrea Tarr has been a programmer and IT manager for 30 years and now spends her time programming websites using PHP/MySQL. She is a member of the Production Leadership Team for Joomla!, a popular PHP/MySQL-based content management system.

INTRODUCTION xvii

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

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

PHP and MySQL 24-Hour Trainer

Summary

Author Biography

Table of Contents

Supplemental Materials