<?php

     date_default_timezone_set('PRC');//设置时区

     /*设置head头信息*/

     Header("Content-Type:application/vnd.ms-excel;charset=UTF-8");

     Header("Accept-Ranges:bytes");

     Header("Content-Disposition:attachment;filename=".date('YmdHis').".xls");

     Header("Pragma:no-cache");

     Header("Expires:0");

     $str = $str2 = null;

     /*设置表格信息*/

     $str.= "ID"."\t";

     $str.= "用户名"."\t";

     $str.= "密码"."\t";

     $str.= "邮箱"."\t\r\n";

     $info = iconv("UTF-8","GBK",$str);

     echo $info;

     /*查询内容导出数据库数据*/

     $link = @mysql_connect('localhost','root','') or die('Failed to connect to the MySQL');

     mysql_select_db('l_test',$link);

     mysql_set_charset('utf8',$link);

     $query = 'select * from lt_user';

     $result = mysql_query($query);

     while($row = mysql_fetch_assoc($result)){

         $list[] = $row;

     }

     mysql_free_result($result);

     mysql_close($link);

     foreach($list as $v){

         $str2.= trim(iconv("UTF-8","GBK",$v['id']))."\t";

         $str2.= trim(iconv("UTF-8","GBK",$v['username']))."\t";

         $str2.= trim(iconv("UTF-8","GBK",$v['passwd']))."\t";

         $str2.= trim(iconv("UTF-8","GBK",$v['email']))."\t\r\n";

     }

     echo $str2;

 ?>