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 FunctionsFunctions 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. IterationExtended 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 ForPHP-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