How can I export mysql database to excel, with php, with some columns not formated as general, but as text.
I want for columns SNumber and Phone to be format as text. The id, fname and lname is fine...
My php looks like this:
<?php include "db.php"; ?>
<?php ob_start(); ?>
<?php
$output = "";
if(isset($_POST['export_excel'])) {
$sql = mysqli_query($connection, "SET NAMES utf8;");
$sql = "SELECT * FROM table";
$result = mysqli_query($connection, $sql);
if(mysqli_num_rows($result) > 0) {
$output .= "
<table class='table' bordered='1'>
<tr>
<th>ID</th>
<th>FName</th>
<th>LName</th>
<th>SNumber</th>
<th>Phone</th>
</tr>
";
while($row = mysqli_fetch_array($result)) {
$output .= "
<tr>
<td>".$row['id']."</td>
<td>".$row['fname']."</td>
<td>".$row['lname']."</td>
<td>".$row['snumber']."</td>
<td>".$row['phone']."</td>
</tr>
";
}
$output .= "</table>";
header("Content-Type: application/xls");
header("Content-Disposition: attachment; filename=kapCMS.xls");
echo $output;
}
}
?>
