2009年利用PHP与MySQL构建数据库驱动网站指南

需积分: 3 57 浏览量更新于2024-07-31 收藏 2.3MB PDF 举报

《利用PHP和MySQL构建数据库驱动网站（2009年第四版）》是由Kevin Yank编著的一本技术指南，该书于2009年7月由SitePoint Pty.Ltd.出版。本书主要针对希望在Web开发领域运用PHP（Hypertext Preprocessor）和MySQL数据库的读者，提供了一套详细的教程和实践步骤，帮助读者创建自己的动态网站。作者通过第4版更新了内容，确保信息的准确性和时效性，强调了版权保护，未经出版商许可，不得复制、存储或以任何形式传播书中的内容，除非用于批评性文章或评论引用。尽管书中提供的信息力求详尽，但作者和出版社不对由于执行书中指令或软件问题导致的直接或间接损害承担责任。《Build Your Own Database Driven Web Site Using PHP and MySQL》是一本适合初学者和有一定编程基础的Web开发者使用的实战教材，它不仅涵盖了PHP语言的基础知识，如变量、数据类型、条件语句和循环，还深入讲解了如何设计数据库结构、SQL查询、连接PHP与MySQL以及如何实现动态网页功能，如用户输入验证、数据处理和分页显示。书中可能包含以下章节内容： 1. **PHP基础知识**：介绍PHP语法、脚本编写环境设置和基本数据操作。 2. **MySQL入门**：讲解数据库的基本概念、表的设计、字段类型和SQL查询语句。 3. **连接PHP与MySQL**：演示如何在PHP中建立数据库连接，执行CRUD操作（Create, Read, Update, Delete）。 4. **安全与优化**：讨论防止SQL注入、密码加密以及提高性能的最佳实践。 5. **网站架构**：探讨如何组织代码结构，如模型-视图-控制器（MVC）模式。 6. **高级主题**：包括AJAX应用、会话管理、错误处理和数据库备份恢复。该书的特点是理论与实践相结合，提供了大量的实例和代码示例，让读者在学习过程中能快速上手并掌握构建数据库驱动网站的关键技能。无论是为了个人项目还是职业发展，这本书都是学习PHP和MySQL的宝贵资源。

Chapter 5: Relational Database Design

Although you'll have worked with a very simple sample database in the previous

chapters , most database driven web sites require the storage of more complex

forms of data than you'll have dealt with to this point. Far too many database

driven web site designs are abandoned midstream or are forced to start again

from the beginning, because of mistakes made early on during the design of the

database structure. In this critical chapter you'll learn the essential principles

of good database design, emphasizing the importance of data normalization. If

you're unsure what that means, then this is definitely an important chapter for

you to read!

Chapter 6: Structured PHP Programming

Techniques to better structure your code are useful in all but the simplest of

PHP projects. The PHP language offers many facilities to help you do this, and

in this chapter, I'll cover some of the simple techniques that exist to keep your

code manageable and maintainable. You'll learn to use include files to avoid

having to write the same code more than once when it's needed by many pages

of your site, and I'll show you how to write your own functions to extend the

built-in capabilities of PHP and to streamline the code that appears within your

scripts.

Chapter 7: A Content Management System

In many ways the climax of the book, this chapter is the big payoff for all you

frustrated site builders who are tired of updating hundreds of pages whenever

you need to make a change to a site's design. I'll walk you through the code for

a basic content management system that allows you to manage a database of

jokes, their categories, and their authors. A system like this can be used to

manage simple content on your web site; just a few modifications, and you'll

have a site administration system that will have your content providers submit-

ting content for publication on your site in no time—all without having to know

a shred of HTML!

Chapter 8: Content Formatting with Regular Expressions

Just because you're implementing a nice, easy tool to allow site administrators

to add content to your site without their knowing HTML, that content can still

contents of your database—tweaks that allow it to incorporate simple formatting

such as bold or italicized text, among other options.

Chapter 9: Cookies, Sessions, and Access Control

What are sessions, and how are they related to cookies, a long-suffering techno-

logy for preserving stored data on the Web? What makes persistent data so im-

portant in current ecommerce systems and other web applications? This chapter

answers all those questions by explaining how PHP supports both cookies and

sessions, and explores the link between the two. You'll then put these pieces

together to build a simple shopping cart system, as well as an access control

system for your web site.

Chapter 10: MySQL Administration

While MySQL is a good, simple database solution for those without the need

for many frills, it does have some complexities of its own that you'll need to

understand if you're going to rely on a MySQL database to store your content.

In this section, I'll teach you how to perform backups of, and manage access to,

your MySQL database. In addition to a couple of inside tricks (like what to do

if you forget your MySQL password), I'll explain how to repair a MySQL database

that has become damaged in a server crash.

Chapter 11: Advanced SQL Queries

In Chapter 5 we saw what was involved in modeling complex relationships

between pieces of information in a relational database like MySQL. Although

the theory was quite sound, putting these concepts into practice requires that

you learn a few more tricks of Structured Query Language. In this chapter, I'll

cover some of the more advanced features of this language to help you juggle

complex data like a pro.

Chapter 12: Binary Data

Some of the most interesting applications of database driven web design include

some juggling of binary files. Online file storage services are prime examples,

but even a system as simple as a personal photo gallery can benefit from storing

binary files (that is, pictures) in a database for retrieval and management on the

fly. In this chapter, I'll demonstrate how to speed up your web site by creating

N 4- O 4- N /-> O r\ -R-\ N NN NI /-] TRN O -RR-I N N T-\ NRTNN O 4- T>/-\/-T-I-I1<-IT> T N AI-TTI 1 r< N MNN "DT—T"D R\I OMIMNL T A7N 4-VI

剩余490页未读，继续阅读

shwang1a

粉丝: 1
资源: 5

2009年利用PHP与MySQL构建数据库驱动网站指南

Build Your Own Database-Driven Website Using PHP & MySQL--3rd Edition

Build Your Own Database Driven Web Site Using PHP & MySQL 4th.Edition

Build Your Own Database Driven Web Site Using PHP & MySQL 4th.Edition 源代码

Build Your Own Database Driven Web Site Using PHP MySQL 4Ed

Build Your Own Database-Driven Website Using PHP & MySQL

MySQL.and.Perl.for.the.Web

Practical PHP 7, MySQL 8, and MariaDB Website Databases, Second Edition

Learning PHP, MySQL & JavaScript, 4th Edition

Learning PHP, MySQL & [removed] With jQuery, CSS & HTML5 ER5

Python链接MySQL驱动包 mysqlclient-python-1.3.12.rar

最新资源