PHP和MySQL正在迅速成为开发数据库驱动的动态网站的标准方法。对于程序开发新手，或者被那些令人费解的编程书籍弄得心烦意乱的人而言，《学习PHP & MySQL》是将这对网络开发强劲组合的学习变得简单快速的完美方法。

本书新版不仅专注于PHP和MySQL,而且涉及用PHP和MySQL来编写动态网页的相关技术，包括Apache网络服务器、XHTML、HTTP及其他内容。你将通过特别设计的例子来使用MySQL并学习如何操作数据，同时也学习PHP编程语言的基础知识以便将数据整合到你的网站上。

《学习PHP & MySQL》第二版包括以下内容：PHP基础知识，例如数据类型、程序流程逻辑、变量、函数、数组和表格；在各种环境下安装PHP和MySQL的详细步骤；MySQL数据库基础，如表和查询语句；通过SQL操作数据库的简要解释；新加一章内容讲解XHTML如何与PHP和网站协同工作；安全和访问控制，同时包括一些常见安全陷阱；错误处理、HTTP身份验证和其他。

《学习PHP & MySQL》讲解了从基本概念到完成特定任务的实践技能等的各个要点，并使用示例应用程序来展示这些技术是如何一起工作共同构建高效快速网站的。如果你有网页或者图像设计的背景并且了解HTML,《学习PHP & MySQL》就是你开始创建动态网页所需要的书。

Preface

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

Expressions

Operator Concepts

Conditionals

Looping

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

Templates

11. Practical PHP

String Functions

Date and Time Functions

File Manipulation

Calling System Calls

12.  XHTML

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

Cookies

PHP and HTTP Authentication

Sessions

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

Database

Displaying a Postings Summary

Displaying a Posting and Its Comments

Adding and Changing Posts

Adding and Changing Comments

18. Finishing Yourlourney

PHP Coding Standards

PEAR

Frameworks

Ajax

Wikis

Finding Help on the Web

Appendix. Solutions to Chapter Questions

Index