how to use nested array in while loop?

Question

I want to put data in array which then put in excel file but it does not work.

    $sql="SELECT `Jobc_id`, `Customer_name`, `Veh_reg_no`, `MSI_cat`, `Mileage` FROM `jobcard`";
$result = $conn->query($sql);

while($row = $result->fetch_assoc()){

    array( $row["job_id"],$row["Customer_name"],$row["Veh_reg_no"],$row["MSI_cat"],$row["Mileage"]);
}
foreach($rows as $row)
    $writer->writeSheetRow('Sheet1', $row);

Whereas, below code work..

$rows = array(
    array('2003','1','-50.5','2010-01-01 23:00:00','2012-12-31 23:00:00'),
    array('2003','B1', '23.5','2010-01-01 00:00:00','2012-12-31 00:00:00'),
); 
 foreach($rows as $row)
        $writer->writeSheetRow('Sheet1', $row);

How can I make first code to work :( pls help

"it does not work" We get this a lot. Do you get any errors? Where do you set $rows in your first code? — user8034901
– user8034901, Commented Feb 9, 2018 at 15:37

Sathishkumar · Accepted Answer · 2018-03-16 12:04:14Z

2

you are not assigning the array to a variable, therefore you can't access your fetched data after the while loop. This should fix it:

$rows = [];
while($row = $result->fetch_assoc()){
    $rows[] = [$row["job_id"],$row["Customer_name"],$row["Veh_reg_no"],$row["MSI_cat"],$row["Mileage"]];
}
// now you can use $rows

edited Mar 16, 2018 at 12:04

Sathishkumar

3,7932 gold badges36 silver badges39 bronze badges

answered Feb 9, 2018 at 15:39

kscherrer

5,7142 gold badges25 silver badges62 bronze badges

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

Collectives™ on Stack Overflow

how to use nested array in while loop?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related