3v4l.org

run code in 300+ PHP versions simultaneously
<?php // mock class Sheet { public function setCellValue($a, $b) { echo "$a : $b\n"; } }; $sheet = new Sheet(); $ids = ["1", "2", "3"]; $fields = ["firstname", "lastname", "phonenumber"]; $data = [ ['a', 'b', 'bla'], ['John', 'Doe', '555-555-5555'] ]; // end mock //$ids = $_POST["id"]; //$values = $_POST["values"]; $sqlIds = implode(",", $ids); $sqlFields = implode(",", $fields); //$sql="SELECT $sqlFields FROM database WHERE id IN ($sqlIds)"; //$result = mysqli_query($connect, $sql); //$data = []; //while ($row = mysqli_fetch_array($result)) { // $data[] = $row; //} // headers $colLetter = "A"; $rowNumber = 1; // A1...Z1 for header foreach ($fields as $fieldname){ $sheet->setCellValue($colLetter.$rowNumber, $fieldname); $colLetter++; } // A2..Z999 for the rest foreach($data as $row) { $rowNumber++; $colLetter = "A"; foreach ($fields as $i => $fieldname) { $sheet->setCellValue($colLetter.$rowNumber, $row[$i]); $colLetter++; } }
Output for 7.1.25, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
A1 : firstname B1 : lastname C1 : phonenumber A2 : a B2 : b C2 : bla A3 : John B3 : Doe C3 : 555-555-5555

preferences:
164.1 ms | 403 KiB | 152 Q