JSON(04)PHP的JSON处理函数及将MySQL结果集快速转为JSON的方法
<?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结果集。
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。