PHP IS A POPULAR PROGRAMMING LANGUAGE that powers many websites. It originally started out as a way to make dynamic websites by generating HTML. Today it stands on its own as a generalpurpose programming language and is available on most web hosting sites. Because of its roots, it is very easy to insert bits and pieces of PHP inside of standard HTML/XHTML code.

MySQL is a popular relational database management system. It is the standard database system available on web hosting sites. Although it works with many different programming languages, it is frequently paired with PHP.

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 • Creating user logins • Turn the case study into a content management system

Note: 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.