<?phpheader("Content-Type:text/html;charset=utf-8");$con=mysql_connect("localhost","root","123456");if(!$con){die('Could not connect: '.mysql_error());}else{mysql_select_db("school",$con);mysql_query("set character set 'utf8'");//读库 mysql_query("set names 'utf8'");//写库$name=$_GET["name"];$result=mysql_query('SELECT * FROM students WHERE name="'.$name.'"');// $result : PHP世界里的关联数据(一朵奇葩)// 将$result变成前端所认识的数组或者是对象(JSON字符串)$response="[";while($row=mysql_fetch_array($result)){$response=$response.'{'.'"id":'.$row["id"].''.','.'"name":"'.$row["name"].'"'.','.'"sex":'.$row["sex"].''.','.'"city":"'.$row["city"].'"'.','.'"age":'.$row["age"].''.'},';}$response=substr($response,0,strlen($response)-1)."]";if(strlen($response)===1){echo"[]";}else{echo$response;}}?>