Learning PHP & MySQL: Step-by-Step Guide to Creating Database-Driven Web Sites (Paperback)

Preface; Audience; Assumptions This Book Makes; Organization of This Book; Supporting Books; Conventions Used in This Book; Using Code Examples; How to Contact Us; Safari® Books Online; Acknowledgments; Chapter 1: Dynamic Content and the Web; 1.1 HTTP and the Internet; 1.2 PHP and MySQL's Place in Web Development; 1.3 The Components of a PHP Application; 1.4 Integrating Many Sources of Information; 1.5 Requesting Data from a Web Page; 1.6 Questions; Chapter 2: Installation; 2.1 Developing Locally; 2.2 Working Remotely; 2.3 Questions; Chapter 3: Exploring PHP; 3.1 PHP and HTML Text; 3.2 Coding Building Blocks; 3.3 Questions; Chapter 4: PHP Decision-Making; 4.1 Expressions; 4.2 Operator Concepts; 4.3 Conditionals; 4.4 Looping; 4.5 Questions; Chapter 5: Functions; 5.1 Calling Functions; 5.2 Defining Functions; 5.3 Object-Oriented Programming; 5.4 Questions; Chapter 6: Arrays; 6.1 Array Fundamentals; 6.2 Questions; Chapter 7: Working with MySQL; 7.1 MySQL Database; 7.2 Managing the Database; 7.3 Using phpMyAdmin; 7.4 Database Concepts; 7.5 Structured Query Language; 7.6 Questions; Chapter 8: Database Best Practices; 8.1 Database Design; 8.2 Backing Up and Restoring Data; 8.3 Advanced SQL; 8.4 Questions; Chapter 9: Getting PHP to Talk to MySQL; 9.1 The Process; 9.2 Querying the Database with PHP Functions; 9.3 Using PEAR; 9.4 Questions; Chapter 10: Working with Forms; 10.1 Building a Form; 10.2 Templates; 10.3 Questions; Chapter 11: Practical PHP; 11.1 String Functions; 11.2 Date and Time Functions; 11.3 File Manipulation; 11.4 Calling System Calls; 11.5 Questions; Chapter 12: XHTML; 12.1 Why XHTML?; 12.2 XHTML and XML Namespaces; 12.3 XHTML Versions; 12.4 Generating XHTML with PHP; 12.5 Questions; Chapter 13: Modifying MySQL Objects and PHP Data; 13.1 Changing Database Objects from PHP; 13.2 Manipulating Table Data; 13.3 Displaying Results with Embedded Links; 13.4 Presenting a Form to Add and Process in One File; 13.5 Updating Data; 13.6 Deleting Data; 13.7 Performing a Subquery; 13.8 Questions; Chapter 14: Cookies, Sessions, and Access Control; 14.1 Cookies; 14.2 PHP and HTTP Authentication; 14.3 Sessions; 14.4 Using Auth_HTTP to Authenticate; 14.5 Questions; Chapter 15: Security; 15.1 ; 15.2 Session Security; 15.3 Questions; Chapter 16: Validation and Error Handling; 16.1 Validating User Input with JavaScript; 16.2 Pattern Matching; 16.3 Redisplaying a Form After PHP Validation Fails; 16.4 Questions; Chapter 17: Sample Application; 17.1 Configuration File; 17.2 Page Framework; 17.3 Database; 17.4 Displaying a Postings Summary; 17.5 Displaying a Posting and Its Comments; 17.6 Adding and Changing Posts; 17.7 Adding and Changing Comments; 17.8 Questions; Chapter 18: Finishing Your Journey; 18.1 PHP Coding Standards; 18.2 PEAR; 18.3 Frameworks; 18.4 Ajax; 18.5 Wikis; 18.6 Finding Help on the Web; 18.7 Questions; Solutions to Chapter Questions; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; Colophon;