2) mysql_db_query()
resource mysql_db_query(string database, string query [, resource link_id])
等价于 mysql_select_db() + mysql_query(),从参数中就可以清楚的看出来.
4. 获取和显示数据
1) mysql_result()
mixed mysql_result(resource result_set, int row [,mixed field])
从 result_set 的指定 row 中获取一个 field 的数据. 简单但是效率低.
举例:
$link1 = @mysql_connect("server1", "webuser", "password")
or die("Could not connect to mysql server!");
@mysql_select_db("company") or die("Could not select database!");
$query = "select id, name from product order by name";
$result = mysql_query($query);
$id = mysql_result($result, 0, "id");
$name = mysql_result($result, 0, "name");
mysql_close();
注意,上述代码只是输出结果集中的第一条数据的字段值,如果要输出所有记录,需要循环
处理
.
...
for ($i = 0; $i <= mysql_num_rows($result); $i++)
{
$id = mysql_result($result, 0, "id");
$name = mysql_result($result, 0, "name");
echo "Product: $name ($id)";
}
...
注意,如果查询字段名是别名,则 mysql_result 中就使用别名.
2) mysql_fetch_row()
array mysql_fetch_row(resource result_set)
从 result_set 中获取整行,把数据放入数组中.
举例(注意和 list 的巧妙配合):
...
$query = "select id, name from product order by name";
$result = mysql_query($query);
while(list($id, $name) = mysql_fetch_row($result)) {
echo "Product: $name ($id)";
2