PDO 返回不正确但重复的数据.密钥不在数据库中.
我刚开始使用 $pdo 语句,所以可能很简单,我还没有在 php.net 上阅读过.我在查询数据库时收到重复的结果.
I'm new to using $pdo statements so might be something simple I haven't yet read on php.net. I'm receiving duplicate results when querying the database.
结果:
[0] => Array
(
[umeta_id] => 31
[0] => 31
[user_id] => 2
[1] => 2
[meta_key] => fbmeta
[2] => fbmeta
[meta_value] => someMetaValueStuff;
[3] => someMetaValueStuff;
)
查询很简单:
function getData(){
global $pdo;
$query = $pdo->prepare('SELECT * FROM usermeta WHERE meta_key = "fbmeta" LIMIT 0,30');
$query->execute();
return $query->fetchAll();
}
print_r( getData() );
问题是命名键 (umeta_id
, user_id
, meta_key
, meta_value
) 确实存在,数字键没有.查询如何返回这些?我该如何防止它们被退回?
The problem is that the named keys (umeta_id
, user_id
, meta_key
, meta_value
) DO exist, the numeric keys do not. How come the query returns these? And how do I prevent them from even being returned?
推荐答案
它不是重复的,它只是您正在使用的当前 FETCH_MODE
.要获得关联键,您只需要这样指定;默认情况下,它同时获取.
It's not duplicates, it's just the current FETCH_MODE
you're using. To get as associative keys only you need to specify as such; by default it fetches as both.
像这样使用:
$query->fetchAll(PDO::FETCH_NUM); // to fetch with numeric indexes
$query->fetchAll(PDO::FETCH_ASSOC); // to fetch with associative indexes
fetchAll 文档
获取文档
相关文章