I tried exporting php table in excel format 'xls', But exported data is showing in one column.
Code tried so far:
<?php
$host="localhost";
$username="root";
$password="";
$dbname="data-crypter";
$con = new mysqli($host, $username, $password,$dbname);
$sql_data="select * from users";
$result_data=$con->query($sql_data);
$results=array();
$filename = "Webinfopen.xls"; // File Name
header( "Content-disposition: filename=".$filename);
header("Content-Type: application/vnd.ms-excel");
$flag = false;
while ($row = mysqli_fetch_assoc($result_data)) {
if (!$flag) {
// display field/column names as first row
echo implode("\t", array_keys($row)) . "
";
$flag = true;
}
echo implode("\t", array_values($row)) . "
";
}
?>