当我在数据库中选择值时,我会得到一个如下形式的字典:
// -- 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.