mySQL to JSON Object only returns first row [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 12 months ago.

Improve this question

these lines of code :

$sql ="SELECT * FROM parcours";
$r = mysqli_query($con,$sql);
$result = array();

while($res = mysqli_fetch_array($r)){

 $result[] = $res;
}
echo json_encode(array("result"=>$result));

returns me only the first row of my DB request.

How can I get all of it ?

Nothing looks obviously wrong with this. You're sure parcours has more than 1 row in it? after your while loop var_dump($result) has more than 1 item? — Ryan Tuosto
– Ryan Tuosto, Commented Apr 9, 2017 at 18:09
var_dump($result) returned me 2 rows (which is the number of rows) — Baptiste Arnaud
– Baptiste Arnaud, Commented Apr 9, 2017 at 18:15
Can you copy the output of your echo into your question. It doesn't look like anything is wrong so far. — Ryan Tuosto
– Ryan Tuosto, Commented Apr 9, 2017 at 18:16

Amr Aly · Accepted Answer · 2017-04-09 18:17:43Z

0

I think you need to use mysqli_fetch_assoc :

while($res = mysqli_fetch_assoc($r)){

 $result[] = $res;
}

and then :

echo json_encode(array($result));

answered Apr 9, 2017 at 18:17

Amr Aly

3,9152 gold badges18 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

mySQL to JSON Object only returns first row [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related