PHP & MySQL The Missing Manual - 英文原版PDF

需积分: 9 84 浏览量更新于2024-07-19 收藏 22.7MB PDF 举报

"PHP & MySQL The Missing Manual 是一本由Brett McLaughlin编写的英文原版无水印PDF，该书详细介绍了如何结合使用PHP和MySQL进行web开发。这本书可以在多个PDF阅读器上正常打开，并且可在美国亚马逊官网上找到更多详细信息。" 《PHP & MySQL The Missing Manual》是针对初学者和中级开发者的一本实用指南，它深入浅出地解释了如何使用PHP编程语言与MySQL数据库系统协同工作，构建动态、交互式的Web应用。这本书涵盖了从安装和配置环境，到编写复杂的查询和创建动态网页的所有基础知识。 PHP是一种广泛使用的服务器端脚本语言，尤其适合于Web开发，能够嵌入到HTML中，用于处理表单数据、生成动态内容等。MySQL则是一款高效、可靠的关系型数据库管理系统，常用于存储和管理网站的数据。这本书将帮助读者理解这两个工具的核心概念，包括： 1. **PHP基础**：介绍PHP的基本语法、变量、控制结构（如if-else、循环）、函数和数组的使用，以及如何在PHP中处理HTTP请求和响应。 2. **MySQL入门**：讲解如何安装和配置MySQL服务器，创建数据库和表，以及插入、更新和删除数据。书中还可能涉及SQL查询语言的基础，如SELECT语句、JOIN操作和聚合函数。 3. **连接PHP与MySQL**：介绍如何使用PHP连接到MySQL数据库，执行查询，处理结果集，以及实现安全的数据库操作，如防止SQL注入攻击。 4. **Web应用开发**：通过实例展示如何使用PHP和MySQL创建注册、登录系统，管理用户数据，以及构建动态内容生成的网页。可能还会涵盖错误处理和调试技巧。 5. **高级主题**：可能涵盖面向对象的PHP编程、会话管理、文件上传、邮件发送、缓存技术，以及性能优化策略。 6. **最佳实践**：书中可能包含关于代码组织、安全性、可维护性和性能提升的建议，以帮助读者遵循良好的编程习惯。 7. **实战项目**：提供一个或多个实际项目，让读者将所学知识应用于实践中，增强理解和应用能力。《PHP & MySQL The Missing Manual》通过清晰的示例和易于理解的解释，旨在填补官方文档和技术手册中的空白，使学习过程更加顺畅。无论你是刚开始接触PHP和MySQL，还是寻求对这两项技术更深入的理解，这本书都将是一份宝贵的参考资料。

PHP & MYSQL: THE MISSING MANUAL

XIV

WHAT IS

MYSQL?

JavaScript Is Loose, PHP Is…Less So

If you’ve written some JavaScript—and if you’re checking out this book, that’s prob-

ably the case—then you know that JavaScript lets you do just about anything you

want. You can occasionally leave out semicolons; you can use brackets, or not; you

can use the

var

keyword, or not. That sort of looseness is both great for getting

things working quickly, and at the same time, frustrating. It makes ﬁnding bugs tricky

at times, and working across browsers can be a nightmare.

PHP is not quite so loose as JavaScript, so it makes you learn a little more structure

and tighten up your understanding of what’s going on as your program is interpreted.

That’s a good thing, as it’ll end up making you tighten up your JavaScript skills, too.

And, perhaps best of all, PHP’s stodgy consistency makes it easier to learn. It gives

you ﬁrm rules to hang on to, rather than lots of “You can do this…or this…or this…”

So get ready. There’s lots to learn, but everything you learn gives you something

to build on. And PHP lets you know right away when there’s a problem. You won’t

need to pop open an Error Console or keep an eye out for Internet Explorer’s tiny

yellow warning triangle like you do with JavaScript.

PHP Is Interpreted

PHP code comes in the form of

scripts

, which are plain text ﬁles you write. The PHP

interpreter

is a piece of software on your web server that reads that ﬁle and makes

sense of it, giving the Web server HTML output and directions about where to go

next, or how to interpret a user’s form entry. Your text ﬁle is interpreted, one line at

a time, every time that ﬁle is accessed.

This scheme is dierent from languages like Java or C++, which are

compiled

. In

those languages, you write in text ﬁles, but then run a command that turns those

text ﬁles into something else: class ﬁles, binary ﬁles, pieces of unreadable code that

your computer uses.

The beauty of an interpreted language like PHP—and JavaScript, for that matter—is

that you write your code and go. You don’t need a bunch of tools or steps. You write

PHP. Test it out in the browser. Write some more. It’s fast, and that usually means

it’s pretty fun.

What Is MySQL?

MySQL is a database. It stores your information, your users’ information, and any-

thing else you want to stu into it. There’s actually a lot more nuance to MySQL—and

SQL, the language in which you’ll interact with MySQL (but better to save that for

Chapter 3—when you’ve got a little PHP and context under your belt).

For now, think of MySQL as a warehouse where you can store things to be looked

up later. Not only that, MySQL provides you a really fast little imp that runs around

ﬁnding all that stu you stuck in the warehouse whenever it’s needed. By the time

you’re through this this book, you’ll love that imp…er…MySQL. It’ll do work that you

could never do on your own, and it’ll do that work tirelessly and quickly.

INTRODUCTION

ABOUT THIS

BOOK

About This Book

PHP is a web-based language, not a program that comes in a box. And there are

literally tens (hundreds?) of thousands of websites that have bits of PHP instruction

on them. That’s great, right? Well, not so much. Those websites aren’t all current.

Some are full of bugs. Some have more information in the comment trails—scattered

amongst gripes, complaints, and lambasting from other programmers—as they do

in the main page. It’s no easy matter to ﬁnd what you’re looking for.

The purpose of this book, then, is to serve as the manual that should have been

included when you download PHP. It’s the missing PDF, if you will (or maybe the

missing eBook, if you’re a Kindle or Nook or iPad person). In this book’s pages, you’ll

ﬁnd step-by-step instructions for getting PHP running, writing your ﬁrst program…

and your second program…and eventually building a web application from scratch. In

addition, you’ll ﬁnd clear evaluations of the absolutely critical parts of PHP that you’ll

use every day, whether you’re building a personal weblog or a corporate intranet.

NOTE

This book periodically recommends

other

books, covering topics that are too specialized or tangential

for a manual about PHP and MySQL. Careful readers may notice that not every one of these titles is published

by Missing Manual parent company O’Reilly Media. If there’s a great book out there that doesn’t happen to be

published by O’Reilly, this book will still let you know about it.

PHP & MySQL: The Missing Manual

is designed to accommodate readers at every

technical level. The primary discussions are written for advanced-beginner or inter-

mediate Web authors and programmers. Hopefully, you’re comfortable with HTML

and CSS, and maybe even know a bit of JavaScript. But if you’re new to all this Web

stu, take heart: special boxes called “Up to Speed” provide the introductory infor-

mation you need to understand the topic at hand. If you’re an advanced user, on the

other hand, keep your eye out for similar boxes called “Power Users’ Clinic.” They

oer more technical tips, tricks, and shortcuts for the experienced computer fan.

Macintosh and Windows

PHP and MySQL work almost precisely the same in their Macintosh and Windows

versions. And even more importantly, you’ll do most of your work by uploading

your scripts and running your database code against a web server. That means that

your hosting provider gets to deal with operating system issues. You get to focus

on your code and information.

In the ﬁrst few chapters, you’ll get your system set up to code and deal with PHP

scripts. But you’ll soon forget about whether you’re on Mac or Windows. You’ll just

be writing code, the same way you write HTML and CSS.

FTP: It’s Critical

One piece of software you

won’t

forget you’re using is a good FTP program. Most

PHP programmers don’t sit on a remote server typing into a command-line editor

emacs

PHP & MYSQL: THE MISSING MANUAL

XVI

ABOUT THIS

BOOK

AUTHOR’S NOTE

Typing in a command-line editor is actually exactly how I work. But then, I’m a

dinosaur, a throwback to days when you had to watch commercials to see primetime TV, and you’d miss emails

because your pocket didn’t buzz every time your boss whisked you a command through the ether.

Today, for most of you, a good text editor and a good graphical FTP client are much better choices. Seriously, my

addiction owns me, and I so badly want to

:wq!

it.

Chapter 1 will point you at several great editors, and the fancier ones will have FTP

built right in. But a program like Cyberduck (

www.cyberduck.ch

) is great, too. You

can write a script, throw it online, and test it all with a few mouse clicks. So go ahead

and get that FTP program downloaded, conﬁgured for your web server, and ﬁred

up. You’re gonna need it.

About the Outline

PHP & MySQL: The Missing Manual

is divided into four parts, each containing several

chapters:

• Part 1: PHP and MySQL Basics. In the ﬁrst three chapters, you’ll install PHP,

get it running on your computer, write your ﬁrst few PHP programs, and learn

to do a few basic things like collect user information via a web form and work

with text. You’ll also install MySQL and get thoroughly acquainted with the

structure of a database.

• Part 2: Dynamic Web Pages. These are the chapters where you start to build

the basics of a solid web application. You’ll add a table in which you can store

users and their information, and get a grasp of how easily you can manipulate

text. From URLs and emails to Twitter handles, you’ll use regular expressions

and string handling to bend letters, numbers, and slashes to your will.

• Part 3: From Web Pages to Web Applications. With a solid foundation, you’re

ready to connect your web pages into a more cohesive unit. You’ll add custom

error handling so that your users won’t get confused when things go wrong,

and your own debugging to help you ﬁnd problems. You’ll also store references

to users’ images of themselves, store the images themselves in a database, and

learn which approach is best in which situations.

• Part 4: Security and the Real World. In even the simplest of applications, logging

in and logging out is critical. You’ll build an authentication system, and then deal

with passwords (which are important, but a bit of a pain). You’ll then work with

cookies and sessions, and use both to create a group-based authorization system

for your web application.

At the Missing Manual website (

www.missingmanuals.com/cds/phpmysqlmm

), you’ll

ﬁnd every single code example, from every chapter, in the state it was shown for

that chapter.

INTRODUCTION

XVII

ABOUT THE

ONLINE

RESOURCES

About the Online Resources

As the owner of a Missing Manual, you’ve got more than just a book to read. Online,

you’ll ﬁnd example ﬁles so you can get some hands-on experience, as well as tips,

articles, and maybe even a video or two. You can also communicate with the Missing

Manual team and tell us what you love (or hate) about the book. Head over to

www.

missingmanuals.com

, or go directly to one of the following sections.

Missing CD

This book doesn’t have a CD pasted inside the back cover, but you’re not missing

out on anything. Go to

www.missingmanuals.com/cds/phpmysqlmm

to download

code samples, code samples, and also, some code samples. Yup, there are a lot of

them. Every chapter has a section of code for that chapter. And you don’t just get

completed versions of the book’s scripts. You’ll get a version that matches up with

each chapter, so you’ll never get too confused about exactly how your version of a

script or web page should look.

And so you don’t wear down your ﬁngers typing long web addresses, the Missing

CD page also oers a list of clickable links to the websites mentioned in this book.

Registration

If you register this book at oreilly.com, you’ll be eligible for special oers—like discounts

on future editions of

PHP & MySQL: The Missing Manual.

Registering takes only a few

clicks. To get started, type

www.oreilly.com/register

into your browser to hop directly

to the Registration page.

Feedback

Got questions? Need more information? Fancy yourself a book reviewer? On our

Feedback page, you can get expert answers to questions that come to you while

reading, share your thoughts on this Missing Manual, and ﬁnd groups for folks who

share your interest in PHP, MySQL, and web applications in general. To have your

say, go to

www.missingmanuals.com/feedback

Errata

In an eort to keep this book as up-to-date and accurate as possible, each time we

print more copies, we’ll make any conﬁrmed corrections you’ve suggested. We also

note such changes on the book’s website, so you can mark important corrections

into your own copy of the book, if you like. Go to

http://tinyurl.com/phpmysql-mm

to report an error and view existing corrections.

剩余497页未读，继续阅读

yinkaisheng-nj

粉丝: 762
资源: 6231

PHP & MySQL The Missing Manual - 英文原版PDF

PHP & MySQL The Missing Manual epub

Php&Mysql the missing manual CD

char newcname[40]; printf("请输入课程名：\n");scanf("%s",cname); sprintf(sql,"select * from course where cname='%s';",cname); if(mysql_query(&mysql,sql)) { fprintf(stderr,"%s\n",mysql_error(&mysql));

check the manual that corresponds to your MySQL server version for the right syntax to use

check the manual that corresponds to your MySQL server version for the right syntax to use near 'cloud_store'

mysql check the manual that corresponds to your MySQL server version for the right syntax to use near

stderr: mysql Pulling mysql Error missing signature key Error response from daemon: missing signature key

c++ mysql 学生成绩管理系统

最新资源