PHP 的JSON 处理小结:
<?php
include 'DataConn.php';
/**
* 演示PHP的JSON转换。json_encode()和json_decode()
* 参考来源:
* http://www.ruanyifeng.com/blog/2011/01/json_in_php.html
* http://www.bejson.com/
*
* 于json只接受utf-8编码的字符,所以json_encode()的参数必须是utf-8编码,否则会得到空字符或者null。
* 当中文使用GB2312编码,或者外文使用ISO-8859-1编码的时候,这一点要特别注意。
*/
// $str =Array( 'suzh','wuxi','changhz','nanj');
// echo json_encode($str);
// $arr = Array('one', 'two', 'three');
// echo json_encode($arr);
//访问数据库,查询所有人名,返回Json
$sql="SELECT emp.empname FROM emp";
$result=mysql_query($sql);
//定义一个空数组,存储人名
$users=array();
//追加原来集合尾部
while($row=mysql_fetch_array($result))
{
// echo "<br>";
// echo $row["empname"];
array_push($users, $row["empname"]);
}
//
//echo count($users);
/**
* ["远航的兵","Fred","Jack","Jim","HanMeimei","Kate","Lilei","Poly","Tom","Mr.Zhai","Google","baidu","Sina","WebChat","David","ZhaiXinKuanHou"]
*/
echo json_encode($users);
// 关闭连接
mysql_close($con);
?>