admin 管理员组文章数量: 1184232
2024年4月23日发(作者：java 个人主页源码)
PHP外文翻译文献
PHP外文翻译文献
(文档含中英文对照即英文原文和中文翻译)
原文：
Getting PHP to Talk to MySQl
Now that you’re comfortable using the MySQL client tools to manipulate
data in the database, you can begin using PHP to display and modify data
from the database. PHP has standard functions for working with the
, we’re going to discuss PHP’s built-in database functions.
We’ll also show you how to use the The PHP Extension and Application
Repository (PEAR) database
functions that provide the ability to use the same functions to access
any supported database. This type of flexibility comes from a process
called
abstraction
. In programming interfaces, abstraction simplifies a
complex interaction. It works by
removing any nonessential parts of the interaction, allowing you to
concentrate on the important parts. PEAR’s DB classes are one such
database interface abstraction. The information you need to log into a
database is reduced to the bare minimum. This standard format allows you
to interact with MySQL, as well as other databases using the same functions.
1
PHP外文翻译文献
Similarly, other MySQL-specific functions are replaced with generic ones
that know how to talk to many databases. For example, the MySQL-specific
connect function is:
mysql_connect($db_host, $db_username, $db_password);
versus PEAR’s DB connect function:
$connection =
DB::connect("mysql://$db_username:$db_password@$db_host/$db_database"
);
The same basic information is present in both commands, but the PEAR
function also specifies the type of databases to which to connect. You
can connect to MySQL or other supported databases. We’ll discuss both
connection methods in detail.
In this chapter, you’ll learn how to connect to a MySQL server fromPHP,
how to use PHP to access and retrieve stored data, and how to correctly
display information to the user.
The Process
The basic steps of performing a query, whether using the mysql
command-line tool or PHP, are the same:
• Connect to the database.
• Select the database to use.
• Build a SELECT statement.
• Perform the query.
• Display the results.
We’ll walk through each of these steps for both plain PHP and PEAR
functions.
Resources
When connecting to a MySQL database, you will use two new resources. The
first is the link identifier that holds all of the information necessary
to connect to the database for an active connection. The other resource
is the results resource. It contains all information required to retrieve
results from an active database query’s result set. You’ll be creating
and assigning both resources in this chapter.
Querying the Database with PHP Functions
In this section, we introduce how to connect to a MySQL database with PHP.
It’s quite simple, and we’ll begin shortly with examples, but we should
talk briefly about what actually happens. When you try connecting to a
MySQL database, the MySQL server authenticates you based on your username
and password. PHP handles connecting
to the database for you, and it allows you to start performing queries
and gathering data immediately.
As in Chapter 8, we’ll need the same pieces of information to connect
to the database:
• The IP address of the database server
• The name of the database
2
版权声明：本文标题：PHP外文翻译文献 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/p/1713856446a654714.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论