PHP Solutions

1. Front Matter

   Pages i-xviii

   PDF

2. What Is PHP— And Why Should I Care?

   • David Powers

   Pages 1-8

3. Getting Ready to Work with PHP

   • David Powers

   Pages 9-27

4. How to Write PHP Scripts

   • David Powers

   Pages 29-67

5. Lightening Your Workload with Includes

   • David Powers

   Pages 69-101

6. Bringing Forms to Life

   • David Powers

   Pages 103-140

7. Uploading Files

   • David Powers

   Pages 141-178

8. Using PHP to Manage Files

   • David Powers

   Pages 179-213

9. Generating Thumbnail Images

   • David Powers

   Pages 215-242

10. Pages That Remember: Simple Login and Multipage Forms

    • David Powers

    Pages 243-278

11. Getting Started with MySQL

    • David Powers

    Pages 279-301

12. Connecting to MySQL with PHP and SQL

    • David Powers

    Pages 303-334

13. Creating a Dynamic Online Gallery

    • David Powers

    Pages 335-353

14. Managing Content

    • David Powers

    Pages 355-381

15. Formatting Text and Dates

    • David Powers

    Pages 383-414

16. Pulling Data from Multiple Tables

    • David Powers

    Pages 415-429

17. Managing Multiple Database Tables

    • David Powers

    Pages 431-458

18. Authenticating Users with a Database

    • David Powers

    Pages 459-473

19. Back Matter

    Pages 475-508

    PDF

This is the second edition of David Powers' highly-respected PHP Solutions: Dynamic Web Design Made Easy. This new edition has been updated by David to incorporate changes to PHP since the first edition and to offer the latest techniques—a classic guide modernized for 21st century PHP techniques, innovations, and best practices.

You want to make your websites more dynamic by adding a feedback form, creating a private area where members can upload images that are automatically resized, or perhaps storing all your content in a database. The problem is, you're not a programmer and the thought of writing code sends a chill up your spine. Or maybe you've dabbled a bit in PHP and MySQL, but you can't get past baby steps. If this describes you, then you've just found the right book. PHP and the MySQL database are deservedly the most popular combination for creating dynamic websites. They're free, easy to use, and provided by many web hosting companies in their standard packages.

Unfortunately, most PHP books either expect you to be an expert already or force you to go through endless exercises of little practical value. In contrast, this book gives you real value right away through a series of practical examples that you can incorporate directly into your sites, optimizing performance and adding functionality such as file uploading, email feedback forms, image galleries, content management systems, and much more. Each solution is created with not only functionality in mind, but also visual design.

But this book doesn't just provide a collection of ready-made scripts: each PHP Solution builds on what's gone before, teaching you the basics of PHP and database design quickly and painlessly. By the end of the book, you'll have the confidence to start writing your own scripts or—if you prefer to leave that task to others—to adapt existing scripts to your own requirements. Right from the start, you're shown how easy it is to protect your sites by adopting secure coding practices.

• MySQL
• PHP
• content management
• database
• database design
• innovation
• management
• performance
• techniques

David Powers is an Adobe Community Expert for Dreamweaver and author of a series of highly successful books on PHP, including PHP Solutions: Dynamic Web Design Made Easy and Foundation PHP for Dreamweaver 8. As a professional writer, he has been involved in electronic media for more than 30 years, first with BBC radio and television and more recently with the Internet. His clear writing style is valued not only in the English-speaking world; several of his books have been translated into Spanish and Polish. What started as a mild interest in computing was transformed almost overnight into a passion, when David was posted to Japan in 1987 as BBC correspondent in Tokyo. With no corporate IT department just down the hallway, he was forced to learn how to fix everything himself. When not tinkering with the innards of his computer, he was reporting for BBC television and radio on the rise and collapse of the Japanese bubble economy. Since leaving the BBC to work independently, he has built up an online bilingual database of economic and political analysis for Japanese clients of an international consultancy. When not pounding the keyboard writing books or dreaming of new ways of using PHP and other programming languages, David enjoys nothing better than visiting his favorite sushi restaurant. He has also translated several plays from Japanese.

Policies and ethics