我使用jquery ui js。
当我返回结果时,我正在这样做:
$stmt = $dbh->prepare('SELECT id,value FROM `table` WHERE `column` LIKE :keyword');
$keyword = "%".$data."%";
$stmt->bindParam(':keyword', $keyword, PDO::PARAM_STR);
$stmt->execute();
while ($user = $stmt->fetch(PDO::FETCH_ASSOC)) {
$user['value']=htmlentities(stripslashes($user['column']));
$user['id']=(int)$user['id'];
$user_set[] = $user;
}
返回的数组:
[{"id":1,"column":"user","value":"user"}]
我只设置了$user[id]和$user['value'],但返回了三个内容,为什么?
问候!
while ($user = $stmt->fetch(PDO::FETCH_ASSOC)) {
^^^^^