9780672325250

"PHP and MySQL Web Development" teaches the reader to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the first edition, this best-selling book has been updated to reflect the rapidly changing landscape of MySQL and PHP.

The book teaches the reader to integrate and implement these technologies by following real-world examples and working sample projects, and also covers related technologies needed to build a commercial Web site, such as SSL, shopping carts, and payment systems.

The second edition includes new coverage of how to work with XML in developing a PHP and MySQL site, and how to draw on the valuable resources of the PEAR repository of code and extensions.

Luke Welling and Laura Thomson are partners in Tangled Web Design. They are lecturers in Web programming, software engineering, and e-commerce at RMIT University in Melbourne, Australia, and are frequent speakers at leading open source conferences around the world, such as PHPCon, LinuxTag, and the O'Reilly Open Source Convention

Introduction

1

(11)

I Using PHP

PHP Crash Course

11

(40)

Storing and Retrieving Data

51

(20)

Using Arrays

71

(24)

String Manipulation and Regular Expressions

95

(22)

Reusing Code and Writing Functions

117

(28)

Object-Oriented PHP

145

(24)

II Using MySQL

Designing Your Web Database

169

(12)

Creating Your Web Database

181

(22)

Working with Your MySQL Database

203

(20)

Accessing Your MySQL Database from the Web with PHP

223

(18)

Advanced MySQL

241

(20)

III E-commerce and Security

Running an E-commerce Site

261

(12)

E-commerce Security Issues

273

(20)

Implementing Authentication with PHP and MySQL

293

(22)

Implementing Secure Transactions with PHP and MySQL

315

(22)

IV Advanced PHP Techniques

Interacting with the File System and the Server

337

(20)

Using Network and Protocol Functions

357

(22)

Managing the Date and Time

379

(8)

Generating Images

387

(26)

Using Session Control in PHP

413

(16)

Other Useful Features

429

(10)

V Building Practical PHP and MySQL Projects

Using PHP and MySQL for Large Projects

439

(16)

Debugging

455

(18)

Building User Authentication and Personalization

473

(38)

Building a Shopping Cart

511

(44)

Building a Content Management System

555

(30)

Building a Web-Based Email Service

585

(36)

Building a Mailing List Manager

621

(54)

Building Web Forums

675

(30)

Generating Personalized Documents in Portable Document Format (PDF)

705

(34)

Connecting to Web Services with XML and SOAP

739

(78)

VI Appendixes

A Installing PHP and MySQL

789

(24)

B Web Resources

813

(4)

Index

817

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

PHP and MySQL Web Development

PHP and MySQL Web Development

067232525X

Summary

Author Biography

Table of Contents

Supplemental Materials