0 CHECKOUT

PHP and MySQL 24-Hour Trainer

  • ID: 2292981
  • February 2012
  • 504 Pages
  • John Wiley and Sons Ltd
1 of 4

Take static pages and turn them into a dynamic website!

Perhaps you know how to create a static website using HTML/CSS, but now you want to learn how to create dynamic, data–driven websites. If you're new to PHP and MySQL, this book–and–DVD package is an ideal introduction to working with website pages that contain a mixture of HTML and PHP/MySQL. Author Andrea Tarr starts with what you know an HTML/CSS website and step by step she teaches you how to replace and enhance the site using PHP to create and manipulate your HTML pages and MySQL to bring in your data. You learn how to design, create, and use databases with MySQL, both within PHP programs and using the popular phpMyAdmin program. Explaining the programming principles as you go along, this book–and–DVD combination provides you with a solid understanding of the fundamentals of PHP and the basics of object–oriented programming.

PHP and MySQL 24–Hour Trainer:

Escorts you through preparing your computer to run PHP and MySQL by downloading and installing free software

Explains what variables are, how to work with them, and how to debug your programs

Zeros READ MORE >

Note: Product cover images may vary from those shown
2 of 4

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

Note: Product cover images may vary from those shown
3 of 4

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.

Note: Product cover images may vary from those shown
4 of 4
Note: Product cover images may vary from those shown

PLEASE SELECT A FORMAT

  • Quick Help: The book will be shipped to you. The cover has a paper back.

HAVE A QUESTION?

If you have a more general question about our products please try our

FAQ SECTION

RELATED PRODUCTS from Db

Our Clients

  • Symantec Corporation
  • Genesys Telecommunications Laboratories, Inc.
  • Adobe Systems Incorporated
  • Ir Prognosis
  • NCR Corporation
  • Oracle Corporation