$cons:{'co':mysql连接对象,'db':要链接的库的字符串} $arrs:[{导出后对象的键,导出前的sql列名},...] $sql:sql查询语句 1. [代码] [PHP]代码 function backjson($cons,$arrs,$sql){if ($arrs$sql) {$list = array();mys
$arrs : [{导出后对象的键,导出前的sql列名},...]
$sql : sql查询语句
1. [代码][PHP]代码
function backjson($cons,$arrs,$sql){
if ($arrs&&$sql) {
$list = array();
mysql_select_db($cons['db'],$cons['co']);
mysql_query('SET NAMES UTF8');
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res)) {
$aro = array();
foreach ($arrs as $key => $value) {
$aro[$key] = $row[$value];
}
array_push($list, $aro);
}
return json_encode($list,JSON_UNESCAPED_UNICODE);
}
}
