本文实例讲述了PHP使用mysql_fetch_object从查询结果中获取对象集的方法。分享给大家供大家参考。具体分析如下:
mysql_fetch_object函数用于,提取结果行从一个MySQL的结果集作为objectiative数组。
mysql_fetch_object语法:
1
|
array mysql_fetch_object (resource $Result_Set ) |
Result_Set句柄返回一个mysql_query查询结果集。
如果执行成功返回包含了所有数据行的object,如果失败则返回bool值
下面是演示代码:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
<?php $UserName = 'abc' ; $Password = '1234' ; $DbHandle = mysql_connect ( 'localhost' , $UserName , $Password ); if (! $DbHandle ) { die 'No database connection could be established.' ; } $DBName = 'w3db; if (!mysql_select_db ( $DBName , $DbHandle )) { die 'Database could not be selected.' ; } $Query = "SELECT ISBN, Title, Author FROM articles" ; $articles = mysql_query ( $Query , $DbHandle )); while ( $Row = mysql_fetch_object ( $articles )) { echo "ISBN = $Row->ISBN<br />\n" ; echo "Title = $Row->Title<br />\n" ; echo "Author = $Row->Author<br />\n" ; } ?> |
希望本文所述对大家的php程序设计有所帮助。