- 1、本文档共14页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
PHPMySQLPHPMySQL
原文:?
?
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 database.First, 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.
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.
? Di
您可能关注的文档
- otis电梯BA接口说明书.doc
- OTIS电梯电气代码说明汤编撰.doc
- OTIS部分故障.doc
- Outline of American Literature 3.doc
- Outline of English Literature3.doc
- OTIS电梯维修资料.doc
- Outline of Survey.doc
- Overview of Malassimilation Syndromes in Large Animals.doc
- outlines of philosophy of education(2012届).doc
- p1549_1.保健食品申办资料范本p1549_.doc
- 云南省昆明市呈贡区重点达标名校2025届中考化学试题必刷试卷(新课标卷)含解析.doc
- 云南省建水第六中学2025届高考全国卷信息归集与高考命题预测数学试题含解析.doc
- 云南省红河州名校2023年九年级化学第一学期期中预测试题含解析.doc
- 云南省红河州名校2023-2024学年七下英语期末检测试题含答案.doc
- 云南省红河州弥勒市2025届初三物理试题5月月考试题含解析.doc
- 云南省红河州蒙自市2025届初三下学期第二次诊断性考试物理试题含解析.doc
- 云南省红河州蒙自市重点达标名校2024-2025学年初三第三次诊断性检测试题语文试题试卷含解析.doc
- 云南省红河州建水县2024-2025学年初三下学期“一诊模拟”考试(二)物理试题含解析.doc
- 云南省红河州建水县2023-2024学年英语七年级第二学期期末检测模拟试题含答案.doc
- 云南省昆明市八校2024届八年级英语第二学期期末联考模拟试题含答案.doc
文档评论(0)