将查询结果保存到excel中

<?php
 //****************连接数据库***************
$localhost=”localhost”;
$root=”root”; // 用户
$databasename=”study”;//数据库
$dbps=”joyous”;//用户密码
$conn=mysql_connect(“localhost”,”$root”,”$dbps”)or die(“连接数据库错误”);
$db=mysql_select_db(“$databasename”)or die(“数据连接出错了”);
mysql_query(“set names ‘gb2312’ “);

 //excel类
  class Excel
  {
   function Start()
   {
    ob_start();
   }
   function Save($path)
   {
    $data=ob_get_contents();
    ob_end_clean();
    $this->WriteToExcel($path,$data);
   }
   function WriteToExcel($fn,$data)
   {
    $fp=fopen($fn,”wb”);
    fwrite($fp,$data);
    fclose($fp);
   }
  }
 
 if($_GET[‘id’])
  {
   $Excel=new Excel();//建立对象，准备写入
   $Excel->Start();
  }
 ?>
 <table width=”900″ border=”1″ cellspacing=”0″ cellpadding=”0″ align=”center”>
   <tr>
     <td width=”223″>id</td>
     <td width=”345″>name</td>
     <td width=”324″>qq</td>
   </tr>
   <?php
 $sql=”select * from excel”;
 $mysql=mysql_query($sql);
 while($info=mysql_fetch_array($mysql))
 {?>
   <tr>
     <td><?php echo $info[‘id’]; ?></td>
     <td><?php echo $info[‘name’]; ?></td>
     <td><?php echo $info[‘qq’]; ?></td>
   </tr>
 </table>
<?php 
 }
 if($_GET[‘id’])
 {
  $Excel->Save(“xls/data.xls”);
 }
 if($_GET[‘id’]==”)
 {
 ?>
 <input type=”button” value=”将数据保存到Excel中” onclick=”window.location.href=’index.php?id=excel'” />
 <?php
 }else
 {
  echo “保存成功”;
 }
 ?>

 CREATE TABLE `excel` (
   `id` int(11) NOT NULL auto_increment,
   `name` varchar(50) character set gb2312 collate gb2312_bin NOT NULL,
   `qq` varchar(10) character set gb2312 collate gb2312_bin NOT NULL,
   PRIMARY KEY  (`id`)
 )