Iterating Through PHP Array for Chart Display

I'm having trouble iterating through a PHP array in order to display a chart. Right now, my code is only resulting in the display of one column in the chart (this column is displaying correctly), but I can't seem to get other columns to display.

This is my code right now (in a php section at the top of my html page). I know that the issue is with this section of code, because the chart is rendering perfectly, but just not adding a column for each record in the table.

I'd really appreciate any insight into the mistakes I'm making here. Thank you.

$valueAnimalType = $_POST['animaltype'];

$connect = mysqli_connect("","____","_____",3306);
$result = mysqli_query($connect,"SELECT * FROM DISPOSAL");
$datas = array();

if (mysqli_num_rows($result) > 0){
    while($row = mysqli_fetch_assoc($result)){
        $datas[] = $row;

    foreach ($datas as $data){
        $datas = array(
        array('y' => $data[$valueAnimalType], "label" => $data['DisposalName'] ));

1 answer

  • answered 2018-03-13 21:42 stetoc

    modify your code here:

        foreach ($datas as $data) {
            //LINE BELOW    
            $datas [] =
                array('y' => $data[$valueAnimalType], "label" => $data['DisposalName']);
            //LINE ABOVE

    you're overwriting your $datas each time loop passes with last record, now it's appending new item to array