PHP5 and MySQLBible -- Preface -- Acknowledgments -- Contents at a Glance -- Contents -- Preface -- What Is PHP? -- Why PHP? -- What's New in This Edition? -- Whom This Book Is For -- This Book Is Not the Manual -- How the Book Is Organized -- Conventions Used in This Book -- What the Icons Mean -- The Web Site and Sample Code -- Part I: PHP: The Basics -- Chapter 1: Why PHP and MySQL? -- What Is PHP? -- What Is MySQL? -- The History of PHP -- The History of MySQL -- Reasons to Love PHP and MySQL -- Summary -- Chapter 2: Server-Side Web Scripting -- Static HTML -- Client-Side Technologies -- Server-Side Scripting -- What Is Server-Side Scripting Good for? -- Summary -- Chapter 3: Getting Started with PHP -- Hosting versus DIY -- Installing PHP -- Summary -- Chapter 4: Adding PHP to HTML -- Your HTML Is Already PHP-Compliant! -- Escaping from HTML -- Summary -- Chapter 5: Syntax and Variables -- PHP Is Forgiving -- HTML Is Not PHP -- PHP's Syntax Is C-Like -- Comments -- Variables -- Types in PHP: Don't Worry, Be Happy -- Type Summary -- The Simple Types -- Output -- Summary -- Chapter 6: Control and Functions -- Boolean Expressions -- Branching -- Looping -- Alternate Control Syntaxes -- Terminating Execution -- Using Functions -- Function Documentation -- Defining Your Own Functions -- Functions and Variable Scope -- Function Scope -- Summary -- Chapter 7: Passing Information between Pages -- HTTP Is Stateless -- GET Arguments -- A Better Use for GET-Style URLs -- POST Arguments -- Formatting Form Variables -- PHP Superglobal Arrays -- Extended Example: An Exercise Calculator -- Summary -- Chapter 8: Strings -- Strings in PHP -- String Functions -- Extended Example: An Exercise Calculator -- Summary -- Chapter 9: Arrays and Array Functions -- The Uses of Arrays -- What Are PHP Arrays? -- Creating Arrays -- Retrieving Values.

Multidimensional Arrays -- Inspecting Arrays -- Deleting from Arrays -- Iteration -- Extended Example: An Exercise Calculator -- Summary -- Chapter 10: Numbers -- Numerical Types -- Mathematical Operators -- Simple Mathematical Functions -- Randomness -- Extended Example: An Exercise Calculator -- Summary -- Chapter 11: Basic PHP Gotchas -- Installation-Related Problems -- Rendering Problems -- Failures to Load Page -- Parse Errors -- File Permissions -- Missing Includes -- Unbound Variables -- Overwritten Variables -- Function Problems -- Math Problems -- Time-outs -- Summary -- Part II: PHP and MySQL -- Chapter 12: Choosing a Database for PHP -- What Is a Database? -- Why a Database? -- Choosing a Database -- Advanced Features to Look For -- PHP-Supported Databases -- Database Abstraction ( or Not) -- Our Focus: MySQL -- Summary -- Chapter 13: SQL Tutorial -- Relational Databases and SQL -- SQL Standards -- The Workhorses of SQL -- Database Design -- Privileges and Security -- Summary -- Chapter 14: MySQL Database Administration -- MySQL Licensing -- Installing MySQL: Moving to Version 4 -- MySQL User Administration -- PHPMyAdmin -- Backups -- Replication -- Recovery -- Summary -- Chapter 15: PHP/MySQL Functions -- Connecting to MySQL -- Making MySQL Queries -- Fetching Data Sets -- Getting Data about Data -- Multiple Connections -- Building in Error Checking -- Creating MySQL Databases with PHP -- MySQL Functions -- Summary -- Chapter 16: Displaying Queries in Tables -- HTML Tables and Database Tables -- Complex Mappings -- Creating the Sample Tables -- Summary -- Chapter 17: Building Forms from Queries -- HTML Forms -- Basic Form Submission to a Database -- Self-Submission -- Editing Data with an HTML Form -- Summary -- Chapter 18: PHP/MySQL Efficiency -- Connections - Reduce, Reuse, Recycle -- Indexing and Table Design.

Making the Database Work for You -- Summary -- Chapter 19: PHP/MySQL Gotchas -- No Connection -- Problems with Privileges -- Unescaped Quotes -- Broken SQL Statements -- Too Little Data, Too Much Data -- Specific SQL Functions -- Debugging and Sanity Checking -- Summary -- Part III: Advanced Features and Techniques -- Chapter 20: Object-Oriented Programming with PHP -- What Is Object-Oriented Programming? -- Basic PHP Constructs for OOP -- Advanced OOP Features -- Introspection Functions -- Extended Example: HTML Forms -- Gotchas and Troubleshooting -- OOP Style in PHP -- Summary -- Chapter 21: Advanced Array Functions -- Transformations of Arrays -- Stacks and Queues -- Translating between Variables and Arrays -- Sorting -- Printing Functions for Visualizing Arrays -- Summary -- Chapter 22: String and Regular Expression Functions -- Tokenizing and Parsing Functions -- Why Regular Expressions? -- Perl-Compatible Regular Expressions -- Example: A Simple Link-Scraper -- Advanced String Functions -- Summary -- Chapter 23: Filesystem and System Functions -- Understanding PHP File Permissions -- File Reading and Writing Functions -- Filesystem and Directory Functions -- Network Functions -- Date and Time Functions -- Calendar Conversion Functions -- Summary -- Chapter 24: Sessions, Cookies, and HTTP -- What's a Session? -- Home-Grown Alternatives -- How Sessions Work in PHP -- Sample Session Code -- Session Functions -- Configuration Issues -- Cookies -- Sending HTTP Headers -- Gotchas and Troubleshooting -- Summary -- Chapter 25: Types and Type Conversions -- Type Round-up -- Resources -- Type Testing -- Assignment and Coercion -- Summary -- Chapter 26: Advanced Use of Functions -- Variable Numbers of Arguments -- Call-by-Value -- Call-by-Reference -- Variable Function Names -- An Extended Example -- Summary -- Chapter 27: Mathematics.

Mathematical Constants -- Tests on Numbers -- Base Conversion -- Exponents and Logarithms -- Trigonometry -- Arbitrary Precision ( BC) -- Summary -- Chapter 28: PEAR -- What Is PEAR? -- The PEAR Package System -- PHP Foundation Classes ( PFC) -- PHP Extension Code Library ( PECL) -- The PEAR Coding Style -- Summary -- Chapter 29: Security -- Possible Attacks -- Register Globals -- File Uploads -- Encryption -- FYI: Security Web Sites -- Summary -- Chapter 30: Configuration -- Viewing Environment Variables -- Understanding PHP Configuration -- Improving PHP Performance -- Summary -- Chapter 31: Exceptions and Error Handling -- Error Handling in PHP5 -- Other Methods of Error Handling -- Logging and Debugging -- Summary -- Chapter 32: Debugging -- General Troubleshooting Strategies -- A Menagerie of Bugs -- Using Web Server Logs -- PHP Error Reporting and Logging -- Error-Reporting Functions -- Visual Debugging Tools -- Summary -- Chapter 33: Style -- The Uses of Style -- Readability -- Maintainability -- Robustness -- Efficiency and Conciseness -- HTML Mode or PHP Mode? -- Separating Code from Design -- Summary -- Part IV: Connections -- Chapter 34: PostgreSQL -- Why Choose PostgreSQL? -- Why Object-Relational Anyway? -- Installing PostgreSQL -- Down to Real Work -- PHP and PostgreSQL -- The Cartoons Database -- Summary -- Chapter 35: Oracle -- When Do You Need Oracle? -- Oracle and Web Architecture -- Using OCI8 Functions -- Project: Point Editor -- Project: Batch Editor -- Summary -- Chapter 36: PEAR Database Functions -- The Debatable Virtue of Database Independence -- Pear DB Concepts -- PEAR DB Functions -- Summary -- Chapter 37: E-mail -- Understanding E-mail -- Receiving E-mail with PHP -- Sending E-mail with PHP -- More Fun with PHP E-mail -- E-mail Gotchas -- Summary -- Chapter 38: PHP and JavaScript -- Outputting JavaScript with PHP.

PHP as a Backup for JavaScript -- Static Versus Dynamic JavaScript -- Summary -- Chapter 39: PHP and Java -- PHP for Java programmers -- Integrating PHP and Java -- Summary -- Chapter 40: PHP and XML -- What Is XML? -- Working with XML -- Documents and DTDs -- SAX versus DOM -- DOM -- SAX -- SimpleXML API -- A Sample XML Application -- Gotchas and Troubleshooting -- Summary -- Chapter 41: Web Services -- The End of Programming as We Know It -- REST, XML-RPC, SOAP, . NET -- Current Issues with Web Services -- Project: A REST Client -- Project: A SOAP Server and Client -- Summary -- Chapter 42: Graphics -- Your Options -- HTML Graphics -- Creating images using gd -- Gotchas and Troubleshooting -- Summary -- Part V: Case Studies -- Chapter 43: Weblogs -- Why Weblogs? -- The Simplest Weblog -- Adding an HTML Editing Tool -- Adding Database Connectivity -- Changes and Additions -- Summary -- Chapter 44: User Authentication -- Designing a User-Authentication System -- Avoiding Common Security Issues -- Registration -- Login/Logout -- User Tools -- Administrator Tools -- Summary -- Chapter 45: A User-Rating System -- Initial Design -- Collecting Votes -- Aggregating Results -- Extensions and Alternatives -- Summary -- Chapter 46: A Trivia Game -- Concepts Used in This Chapter -- The Game -- The Code -- General Design Considerations -- Summary -- Chapter 47: Converting Static HTML Sites -- Planning the Big Upgrade -- Redesigning the User Interface -- Planning a New Database Schema -- Dumping Data into a Database -- Templating -- Performance and Caching -- Summary -- Chapter 48: Data Visualization with Venn Diagrams -- Scaled Venn Diagrams -- Outline of the Code -- Necessary Trigonometry -- Planning the Display -- Display -- Visualizing a Database -- Extensions -- Summary -- Appendix A: PHP for C Programmers -- Similarities -- Differences -- Guide to the Book.

A Bonus: Just Look at the Code!.