Master today's best practices for succeeding with PHP 5.4 and MySQL 5.5 web database development! Long acknowledged as the clearest, most practical, and most down-to-earth guide to PHP/MySQL web development, the brand-new Fifth Edition of PHP and MySQL Web Developmentfully reflects the latest versions of PHP and MySQL. Maintaining the approach that has made this book so successful through, Luke Welling and Laura Thomson add extensive new coverage of security, cloud and mobile development, and using the PEAR repository's massive resources. Part I offers a crash course in using PHP, including data storage/retrieval, arrays, strings, regular expressions, code reuse, objects, and error/exception handling. Next, walk through designing, creating, accessing, and programming MySQL databases. Part III turns to e-commerce, adding extensive new coverage of web security, plus up-to-the-minute discussions of authentication and secure transactions. A full section of advanced PHP techniques addresses everything from networking and filesystem interaction to image generation and session control. The authors conclude with primers on real-world development and debugging, followed by ten start-to-finish case studies, from authentication to content management, personalized PDFs to web services and Web 2.0 apps.

Laura Thomson, Webtools Engineering Manager at Mozilla Corporation, leads development projects for building robust, scalable, maintainable web apps and architectures. She was principal at OmniTI and Tangled Web Design, and instructor for RMIT University.

Luke Welling, a leading web/open source consultant and trainer, speaks regularly at events including ZendCon, MySQLUC, PHPCon, and OSDC. He has worked for Silicon Valley social startup PandaWhale; Message Systems; Internet consultancy OmniTI; web analytics leader Hitwise.com; database vendor MySQL AB, and as an independent consultant.

PHP and MySQL Web Development, 5th Edition

Introduction

Part I Using PHP
1 PHP Crash Course
2 Storing and Retrieving Data
3 Using Arrays
4 String Manipulation and Regular Expressions
5 Reusing Code and Writing Functions
6 Object-Oriented PHP
7 Error and Exception Handling

Part II Using MySQL
8 Designing Your Web Database
9 Creating Your Web Database
10 Working with Your MySQL Database
11 Accessing Your MySQL Database from the Web with PHP
12 Advanced MySQL Administration
13 Advanced MySQL Programming

Part III E-commerce and Security
14 Running an E-commerce Site
15 E-commerce Security Issues
16 Web Application Security
17 Implementing Authentication with PHP and MySQL
18 Implementing Secure Transactions with PHP and MySQL

Part IV Advanced PHP Techniques
19 Interacting with the File System and the Server
20 Using Network and Protocol Functions
21 Managing the Date and Time
22 Generating Images
23 Using Session Control in PHP
24 Other Useful Features

Part V Building Practical PHP and MySQL Projects
25 Using PHP and MySQL for Large Projects
26 Debugging
27 Building User Authentication and Personalization: Social Bookmarking
28 Building a Shopping Cart
29 Building a Content Management System
30 Building a Web-Based Email Service
31 Building a Mailing List Manager
32 Building Web Forums
33 Generating Personalized Documents in Portable Document Format (PDF)
34 Connecting to Web Services with XML and SOAP
35 Building Web 2.0 Applications with Ajax

Part VI: Appendices
A Installing PHP5 and MySQL5
B Web Resources