Tuesday, 1 February 2022

Export sql data in excel using php

 <?php

$conn = mysqli_connect("localhost", "user_name", "password", "database_name");

$id = $_GET["id"];

$sqlQuery = "SELECT * FROM table_name'";

$resultSet = mysqli_query($conn, $sqlQuery) or die("database error:". mysqli_error($conn));

$developersData = array();

while( $developer = mysqli_fetch_assoc($resultSet) ) {

$developersData[] = $developer;

}

//if($id > "0") {

$fileName = "webdamn_export_".date('Ymd') . ".xls";

header("Content-Type: application/vnd.ms-excel");

header("Content-Disposition: attachment; filename=\"$fileName\"");

$showColoumn = false;

if(!empty($developersData)) {

  foreach($developersData as $developerInfo) {

if(!$showColoumn) {  

  echo implode("\t", array_keys($developerInfo)) . "\n";

  $showColoumn = true;

}

echo implode("\t", array_values($developerInfo)) . "\n";

  }

}

exit;  

//}

?>