PHP查询数据函数（转自网络）

来源：互联网发布：linux exec命令符号编辑：程序博客网时间：2024/05/21 06:45

<?php

/*
PHP查询数据函数:
mysql_result()
mysql_fetch_row()
mysql_fetch_array()
mysql_fetch_assoc()
mysql_fetch_object()
*/
$conn=mysql_connect("localhost","root","");//连接数据库
mysql_select_db("test",$conn);//选择数据库test
//查询数据
$query="SELECT id,name,gender,phone,email FROM student";
mysql_query("set names 'gbk' ");
$result=mysql_query($query);

/*
// mysql_fetch_row() 函数用法一
while($rows=mysql_fetch_row($result))
{
 echo "学号:".$rows[0]." ";
 echo "姓名:".$rows[1]." ";
 echo "性别:".$rows[2]." ";
 echo "电话:".$rows[3]." ";
 echo "E-mail:".$rows[4]." ";
 echo " ";
}
*/

/*
//---------------------------------------------------------------------------
// mysql_fetch_row() 函数用法二
while(list($id,$name,$gender,$phone,$email)=mysql_fetch_row($result))
{
 echo "学号:".$id." ";
 echo "姓名:".$name." ";
 echo "性别:".$gender." ";
 echo "电话:".$phone." ";
 echo "E-mail:".$email." ";
 echo " ";
}
*/

//------------------------------------------------------------------------------

/*
// mysql_fetch_array() 函数用法
while($rows=mysql_fetch_array($result))
{
 echo "学号:".$rows['id']." ";
 echo "姓名:".$rows['name']." ";
 echo "性别:".$rows['gender']." ";
 echo "电话:".$rows['phone']." ";
 echo " ";
}
*/
//------------------------------------------------------------------------------

/*
// mysql_fetch_assoc() 函数用法
while($rows=mysql_fetch_assoc($result))
{
 echo "学号:".$rows['id']." ";
 echo "姓名:".$rows['name']." ";
 echo "性别:".$rows['gender']." ";
 echo "电话:".$rows['phone']." ";
 echo " ";
}
*/

//-----------------------------------------------------------------

// mysql_fetch_object() 函数用法

//以对象的形式返回查询结果

while($rows=mysql_fetch_object($result))
{
 echo "学号:".$rows->id." ";
 echo "姓名:".$rows->name." ";
 echo "性别:".$rows->gender." ";
 echo "电话:".$rows->phone." ";
 echo "E-mail:".$rows->email." ";
 echo " ";
}

?>