$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); } }