'SET NAMES utf8'); $callback = isset($_GET['callback']) ? trim($_GET['callback']) : ''; //jsonp回调参数，必需 try { $dbh = new PDO($dsn, $user, $pass,$opts_values); $sql = "select * from hz_doctorinfo where doctorName in ( SELECT doctorName FROM hz_doctorinfo GROUP BY doctorName)"; $ch = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','W','X','Y','Z','defalut'); $data = array(); $i =0; foreach ($dbh->query($sql) as $value) { $firstCh = strtoupper(substr(pinyin($value['doctorName'], 'first'),0,1));//获取首字母 $data[$i]['doctor_name'] = $value['doctorName']; $data[$i]['id'] = $value['doctorId']; $data[$i]['deptId'] = $value['deptId']; if (in_array($firstCh,$ch)) { $data[$i++]['ch'] = $firstCh; } else { $data[$i++]['ch'] = 'defalut'; } } for ( $k = 0; $k ord($data[$j+1]['ch'])){ $temp = $data[$j]; $data[$j] = $data[$j+1]; $data[$j+1] = $temp; } } } if(!empty($data)){ $date["status"]="1"; $date["info"]="查询成功,医生列表信息"; $date["data"]=$data; }else { $date["status"] = "0"; $date["info"]="查询失败"; } $dbh = null; echo $callback.'('.json_encode($date).')';exit; } catch (PDOException $e) { die ("Error!: " . $e->getMessage() . "
"); }