<?php
// Database Connection Details //
$db_host = 'localhost';
$db_user = 'root';
$db_pass = '123abc';
$db_name = 'webform';

// Database Connection //
$db_connect = mysqli_connect($db_host, $db_user, $db_pass, $db_name)
   or die('Error connecting to the database.  See datainsert.php.');

$query = "SELECT * FROM webtable";

$result = mysqli_query($db_connect, $query)
	or die(mysqli_error($db_connect));

$count = mysqli_num_fields($result);

for ($i = 0; $i < $count; $i++){
    $header .= mysqli_field_name($result, $i)."\t";
}

while($row = mysqli_fetch_row($result)){
  $line = '';
  foreach($row as $value){
    if(!isset($value) || $value == ""){
      $value = "\t";
    }else{
      $value = str_replace('"', '""', $value);
      $value = '"' . $value . '"' . "\t";
    }
    $line .= $value;
  }
  $data .= trim($line)."\n";
}
  $data = str_replace("\r", "", $data);

if ($data == "") {
  $data = "\no matching records found on the table\n";
}
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=webform_excel_report.xls");
header("Pragma: no-cache");
header("Expires: 0");

echo $header."\n".$data;
?>