| Server IP : 195.130.67.5 / Your IP : 216.73.217.154 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Old Sites/modip/infosystem_v7/lib/excel/PHPExcel/ |
Upload File : |
if ($result = mysql_query($query) or die(mysql_error())) {
/** Create a new PHPExcel object 1.0 */
$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setTitle('Data');
}
}
$rowNumber = 1; //start in cell 1
while ($row = mysql_fetch_assoc($result)) {
$col = 'A'; // start at column A
// returns title row
if ( $rowNumber == 1 ){
$headers = array_keys($row);
foreach($headers as $header) {
$objPHPExcel->getActiveSheet()->setCellValue($col.$rowNumber,$header);
$col++;
}
$rowNumber++;
}else{ //returns content rows
$col = 'A';
foreach($row as $cell) {
$objPHPExcel->getActiveSheet()->setCellValue($col.$rowNumber,$cell);
$col++;
}
$rowNumber++;
}
}