by Andrea Tarr | Publisher: Wrox | Release Date: November 2011 | ISBN: 01420110016SI

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 videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises.

1. Lesson 01: Setting up Your Workspace 00:09:31
2. Lesson 02: Adding PHP to a Web Page 00:14:59
3. Lesson 03: Learning PHP Syntax 00:20:20
4. Lesson 04: Working with Variables 00:28:49
5. Lesson 05: Debugging Code 00:19:31
6. Lesson 06: Working with Complex Data 00:14:47
7. Lesson 07: Making Decisions 00:27:29
8. Lesson 08: Repeating Program Steps 00:15:47
9. Lesson 09: Learning about Scope 00:06:13
10. Lesson 10: Reusing Code with Functions 00:16:48
11. Lesson 11: Creating Forms 00:25:45
12. Lesson 12: Introducing Object-Oriented Programming 00:03:26
13. Lesson 13: Defining Classes 00:13:33
14. Lesson 14: Using Classes 00:20:27
15. Lesson 15: Using Advanced Techniques 00:15:47
16. Lesson 16: Handling Errors 00:18:59
17. Lesson 17: Writing Secure Code 00:21:35
18. Lesson 18: Introducing Databases 00:10:33
19. Lesson 19: Introducing MySQL 00:16:24
20. Lesson 20: Creating and Connecting to the Database 00:25:48
21. Lesson 21: Creating Tables 00:27:32
22. Lesson 22: Entering Data 1:06:58
23. Lesson 23: Selecting Data 00:49:12
24. Lesson 24: Using Multiple Tables 00:24:57
25. Lesson 25: Changing Data 00:37:44
26. Lesson 26: Deleting Data 00:25:28
27. Lesson 27: Preventing Database Security Issues 00:07:16
28. Lesson 28: Creating User Logins 00:35:00
29. Lesson 29: Turning the Case Study into a Content Management System 00:17:56
30. Lesson 30: Creating a Dynamic Menu 00:24:15



01420110016SI.PHP.and.MySQL.24-Hour.Trainer.part1.OR.rar

01420110016SI.PHP.and.MySQL.24-Hour.Trainer.part2.OR.rar