Synopses & Reviews
Learn what it takes to get data-driven Web sites up and running using PHP 5 and MySQL
The popularity of using MySQL and PHP to create organized and efficient Web sites is growing at a steady pace. MySQL has proven itself to be fast, robust, and easy to use. It works well with PHP, and its perfect for Web applications for simple to robust sites. For many developers, PHP is the next obvious step from HTML due to the fact that it was written specifically for use on the Web, its cross-platform, and its relatively easy to understand and write. MySQL/PHP Database Applications, Second Edition, demonstrates Web-application development using MySQL and PHP by presenting multiple practical, ready-to-use examples ranging from a simple guestbook to a fully functional e-commerce site with a shopping cart. Other applications include a catalog, a content manager, a threaded discussion, and a problem-tracking system. Youll learn the essentials of working with MySQL and PHP so you can start building and customizing database applications for the Web in no time!
This edition offers updated coverage of MySQL 4.0 and an extensive look ahead into PHP 5. The example code was rewritten to run against the new PHP engine, and this edition explores its new object-oriented features, as well as improvements in XML processing, remote file access, and other areas. Containing advice on how to easily tweak and customize a site, this book:
- Provides a concise introduction to working with MySQL and PHP
- Includes complete applicationsproject management system and message board
- Delivers ready-to-use code for error handling, user and session management, and templating
- Helps create code with SOAP services
The CD-ROM contains the example code and applications from the book, as well as MySQL, PHP, and Apache.
Synopsis
- Demonstrates Web application development by presenting ten real, ready-to-use examples
- Samples start with a simple guess book and end with a fully-functional e-commerce site with a shopping cart
- New features include both MySQL 4.1 and PHP 4.2
- Latest edition contains new applications including log analysis and project tracking
- CD-ROM includes all the code and examples applications from the book in addition to MySQL, PHP, Apache, PHP classes, libraries, utilities, and other tools
Synopsis
* Demonstrates Web application development by presenting ten real, ready-to-use examples
* Samples start with a simple guess book and end with a fully-functional e-commerce site with a shopping cart
* New features include both MySQL 4.1 and PHP 4.2
* Latest edition contains new applications including log analysis and project tracking
* CD-ROM includes all the code and examples applications from the book in addition to MySQL, PHP, Apache, PHP classes, libraries, utilities, and other tools
About the Author
BRAD BULGER is a seasoned software developer who has worked for several companies that no longer exist and is now a member of The Madfish Group, where he builds Web sites.
JAY GREENSPAN is a New York—based writer, editor, and technical consultant. He is author of MySQL Weekend Crash Course® and runs Trans-City Productions, Inc., a firm that provides editorial services to high-tech companies.
DAVID WALL is a freelance technical consultant, lecturer, and writer operating through his consultancy David Wall Enterprises. He specializes in Linux/Apache/MySQL/PHP (LAMP) servers and in Voice over IP technologies from IBM and Cisco Systems.
Table of Contents
Preface.
Acknowledgments.
Introduction.
Part I: Working with MySQL.
Chapter 1 Database Design with MySQL.
Chapter 2 The Structured Query Language for Creating and Altering Tables.
Chapter 3 The Structured Query Language for Inserting, Editing, and Selecting Data.
Part II: Working with PHP.
Chapter 4 Getting Started with PHP—Variables.
Chapter 5 Control Structures.
Chapter 6 PHP’s Built-in Functions.
Chapter 7 Writing Organized and Readable Code.
Part III: Simple Applications.
Chapter 8 Guestbook 2003, the (Semi-)Bulletproof Guestbook.
Chapter 9 Survey.
Part IV: Not So Simple Applications.
Chapter 10 Threaded Discussion.
Chapter 11 Content-Management System.
Chapter 12 Catalog.
Chapter 13 Problem-Tracking System.
Chapter 14 Shopping Cart.
Chapter 15 XML Parsing.
Chapter 16 SOAP.
Chapter 17 Project Management.
Part V: Appendixes.
Appendix A: What’s on the CD-ROM.
Appendix B: HTML Forms.
Appendix C: Brief Guide to MySQL/PHP Installation and Configuration.
Appendix D: MySQL Utilities.
Appendix E: MySQL User Administration.
Appendix F: PHP Function Reference.
Appendix G: Regular Expressions Overview.
Appendix H: Helpful User-Defined Functions.
Appendix I: PHP and MySQL Resources.
Appendix J: MySQL Function Reference.
Index.
End-User License Agreement.