php+mysql将数据库查询结果返回为Json格式，实例代码如下： ?php // 配置json header("Content-type: application/json;charset=UTF-8"); // 跨域配置 header("Access-Control-Allow-Credentials: true"); header("Access-Control-Allow-Origin: *"); $conn =
| |
|
| |
| | | |
<![CDATA[<i id='0kZVu'><tr id='0kZVu'><dt id='0kZVu'><q id='0kZVu'><span id='0kZVu'><b id='0kZVu'><form id='0kZVu'><ins id='0kZVu'></ins><ul id='0kZVu'></ul><sub id='0kZVu'></sub></form><legend id='0kZVu'></legend><bdo id='0kZVu'><pre id='0kZVu'><center id='0kZVu'></center></pre></bdo></b><th id='0kZVu'></th></span></q></dt></tr></i>]]><![CDATA[<div id='0kZVu'><tfoot id='0kZVu'></tfoot><dl id='0kZVu'><fieldset id='0kZVu'></fieldset></dl></div>]]>
|
|
|
<![CDATA[<bdo id='0kZVu'></bdo><ul id='0kZVu'></ul>]]>
|
|
<![CDATA[<legend id='0kZVu'><style id='0kZVu'><dir id='0kZVu'><q id='0kZVu'></q></dir></style></legend>]]><![CDATA[<small id='0kZVu'></small><noframes id='0kZVu'>]]>
|
| <![CDATA[<tfoot id='0kZVu'></tfoot>]]>
php+mysql将数据库查询结果返回为Json格式，实例代码如下：
<?php
// 配置json
header("Content-type: application/json;charset=UTF-8");
// 跨域配置
header("Access-Control-Allow-Credentials: true");
header("Access-Control-Allow-Origin: *");
$conn = mysqli_connect('localhost','root','123456','genbanorg');
mysqli_query($conn,"set character set 'utf8'");
mysqli_query($conn,"set names 'utf8'");
$result=mysqli_query($conn,"select * from prolist");
$jarr = array();
while ($rows=mysqli_fetch_array($result)){
$count=count($rows);//不能在循环语句中，由于每次删除 row数组长度都减小
for($i=0;$i<$count;$i++){
unset($rows[$i]);//删除冗余数据
}
array_push($jarr,$rows);
}
$json = JSON_encode($jarr,JSON_UNESCAPED_UNICODE);
$arr = json_decode($json);
echo $json;
// echo $arr;
// echo $str=json_encode($jarr);//将数组进行json编码
?>
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！
