SQL请求SELECT的结果


Result of SQL request SELECT

当我在数据库中选择值时,我会得到一个如下形式的字典:

// -- My code    
$requete = $bdd -> prepare('SELECT * FROM user WHERE name = ? AND id = ?');
    $requete -> execute(array($_GET['name'], $_GET['id']));
    $resultat = $requete ->fetch();
// --
  "User": {
        "id": "1",
        "0": "1",
        "name": "Hugo",
        "1": "Hugo",
        "password": "mdp",
        "2": "mdp",
        "matiere": "Math,Electro",
        "3": "Math,Electro",
        "roles": "User,SuperUser,bg,bg",
        "4": "User,SuperUser,bg"
    }

但我想要:

"User": {
        "id": "1",
        "name": "Hugo",
        "password": "mdp",
        "matiere": "Math,Electro",
        "roles": "User,SuperUser,bg,bg"
    }

你有解决这个问题的办法吗?提前谢谢!

使用$requte->fetch(PDO::FETCH_ASSOC)。在此处阅读有关获取样式的更多信息http://php.net/manual/en/pdostatement.fetch.php.