admin 管理员组

文章数量: 1086019


2024年4月23日发(作者：c语言玫瑰花完整代码)

原文：

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. 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.

1 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.

2 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


本文标签： 语言 玫瑰花 作者 代码

版权声明：本文标题：php毕业设计外文翻译--通过PHP访问MySQL 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://roclinux.cn/b/1713856412a654712.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。