Synopses & Reviews
If PHP5 and MySQL can do it, you can do it too...
PHP and MySQL form a powerful team, and if you have some fluency with HTML, this comprehensive guide will have you creating database-backed, PHP-driven Web sites in no time. Along with the new features of PHP5, youll learn to install, administer, and use MySQL 4.0 in database design. From getting started with PHP to connecting HTML Web pages to MySQL, PostgreSQL, and Oracle®, youll find what you need to take advantage of all this dynamic duo has to offer.
Inside, youll find complete coverage of PHP5 and MySQL
- Resolve common "gotchas" with a series of symptom/diagnosis/fix patterns
- Discover how to use PHP with Oracle and PostgreSQL as well as MySQL
- Use PHP to embed code fragments in normal HTML pages
- Find out how the new PHP5 parser supports genuine exception handling and a more complete object model
- Understand Zend Engine 2 and the new object model, with support for private/protected members, abstract classes, and interfaces
- Install MySQL and learn to administer it successfully, including backups, replication, and recovery
- Write MySQL-backed PHP applications
- Learn from case studies how to design and implement a Weblog, a user identification system, and other applications
The most comprehensive book on the market with extensive code examples.
Readers will be able to learn about all the basics of PHP 5, a popular open-source Web-scripting language, and MySQL 4.012, the most popular open-source database engine. This book clearly shows them why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL. The authors take advantage of their own extensive Web experience to provide case studies of how and where to use PHP, along with advanced topics such as exceptions and error handling, debugging, PEAR, security, HTTP, cookies, and OOP.
- This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engine
- Explores why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL
- Offers an extensive tutorial for developing applications with PHP and MySQL
- Includes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functions
- The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience
About the Author
has written software to recommend neckties, answer questions about space stations, pick value stocks, and make simulated breakfast. He has an M.S. in Computer Science from the University of Chicago, where he taught several programming classes. He is now an engineering manager in the Web search group at Yahoo!.
Joyce Park has an M.A. in history from the University of Chicago, and has worked for several Silicon Valley startups including Epinions, KnowNow, and Friendster. She is a co-lead of the Mod-pubsub Open Source project.
Clark Morgan is a Web application and educational software developer with more than five years’ experience writing PHP. He works primarily with medical clients and related businesses. Originally from Boston, he now lives and works in Jacksonville, Florida, with his wife and two children. Clark spends entirely too much of his free time reading other people’s computer books.
Table of Contents
Part I: PHP: The Basics.
Chapter 1: Why PHP and MySQL?
Chapter 2: Server-Side Web Scripting.
Chapter 3: Getting Started with PHP.
Chapter 4: Adding PHP to HTML.
Chapter 5: Syntax and Variables.
Chapter 6: Control and Functions.
Chapter 7: Passing Information between Pages.
Chapter 8: Strings.
Chapter 9: Arrays and Array Functions.
Chapter 10: Numbers.
Chapter 11: Basic PHP Gotchas.
Part II: PHP and MySQL.
Chapter 12: Choosing a Database for PHP.
Chapter 13: SQL Tutorial.
Chapter 14: MySQL Database Administration.
Chapter 15: PHP/MySQL Functions.
Chapter 16: Displaying Queries in Tables.
Chapter 17: Building Forms from Queries.
Chapter 18: PHP/MySQL Efficiency.
Chapter 19: PHP/MySQL Gotchas.
Part III: Advanced Features and Techniques.
Chapter 20: Object-Oriented Programming with PHP.
Chapter 21: Advanced Array Functions.
Chapter 22: String and Regular Expression Functions.
Chapter 23: Filesystem and System Functions.
Chapter 24: Sessions, Cookies, and HTTP.
Chapter 25: Types and Type Conversions.
Chapter 26: Advanced Use of Functions.
Chapter 27: Mathematics.
Chapter 28: PEAR.
Chapter 29: Security.
Chapter 30: Configuration.
Chapter 31: Exceptions and Error Handling.
Chapter 32: Debugging.
Chapter 33: Style.
Part IV: Connections.
Chapter 34: PostgreSQL.
Chapter 35: Oracle.
Chapter 36: PEAR Database Functions.
Chapter 37: E-mail.
Chapter 39: PHP and Java.
Chapter 40: PHP and XML.
Chapter 41: Web Services.
Chapter 42: Graphics.
Part V: Case Studies.
Chapter 43: Weblogs.
Chapter 44: User Authentication.
Chapter 45: A User-Rating System.
Chapter 46: A Trivia Game.
Chapter 47: Converting Static HTML Sites.
Chapter 48: Data Visualization with Venn Diagrams.
Appendix A: PHP for C Programmers.
Appendix B: PHP for Perl Hackers.
Appendix C: PHP for HTML Coders.
Appendix D: PHP Resources.