PDO 返回不正确但重复的数据.密钥不在数据库中. [英] PDO returning incorrect, but duplicate, data. Key's not in database.

问题描述

我刚开始使用 $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 文档
获取文档

这篇关于PDO 返回不正确但重复的数据.密钥不在数据库中.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！