php/sql with json output

Question

I would like to create a json from my database's datas and the json output is like this:

`[{"id":"1","0":"1","nom":"test","1":"test","prenom":"john","2":"john","societe":"","3":"","mail":"[email protected]","4":"[email protected]","type":"creatif","5":"creatif","url":"johntest","6":"johntest"}]`

My php code to doing so is :

$stock = array();
$sql = $bdd->prepare("SELECT * FROM user");
if ($sql->execute())
{
    while ($row = $sql->fetch())
    $stock[] = $row;
}
print json_encode($stock);

My problem here is that everything is doubled, I have a first data with the good property like "nom":"test" and then I have a thing out of nowhere "1":"test".

How can I get rid of this second thing?

Thank you for your help

MrCode · Accepted Answer · 2014-05-09 12:02:01Z

2

Use PDO::FETCH_ASSOC in the fetch() call:

while ($row = $sql->fetch(PDO::FETCH_ASSOC))

PDO defaults to PDO::FETCH_BOTH which returns both the associative array and the numerical keyed array.

answered May 9, 2014 at 12:02

MrCode

64.6k10 gold badges95 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeromiin Over a year ago

Thank you guys for your hall it works very well ! ;)

Rikesh · Accepted Answer · 2014-05-09 12:01:49Z

2

Instead of $sql->fetch() pass FETCH_ASSOC because default it will use PDO::FETCH_BOTH,

$sql->fetch(PDO::FETCH_ASSOC);

Read PDOStatement::fetch for more details.

answered May 9, 2014 at 12:01

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

Collectives™ on Stack Overflow

php/sql with json output

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related