01.<?
02.header("Content-type: application/vnd.ms-excel");
03.header("Content-Transfer-Encoding: binary ");?>
04.<?
05.header("Content-Disposition: attachment; filename=testing.xls");
06.?>
07.<html>
08.<body>
09.<?
10. $objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
11. $objDB = mysql_select_db("db_eport");
12. $strSQL = "SELECT * FROM person";
13. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
14.?>
15.<table width="600" border="1">
16.<tr>
17.<th width="91"> <div align="center">idcard </div></th>
18.<th width="98"> <div align="center">Name </div></th>
19.<th width="198"> <div align="center">surname </div></th>
20.<th width="97"> <div align="center">nickname </div></th>
21.<th width="59"> <div align="center">gender </div></th>
22.<th width="71"> <div align="center">phone </div></th>
23.<th width="250"> <div align="center">e-mail </div></th>
24.</tr>
25.<?
26. while($objResult = mysql_fetch_array($objQuery))
27. {
28.?>
29. <tr>
30. <td><div align="center"><?=$objResult["idcard"];?></div></td>
31. <td><?=$objResult["name"];?></td>
32. <td><?=$objResult["surname"];?></td>
33. <td><div align="center"><?=$objResult["nickname"];?></div></td>
34. <td align="right"><?=$objResult["gender"];?></td>
35. <td align="right"><?=$objResult["phone"];?></td>
36. <td align="right"><?=$objResult["email"];?></td>
37. </tr>
38.<?
39.}
40.?>
41.</table>
42.<?
43. mysql_close($objConnect);
44.?>
45.</body>
46.</html>
