PHP and MySQL 24-Hour Trainer

Informationen zum Autor 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. Klappentext Step-by-step lessons for using PHP and MySQL in a unique book-and-video combinationAssuming 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 video enhances your learning experience, as each lesson in the book is portrayed on the DVD through detailed exercises. Serves as the ideal learning tool: a book-and-video package that features coordinating lessons on both components to drive home each lesson Covers setting up your computer to use PHP, installing a code editor, adding PHP to a web page, learning PHP syntax, and debugging code Encompasses complex data types, repeating program steps, reusing code with functions, and using object oriented programming Explains creating MySQL databases and tables; entering and manipulating data; working with multiple tables and preventing database security issuesPresenting you with up-to-date programming styles and an unassuming tone, this book-and-DVD package is the ideal resource to dive in with using PHP and MySQL today. Zusammenfassung Step-by-step lessons for using PHP and MySQL in a unique book-and-video combinationAssuming 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 video enhances your learning experience, as each lesson in the book is portrayed on the DVD through detailed exercises. Serves as the ideal learning tool: a book-and-video package that features coordinating lessons on both components to drive home each lesson Covers setting up your computer to use PHP, installing a code editor, adding PHP to a web page, learning PHP syntax, and debugging code Encompasses complex data types, repeating program steps, reusing code with functions, and using object oriented programming Explains creating MySQL databases and tables; entering and manipulating data; working with multiple tables and preventing database security issuesPresenting you with up-to-date programming styles and an unassuming tone, this book-and-DVD package is the ideal resource to dive in with using PHP and MySQL today....

Autorentext

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.

Klappentext

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 video enhances your learning experience, as each lesson in the book is portrayed on the DVD through detailed exercises. Serves as the ideal learning tool: a book-and-video package that features coordinating lessons on both components to drive home each lesson Covers setting up your computer to use PHP, installing a code editor, adding PHP to a web page, learning PHP syntax, and debugging code Encompasses complex data types, repeating program steps, reusing code with functions, and using object oriented programming Explains creating MySQL databases and tables; entering and manipulating data; working with multiple tables and preventing database security issues Presenting you with up-to-date programming styles and an unassuming tone, this book-and-DVD package is the ideal resource to dive in with using PHP and MySQL today.

Inhalt

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