<?php
header("Content-type: text/html; charset=utf-8");
$json = <<<JSON
{"total":28,"rows":[
{"id":1,"name":"xiongchuanliang","pwd":"xcl","status":"A"},
{"id":2,"name":"zj","pwd":"zj","status":"D"}
]}
JSON;
echo "PHP与JSON测试";
echo ‘<pre>‘;
//将JSON字符串变为JSON
echo json_encode($json);
echo ‘</pre>‘;
echo ‘<pre>‘;
$errJson[] = "{‘Organization‘: ‘PHP Documentation Team‘}";
foreach ($errJson as $string) {
echo ‘Decoding: ‘ . $string;
json_decode($string);
switch (json_last_error()) {
case JSON_ERROR_NONE:
echo ‘ - No errors‘;
break;
case JSON_ERROR_DEPTH:
echo ‘ - Maximum stack depth exceeded‘;
break;
case JSON_ERROR_STATE_MISMATCH:
echo ‘ - Underflow or the modes mismatch‘;
break;
case JSON_ERROR_CTRL_CHAR:
echo ‘ - Unexpected control character found‘;
break;
case JSON_ERROR_SYNTAX:
echo ‘ - Syntax error, malformed JSON‘;
break;
case JSON_ERROR_UTF8:
echo ‘ - Malformed UTF-8 characters, possibly incorrectly encoded‘;
break;
default:
echo ‘ - Unknown error‘;
break;
}
echo PHP_EOL;
}
echo ‘</pre>‘;
?>
<?php
header("Content-type: text/html; charset=utf-8");
//如何快速从MySQL表中取值组合成JSON
include ‘inc/xcl_conn.php‘;
$result = array();
$rs = mysql_query("select count(*) from users");
$row = mysql_fetch_row($rs);
$result["total"] = $row[0];
$sql=" SELECT id,name,pwd,status FROM users";
$rs = mysql_query($sql);
$items = array();
while($row = mysql_fetch_object($rs)){
array_push($items, $row);
}
$result["rows"] = $items;
echo json_encode($result);
?>
通过上面的代码,能用很少的代码得到例一形式的JSON结果集。二叉树的宽度优先遍历(队列实现),布布扣,bubuko.com
原文:http://blog.csdn.net/ding_hai_long/article/details/21092225