PHP查询数据函数

PHP查询数据函数:
mysql_result()
mysql_fetch_row()
mysql_fetch_array()
mysql_fetch_assoc()
mysql_fetch_object()


?php
//by Mr.Bool 2007.10.24
/*
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 "
";
}
?>