Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons.When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises.Lessons include:• Getting started with PHP • Setting up your workspace• Adding PHP to a web page• Learning PHP syntax • Working with variables • Debugging code • Working with complex data • Making decisions • Repeating program steps • Learning about scope• Reusing code with functions• Creating forms• Introducing object-oriented programming• Defining classes• Using classes• Using advanced techniques• Handling errors• Writing secure code• Introducing databases • Introducing MySQL• Creating and connecting to the • Creating tables • Entering data • Selecting data • Using multiple tables • Changing data • Deleting data • Preventing database security issues • Creatinguser logins • Turn the case study into a content management systemNote: As part of the print version of this title, video lessons are included on DVD.For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book. INDICE: INTRODUCTION xviiSECTION I: GETTING STARTED WITH PHPLESSON 1: SETTING UP YOUR WORKSPACE 3LESSON 2: ADDING PHP TO A WEB PAGE 23LESSON 3: LEARNINGPHP SYNTAX 33LESSON 4: WORKING WITH VARIABLES 45LESSON 5: DEBUGGING CODE 57LESSON 6: WORKING WITH COMPLEX DATA 71SECTION II: WORKING WITH PHP CONTROLS, FUNCTIONS, AND FORMSLESSON 7: MAKING DECISIONS 91LESSON 8: REPEATING PROGRAM STEPS 107LESSON 9: LEARNING ABOUT SCOPE 119LESSON 10: REUSING CODE WITH FUNCTIONS 125LESSON 11: CREATING FORMS 141SECTION III: OBJECTS AND CLASSESLESSON 12: INTRODUCING OBJECT-ORIENTED PROGRAMMING 161LESSON 13: DEFINING CLASSES 167LESSON 14: USING CLASSES 177LESSON 15: USING ADVANCED TECHNIQUES 187SECTION IV: PREVENTING PROBLEMSLESSON 16: HANDLING ERRORS 205LESSON 17: WRITING SECURE CODE 217SECTION V: USING A DATABASELESSON 18: INTRODUCING DATABASES 227LESSON 19: INTRODUCING MYSQL 239LESSON 20: CREATING AND CONNECTING TO THE DATABASE 263LESSON 21: CREATING TABLES 275LESSON 22: ENTERING DATA 295LESSON 23: SELECTING DATA 313LESSON 24: USING MULTIPLE TABLES 331LESSON 25: CHANGING DATA 343LESSON 26: DELETING DATA 361LESSON 27: PREVENTING DATABASE SECURITY ISSUES 387SECTION VI: PUTTING IT ALL TOGETHERLESSON 28: CREATING USER LOGINS 399LESSON 29: TURN THE CASE STUDY INTO A CONTENT MANAGEMENT SYSTEM 419LESSON 30: CREATING A DYNAMIC MENU 443LESSON 31: NEXT STEPS 461APPENDIX : WHAT’S ON THE DVD? 463INDEX 467
- ISBN: 978-1-118-06688-1
- Editorial: John Wiley & Sons
- Encuadernacion: Rústica
- Páginas: 504
- Fecha Publicación: 02/03/2012
- Nº Volúmenes: 1
- Idioma: Inglés
- Inicio /
- INFORMÁTICA /
- MYSQL