1. header ('Content-type: application/x-msexcel'); 
  2. header ("Content-Disposition: attachment; filename=$filename");
  3. header("Pragma: no-cache");
  4.             header("Expires: 0");
  6. echo '<html xmlns:o="urn:schemas-microsoft-com:office:office"
  7.     xmlns:x="urn:schemas-microsoft-com:office:excel"
  8.     xmlns="http://www.w3.org/TR/REC-html40">
  9.  <head>
  10.     <meta http-equiv="expires" content="Mon, 06 Jan 1999 00:00:01 GMT">
  11.     <meta http-equiv=Content-Type content="text/html; charset=gb2312">
  12.     <!--[if gte mso 9]><xml>
  13.     <x:ExcelWorkbook>
  14.     <x:ExcelWorksheets>
  15.       <x:ExcelWorksheet>
  16.       <x:Name></x:Name>
  17.       <x:WorksheetOptions>
  18.         <x:DisplayGridlines/>
  19.       </x:WorksheetOptions>
  20.       </x:ExcelWorksheet>
  21.     </x:ExcelWorksheets>
  22.     </x:ExcelWorkbook>
  23.     </xml><![endif]-->
  25. </head>';
  27. echo '<table><tr>';
  28. echo "<td>客户姓名</td>";
  29. echo "<td>客户手机</td>"; 
  30. echo "<td>身份证号</td>"; 
  31. echo "<td>客户地址</td>";
  32. echo "<td>申请银行</td>"; 
  33. echo "<td>额度</td>";
  34. echo '</tr>';
  36. $result=$db->query($sql);
  37. $num=$db->num_row($result);
  38. if ($num==0)
  39. {
  40. echo "真遗憾,没有相符合条件的数据！";
  41. exit;
  42. }
  43. while($rows=$db->fetch($result))
  44. {
  45.     echo '<tr>';
  46. echo '<td style="vnd.ms-excel.numberformat:@">'.$rows['name']."</td>";
  47. echo '<td style="vnd.ms-excel.numberformat:@">'.$rows['phone']."</td>";
  48. echo '<td style="vnd.ms-excel.numberformat:@">'.$rows['card']."</td>";
  49. echo '<td style="vnd.ms-excel.numberformat:@">'.$rows['address']."</td>";
  50. echo '<td style="vnd.ms-excel.numberformat:@">'.$rows['bank']."</td>";
  51. echo '<td style="vnd.ms-excel.numberformat:@">'.$rows['quota']."</td>";
  52.     echo '</tr>';
  53. }
  54. echo '</table>';