Buying Options
Learning PHP & MySQL, Second Edition
Ebook $23.99
Add to Cart
Safari Books Online
Add to Cart
What is this?

Product Editions

  1. Learning PHP & MySQL, Second Edition - August 2007
  2. Learning PHP and MySQL - June 2006
Description
PHP and MySQL are quickly becoming the de facto standard for rapid development of dynamic, database-driven web sites. With concepts explained in plain English, the new edition starts with the basics of the PHP language, and explains how to work with MySQL, the popular open source database. You then learn how to put the two together to generate dynamic content.
Full Description
Table of Contents
  1. Chapter 1 Dynamic Content and the Web

    1. HTTP and the Internet

    2. PHP and MySQL's Place in Web Development

    3. The Components of a PHP Application

    4. Integrating Many Sources of Information

    5. Requesting Data from a Web Page

    6. Questions

  2. Chapter 2 Installation

    1. Developing Locally

    2. Working Remotely

    3. Questions

  3. Chapter 3 Exploring PHP

    1. PHP and HTML Text

    2. Coding Building Blocks

    3. Questions

  4. Chapter 4 PHP Decision-Making

    1. Expressions

    2. Operator Concepts

    3. Conditionals

    4. Looping

    5. Questions

  5. Chapter 5 Functions

    1. Calling Functions

    2. Defining Functions

    3. Object-Oriented Programming

    4. Questions

  6. Chapter 6 Arrays

    1. Array Fundamentals

    2. Questions

  7. Chapter 7 Working with MySQL

    1. MySQL Database

    2. Managing the Database

    3. Using phpMyAdmin

    4. Database Concepts

    5. Structured Query Language

    6. Questions

  8. Chapter 8 Database Best Practices

    1. Database Design

    2. Backing Up and Restoring Data

    3. Advanced SQL

    4. Questions

  9. Chapter 9 Getting PHP to Talk to MySQL

    1. The Process

    2. Querying the Database with PHP Functions

    3. Using PEAR

    4. Questions

  10. Chapter 10 Working with Forms

    1. Building a Form

    2. Templates

    3. Questions

  11. Chapter 11 Practical PHP

    1. String Functions

    2. Date and Time Functions

    3. File Manipulation

    4. Calling System Calls

    5. Questions

  12. Chapter 12 XHTML

    1. Why XHTML?

    2. XHTML and XML Namespaces

    3. XHTML Versions

    4. Generating XHTML with PHP

    5. Questions

  13. Chapter 13 Modifying MySQL Objects and PHP Data

    1. Changing Database Objects from PHP

    2. Manipulating Table Data

    3. Displaying Results with Embedded Links

    4. Presenting a Form to Add and Process in One File

    5. Updating Data

    6. Deleting Data

    7. Performing a Subquery

    8. Questions

  14. Chapter 14 Cookies, Sessions, and Access Control

    1. Cookies

    2. PHP and HTTP Authentication

    3. Sessions

    4. Using Auth_HTTP to Authenticate

    5. Questions

  15. Chapter 15 Security

    1. Session Security

    2. Questions

  16. Chapter 16 Validation and Error Handling

    1. Validating User Input with JavaScript

    2. Pattern Matching

    3. Redisplaying a Form After PHP Validation Fails

    4. Questions

  17. Chapter 17 Sample Application

    1. Configuration File

    2. Page Framework

    3. Database

    4. Displaying a Postings Summary

    5. Displaying a Posting and Its Comments

    6. Adding and Changing Posts

    7. Adding and Changing Comments

    8. Questions

  18. Chapter 18 Finishing Your Journey

    1. PHP Coding Standards

    2. PEAR

    3. Frameworks

    4. Ajax

    5. Wikis

    6. Finding Help on the Web

    7. Questions

  1. Appendix Solutions to Chapter Questions

  2. Colophon

View Full Table of Contents
Product Details
Title:
Learning PHP & MySQL, Second Edition
By:
Michele E. Davis, Jon A. Phillips
Publisher:
O'Reilly Media
Formats:
  • Print
  • Ebook
  • Safari Books Online
Print Release:
August 2007
Ebook Release:
February 2009
Pages:
432
Print ISBN:
978-0-596-51401-3
| ISBN 10:
0-596-51401-8
Ebook ISBN:
978-0-596-10287-6
| ISBN 10:
0-596-10287-9
Customer Reviews
About the Authors
  1. Michele E. Davis

    Michele E. Davis has co-authored and authored over 11 books and has been a career writer since she sold her first poem to CRICKET magazine in second grade. She has an MFA in Writing from Hamline University and is always trying to improve her writing technique. Someday it will be perfect.

    View Michele E. Davis's full profile page.

  2. Jon A. Phillips

    Jon A. Phillips is a software engineer who loves Open Source technology. He's been working with web development and databases for over 12 years and is always exploring new technology. Additionally, he co-authored a Dreamweaver for Dummies book that came out July 2006.

    View Jon A. Phillips's full profile page.

  • Book cover of Learning PHP & MySQL