Learning PHP and MySQL: Step-by-Step Guide to Creating Database-Driven Web Sites, 2/e (Paperback)

Michele E. Davis, Jon A. Phillips

  • 出版商: O'Reilly
  • 出版日期: 2007-08-27
  • 售價: $1,100
  • 貴賓價: 9.5$1,045
  • 語言: 英文
  • 頁數: 432
  • 裝訂: Paperback
  • ISBN: 0596514018
  • ISBN-13: 9780596514013
  • 相關分類: MySQLPHP 程式語言SQL






PHP and MySQL are quickly becoming the de facto standard for rapid development of dynamic, database-driven web sites. This book is perfect for newcomers to programming as well as hobbyists who are intimidated by harder-to-follow books. 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.

If you come from a web design or graphics design background and know your way around HTML, Learning PHP & MySQL is the book you've been looking for. The content includes:
  • PHP basics such as strings and arrays, and pattern matching
  • A detailed discussion of the variances in different PHP versions
  • MySQL data fundamentals like tables and statements
  • Information on SQL data access for language
  • A new chapter on XHTML
  • Error handling, security, HTTP authentication, and more
Learning PHP & MySQL explains everything from fundamental concepts to the nuts and bolts of performing specific tasks. As part of O'Reilly's bestselling Learning series, the book is an easy-to-use resource designed specifically for beginners. It's a launching pad for future learning, providing you with a solid foundation for more advanced development.

Table of Contents


1. Dynamic Content and the Web

     HTTP and the Internet

     PHP and MySQL's Place in Web Development

     The Components of a PHP Application

     Integrating Many Sources of Information

     Requesting Data from a Web Page

2. Installation

     Developing Locally

     Working Remotely

3. Exploring PHP

     PHP and HTML Text

     Coding Building Blocks

4. PHP Decision-Making


     Operator Concepts



5. Functions

     Calling Functions

     Defining Functions

     Object-Oriented Programming

6. Arrays

     Array Fundamentals

7. Working with MySQL

     MySQL Database

     Managing the Database

     Using phpMyAdmin

     Database Concepts

     Structured Query Language

8. Database Best Practices

     Database Design

     Backing Up and Restoring Data

     Advanced SQL

9. Getting PHP to Talk to MySQL

     The Process

     Querying the Database with PHP Functions

     Using PEAR

10. Working with Forms

     Building a Form


11. Practical PHP

     String Functions

     Date and Time Functions

     File Manipulation

     Calling System Calls


     Why XHTML?

     XHTML and XML Namespaces

     XHTML Versions

     Generating XHTML with PHP

13. Modifying MySQL Objects and PHP Data

     Changing Database Objects from PHP

     Manipulating Table Data

     Displaying Results with Embedded Links

     Presenting a Form to Add and Process in One File

     Updating Data

     Deleting Data

     Performing a Subquery

14. Cookies, Sessions, and Access Control


     PHP and HTTP Authentication


     Using Auth_HTTP to Authenticate

15. Security

     Session Security

16. Validation and Error Handling

     Validating User Input with JavaScript

     Pattern Matching

     Redisplaying a Form After PHP Validation Fails

17. Sample Application

     Configuration File

     Page Framework


     Displaying a Postings Summary

     Displaying a Posting and Its Comments

     Adding and Changing Posts

     Adding and Changing Comments

18. Finishing Your Journey

     PHP Coding Standards





     Finding Help on the Web

Appendix. Solutions to Chapter Questions