Learning PHP and MySQL

book cover
Learning PHP and MySQL
By Michele Davis, Jon Phillips
Publisher: O'Reilly
Pub Date: June 2006
Print ISBN-10: 0-596-10110-4
Print ISBN-13: 978-0-59-610110-7
Pages: 376

Table of Contents  | Index

The PHP scripting language and MySQL open-source database are quite
effective independently, but together they make a simply unbeatable
team. When working hand-in-hand, they serve as the standard for the
rapid development of dynamic, database-driven websites. This
combination is so popular, in fact, that it's attracting many
programming newbies who come from a web or graphic design background
and whose first language is HTML. If you fall into this ever-expanding
category, then this book is for you.

Learning PHP and MySQL starts with the very basics
of the PHP language, including strings and arrays, pattern matching and a detailed
discussion of the variances in different PHP versions. Next, it
explains how to work with MySQL, covering information on SQL data
access for language and data fundamentals like tables and statements.
Finally, after it's sure that you've mastered these separate concepts,
the book shows you how to put them together to
generate dynamic content. In the process, you'll also learn about error
handling, security, HTTP authentication and more.

If you're a hobbyist who is intimidated by thick, complex
computer books, then this guide definitely belongs on your shelf.
Learning PHP and MySQL explains everything--from
basic concepts to the nuts and bolts of performing specific tasks--in plain

Part of O'Reilly's bestselling "Learning" series, the book is an
easy-to-use resource designed specifically for newcomers. It's also a launching pad
for future learning, providing you with a solid foundation for more advanced development.

book cover
Learning PHP and MySQL
By Michele Davis, Jon Phillips
Publisher: O'Reilly
Pub Date: June 2006
Print ISBN-10: 0-596-10110-4
Print ISBN-13: 978-0-59-610110-7
Pages: 376

Table of Contents  | Index

        Chapter 1.  Dynamic Content and the Web
      Section 1.1.  PHP and MySQL's Place in Web Development
      Section 1.2.  The Components of a PHP Application
      Section 1.3.  Integrating Many Sources of Information
      Section 1.4.  Requesting Data from a Web Page
      Section 1.5.  Chapter 1 Questions
        Chapter 2.  Installation
      Section 2.1.  Developing Locally
      Section 2.2.  Working Remotely
      Section 2.3.  Chapter 2 Questions
        Chapter 3.  Exploring PHP
      Section 3.1.  PHP and HTML Text
      Section 3.2.  Coding Building Blocks
      Section 3.3.  Chapter 3 Questions
        Chapter 4.  PHP Decision Making
      Section 4.1.  Expressions
      Section 4.2.  Operator Concepts
      Section 4.3.  Conditionals
      Section 4.4.  Looping
      Section 4.5.  Chapter 4 Questions
        Chapter 5.  Functions
      Section 5.1.  Calling Functions
      Section 5.2.  Defining Functions
      Section 5.3.  Object-Oriented Programming
      Section 5.4.  Chapter 5 Questions
        Chapter 6.  Arrays
      Section 6.1.  Array Fundamentals
      Section 6.2.  Chapter 6 Questions
        Chapter 7.  Database Basics
      Section 7.1.  Database Design
      Section 7.2.  Structured Query Language
      Section 7.3.  Chapter 7 Questions
        Chapter 8.  Using MySQL
      Section 8.1.  MySQL Database
      Section 8.2.  Managing the Database
      Section 8.3.  Backing Up and Restoring Data
      Section 8.4.  Advanced SQL
      Section 8.5.  Chapter 8 Questions
        Chapter 9.  Getting PHP to Talk to MySQL
      Section 9.1.  The Process
      Section 9.2.  Querying the Database with PHP Functions
      Section 9.3.  Using PEAR
      Section 9.4.  Chapter 9 Questions
        Chapter 10.  Working with Forms
      Section 10.1.  Building a Form
      Section 10.2.  Templates
      Section 10.3.  Chapter 10 Questions
        Chapter 11.  Practical PHP
      Section 11.1.  String Functions
      Section 11.2.  Date and Time Functions
      Section 11.3.  File Manipulation
      Section 11.4.  Calling System Calls
      Section 11.5.  Chapter 11 Questions
        Chapter 12.  Modifying MySQL Objects and PHP Data
      Section 12.1.  Changing Database Objects from PHP
      Section 12.2.  Manipulating Table Data
      Section 12.3.  Displaying Results with Embedded Links
      Section 12.4.  Presenting a Form to Add and Process in One File
      Section 12.5.  Updating Data
      Section 12.6.  Deleting Data
      Section 12.7.  Performing a Subquery
      Section 12.8.  Chapter 12 Questions
        Chapter 13.  Cookies, Sessions, and Access Control
      Section 13.1.  Cookies
      Section 13.2.  PHP and HTTP Authentication
      Section 13.3.  Sessions
      Section 13.4.  Using Auth_HTTP to Authenticate
      Section 13.5.  Chapter 13 Questions
        Chapter 14.  Security
      Section 14.1. 
      Section 14.2.  Session Security
      Section 14.3.  Chapter 14 Questions
        Chapter 15.  Validation and Error Handling
      Section 15.1.  Validating User Input with JavaScript
      Section 15.2.  Pattern Matching
      Section 15.3.  Redisplaying a Form After PHP Validation Fails
      Section 15.4.  Chapter 15 Questions
        Chapter 16.  Sample Applications
      Section 16.1.  Building a Blog
      Section 16.2.  Chapter 16 Questions
        Chapter 17.  Finishing Your Journey
      Section 17.1.  Finding Help on the Web
      Section 17.2.  Web Sites
      Section 17.3.  Zend
      Section 17.4.  Lampshade
      Section 17.5.  Chapter 17 Questions
       Answers to Chapter Questions
      Section A.1.  Chapter 1
      Section A.2.  Chapter 2
      Section A.3.  Chapter 3
      Section A.4.  Chapter 4
      Section A.5.  Chapter 5
      Section A.6.  Chapter 6
      Section A.7.  Chapter 7
      Section A.8.  Chapter 8
      Section A.9.  Chapter 9
      Section A.10.  Chapter 10
      Section A.11.  Chapter 11
      Section A.12.  Chapter 12
      Section A.13.  Chapter 13
      Section A.14.  Chapter 14
      Section A.15.  Chapter 15
      Section A.16.  Chapter 16
      Section A.17.  Chapter 17
   About the Authors