PHP and MySQL Web Development

by Welling, Luke; Thomson, Laura

• ISBN13: 9780672325250
• ISBN10: 067232525X
• Edition: 2nd
• Format: Paperback w/CD
• Copyright: 2003-01-01
• Publisher: Sams

Summary

"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.

Author Biography

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

Table of Contents

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