php代码:
<?php
$conn=mysql_connect('localhost','root','');
if(!$conn){
echo 'connect failed';
exit;
}
$sql='use student';
mysql_query($sql,$conn);
$sql="set names utf8";
mysql_query($sql,$conn);
$sql="select * from student";
$rs=mysql_query($sql,$conn);
if(!$rs){
if(empty($rs)){
echo 'empty res!';
}
echo 'get failed !';
exit;
}
//新建数组
$arr=array();
//遍历
//1.直接输出结果
//mysql_fetch_array:每次从结果集中取出一行作为数组,其他类似。
//while($row=mysql_fetch_array($rs,MYSQL_ASSOC)){
// $arr[]=$row;
//}
//2.转换为对象,处理数据
class Stu{
public $name;
public $age;
}
while($row=mysql_fetch_object($rs)){
$s=new Stu();
$s->name=$row->sname;
$s->age=$row->sage;
//填充数组
$arr[]=$s;
}
//对变量进行json编码
echo json_encode(array("state"=>"success",'student'=>$arr));
//释放结果
mysql_fre