Pass sql data into associative array in PHP

Question

I am trying to print out some database entries into an associative array, but it's only printing the first entry.

This is my code

if (mysqli_num_rows($result) > 0) {
    $data_array = array();
    while($row = mysqli_fetch_assoc($result)) { 
        $data_array['name']=$row["name"];
        $data_array['title']=$row["title"];
        $date=date_create($row['published']);
        $edited_date=date_format($date,"l, F d, Y");
        $data_array['date']=$edited_date; 
    }
} else {
    echo "0 results";
} 
echo json_encode($data_array);

aynber · Accepted Answer · 2016-02-19 17:01:30Z

2

You're replacing the data each time. You need to add more depth to your array:

while($row = mysqli_fetch_assoc($result)) { 
    $data_array[]['name']=$row["name"];
    $data_array[]['title']=$row["title"];
    $date=date_create($row['published']);
    $edited_date=date_format($date,"l, F d, Y");
    $data_array[]['date']=$edited_date; 
}

answered Feb 19, 2016 at 17:01

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

2 Comments

learning_bee15 Over a year ago

Thanks for saving my day, you're my hero :)

Phiter Over a year ago

One day I'll also be someone's hero.

Collectives™ on Stack Overflow

Pass sql data into associative array in PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related