Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


PHP and MySQL Web Development, Fourth Edition
The definitive guide to building database-drive Web applications with PHP and MySQL

PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.

PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.

This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.

The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.


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
28 Building a Shopping Cart
29 Building a Web-Based Email Service
30 Building a Mailing List Manager
31 Building Web Forums
32 Generating Personalized PDF Documents
33 Connecting to Web Services with XML and SOAP
34 Building Web 2.0 Applications with Ajax

Part VI: Appendixes
Appendix A: Installing PHP and MySQL
Appendix B: Web Resources

Subscriber Reviews

Average Rating: 4 out of 5 rating Based on 8 Ratings

"-Great Book" - by Aaron_D_R on 16-DEC-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Don't let the previous 2 reviews discourage you, It is an excelent book, do the research from and you will see it is ranked as the highest and most liked php book out their. At the time of this writing it has 230 some-odd reviews and a 4.5 star rating at amazon. Don't let me convince you as I've  only just finished 200 pages in the book and its been excelent, As no one should take a review from someone who hasn't fully read a book, which is why I'm referencing aswell. Give the book a shot!
Report as Inappropriate

"Find another tutorial" - by PHP/MYSQL-Bah! on 27-NOV-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I work as a network engineer for a local government and use perl and unix shell scripting daily. I turned to this book to help build web-driven utilities for my job. I have been very disappointed and frustrated by this 'work'. The code examples explain nothing and mostly don't work. I spent way too much time getting the first examples to work.

The coding doesn't lend itself to maintenance or seem to follow any 'best practices'. It's just not consistant or clear.

Did anyone proofread this?

Report as Inappropriate

"Learn PHP the hard way" - by Anonymous on 17-NOV-2009
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
...this is how it should be called. Instead of using WAMP, it asks to install each component separately. Examples dont work.
Report as Inappropriate

Table of Contents



The publisher has provided additional content related to this title.


These files have been provided by the publisher.