PHP & MySQL: The Missing Manual

by Brett McLaughlin

Overview

If you can build websites with CSS and JavaScript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, you’ll soon discover the power of server-side programming.

The important stuff you need to know:

• Get a running start. Write PHP scripts and create a web form right away.
• Learn the language. Get up to speed on PHP and SQL syntax quickly.
• Build a database. Use MySQL to store user information and other data.
• Make it dynamic. Create pages that change with each new viewing.
• Be ready for mistakes. Plan error messages to help direct users.
• Manage your content. Use the file system to access user data, including images and other binary files.
• Control operations. Create an administrative interface to oversee your site.

Product Details

ISBN-13:	9781449325572
Publisher:	O'Reilly Media, Incorporated
Publication date:	11/26/2012
Edition description:	Second Edition
Pages:	543
Product dimensions:	7.00(w) x 9.10(h) x 1.20(d)

About the Author

Brett McLaughlin is a bestselling and award-winning non-fiction author. His books on computer programming, home theater, and analysis and design have sold in excess of 100,000 copies. He has been writing, editing, and producing technical books for nearly a decade, and is as comfortable in front of a word processor as he is behind a guitar, chasing his two sons and his daughter around the house, or laughing at reruns of Arrested Development with his wife.



Brett spends most of his time these days on cognitive theory, codifying and expanding on the learning principles that shaped the Head First series into a bestselling phenomenon. He's curious about how humans best learn, why Star Wars was so formulaic and still so successful, and is adamant that a good video game is the most effective learning paradigm we have.

Table of Contents

• The Missing Credits
• Introduction
• Part 1: PHP and MySQL Basics
  • Chapter 1: PHP: What, Why, and Where?
  • Chapter 2: PHP Meets HTML
  • Chapter 3: PHP Syntax: Weird and Wonderful
  • Chapter 4: MySQL and SQL: Database and Language
• Part 2: Dynamic Web Pages
  • Chapter 5: Connecting PHP to MySQL
  • Chapter 6: Regular Expressions
  • Chapter 7: Generating Dynamic Web Pages
• Part 3: From Web Pages to Web Applications
  • Chapter 8: When Things Go Wrong (and They Will)
  • Chapter 9: Handling Images and Complexity
  • Chapter 10: Binary Objects and Image Loading
  • Chapter 11: Listing, Iterating, and Administrating
• Part 4: Security and the Real World
  • Chapter 12: Authentication and Authorization
  • Chapter 13: Cookies, Sign-Ins, and Ditching Crummy Pop-Ups
  • Chapter 14: Authorization and Sessions
• Part 5: Appendixes
  • Installing PHP on Windows Without WAMP
  • Installing MySQL Without MAMP or WAMP