include('../common/conn.php'); $list=[]; $sql="SELECT a.cCusCode,a.cCusName,b.cCCName,a.cCusDepart,c.cDepName FROM dbo.Customer a LEFT JOIN dbo.CustomerClass b on a.cCCCode=b.cCCCode LEFT JOIN dbo.Department c on c.cDepCode=a.cCusDepart where b.cCCCode like '300%'"; $list=$db->getAll($sql); $list=array_iconv($list); if(is_array($list)){ echo json_encode($list,JSON_UNESCAPED_UNICODE); }