by SAMS Publishing | Publisher: Sams | Release Date: February 2009 | ISBN: 9780768689488

Sams Teach Yourself PHP and MySQL Video Learning brings the successful Teach Yourself book series from Sams Publishing to life on video — with the same clear and concise style, practical hands-on examples, and self-paced learning approach that have made the bestselling books so popular with beginners looking for the easiest way to quickly get up to speed on a new technology.  This complete video course provides up to four hours of clear, well-organized video instruction. Each 10-minute video lesson uses a consistent, step-by-step learning structure.  After a short overview of the topic from the series instructor, each lesson presents a short, richly illustrated tutorial lesson, followed by a hands-on learning lab, and concluding with an interactive quiz lets the learner test how well he or she has grasped the material before moving on.With Sams Teach Yourself PHP and MySQL Video Learning, you'll quickly and easily learn all the basics of setting up an interactive, dynamic web site:Install and configure PHP and MySQL on your computerCreate PHP scripts for your web siteWork with forms and filesAccess information in databasesAuthenticate and track users with cookies and sessionsSet up a secure web serverThe DVD contains a complete video training starter kit for Windows and Mac computers:Four hours of video lessons with interactive labs and quizzesPHP, MySQL, and Apache for Windows and Mac OS X–an easy-to-install package to set up a safe learning environmentWork files for all the learning labsThe jEdit programming editor for Windows and Mac OS X

1. Part I - PHP Foundations
   • Lesson 1: PHP Basics 00:08:25
   • Lesson 2: Variables 00:07:23
   • Lesson 3: Flow Control 00:09:32
   • Lesson 4: Functions 00:09:51
   • Lesson 5: Working with Numbers 00:09:16
   • Lesson 6: Working with Strings 00:09:56
2. Part II - Using PHP to Work with Data
   • Lesson 7: Working with Arrays 00:11:31
   • Lesson 8: Regular Expressions 00:12:29
   • Lesson 9: Working with Dates and Times 00:06:43
   • Lesson 10: Using Classes 00:08:56
   • Lesson 11: Processing HTML Forms 00:10:30
   • Lesson 12: Generating Dynamic HTML 00:10:53
3. Part III - PHP and the Web Environment
   • Lesson 13: Form Validation 00:07:15
   • Lesson 14: Cookies and Sessions 00:07:19
   • Lesson 15: User Authentication 00:09:40
   • Lesson 16: Communicating with the Web Server 00:10:38
   • Lesson 17: Filesystem Access 00:12:17
   • Lesson 18: Host Program Execution 00:10:00
4. Part IV - Using MySQL with PHP
   • Lesson 19: Using a MySQL Database 00:11:43
   • Lesson 20: Database Abstraction 00:10:17
   • Lesson 21: Running PHP on the Command Line 00:08:49
   • Lesson 22: Error Handling and Debugging 00:08:13
   • Lesson 23: PHP Configuration 00:11:45
   • Lesson 24: PHP Security 00:10:13
   • Lesson 25: Using PEAR 00:08:25