<?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