how to fetch multiple records in mysql and store it into json array

Question

I am fetching multiple records from database and try to store into json array, but the only last record will get stored into array, can any one have any idea about this? How to store multiple data into an json array. and I have to display this array on the full-calendar.

here is my code:

foreach($result as $row){
    $records[$i][0]=substr($row['date'], 0, 10);
    $records[$i][1]=$row['in_time'];
    $records[$i][2]=$row['out_time'];
    $records[$i][3]=$row['attendance']; 

    $e['date']=$records[$i][0];
    $e['start']=$records[$i][1];
    $e['end']=$records[$i][2];
    $e['attendance']=$records[$i][3];

    $i++;

}
echo json_encode($e);

how to create multiple records json data ?

You're overwriting $e every loop. What are you expecting to happen? — CollinD
– CollinD, Commented Feb 14, 2017 at 4:34

Death-is-the-real-truth · Accepted Answer · 2017-02-14 04:40:01Z

1

You are overwriting $e again and again.That's the problem. So do like below:-

 $e[$i]['date']=$records[$i][0];
 $e[$i]['start']=$records[$i][1];
 $e[$i]['end']=$records[$i][2];
 $e[$i]['attendance']=$records[$i][3];

edited Feb 14, 2017 at 4:40

answered Feb 14, 2017 at 4:37

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

@MangeshKolape glad to help you.

Collectives™ on Stack Overflow

how to fetch multiple records in mysql and store it into json array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related