PHP - get multiple rows from MySQL and JSON-encode them

Question

I'm trying to get a JSON array from the MySQL database. Here's the part of the code that fetches rows and add them into the array.

<?php
if($rowcount > 0) {
    while($row = mysqli_fetch_row($fetch)) {
        $row_array["uid"] = $row['unique_id'];
        $row_array["users"]["name"] = $row['name'];
        $row_array["users"]["email"] = $row['email'];
        array_push($users, $row_array);
    }
    mysqli_free_result($fetch);
    echo json_encode($users);
}
?>

This part is causing an error, showing the following message.

Notice: Undefined index: unique_id in /storage/h3/859/644859/public_html/searchfriends.php on line 20

Notice: Undefined index: name in /storage/h3/859/644859/public_html/searchfriends.php on line 21

Notice: Undefined index: email in /storage/h3/859/644859/public_html/searchfriends.php on line 22

Each line represents the following parts.

$row_array["uid"] = $row['unique_id'];
$row_array["users"]["name"] = $row['name'];
$row_array["users"]["email"] = $row['email'];

So, I believe I did not properly format the array. How should I fix it correct?

I just checked out the table and the column names are fine. They are literally unique_id, name, and email. The order is a little bit different though. — marshallslee
– marshallslee, Commented Feb 3, 2017 at 7:09
put index value instead of name of the table column like 0,1,2 as answer by @Anant use assoc instead row — BetaDev
– BetaDev, Commented Feb 3, 2017 at 7:11
@Anant I just fixed the problem with your tip. You saved my day!! — marshallslee
– marshallslee, Commented Feb 3, 2017 at 7:50

Death-is-the-real-truth · Accepted Answer · 2017-02-03 07:14:12Z

2

Based on manual :-http://php.net/manual/en/mysqli-result.fetch-row.php

It will give you a numeric indexes array. So you have to do like below:-

$row[0],$row[1].... so on

OR

Best should be change this single line like below:-

while($row = mysqli_fetch_assoc($fetch)) { 
// instead of mysqli_fetch_row use mysqli_fetch_assoc

edited Feb 3, 2017 at 7:14

answered Feb 3, 2017 at 7:09

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

1 Comment

Death-is-the-real-truth Over a year ago

Marshall S. Lee glad to help you

Death-is-the-real-truth · Accepted Answer · 2017-02-04 02:45:55Z

1

<?php
if($rowcount > 0){
    while($row = mysqli_fetch_row($fetch)) {
echo "<pre>";
 print_r($fetch); //  check here you have columns of email ,name etc.. or not
 die;
        $row_array["uid"] = $row['unique_id'];
        $row_array["users"]["name"] = $row['name'];
        $row_array["users"]["email"] = $row['email'];
        array_push($users, $row_array);
    }
    mysqli_free_result($fetch);
    echo json_encode($users);
}
?>

edited Feb 4, 2017 at 2:45

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered Feb 3, 2017 at 7:13

Haninder Singh

6284 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP - get multiple rows from MySQL and JSON-encode them

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related