<?php
include_once("config.php");
ob_start();
define("FILETYPE","xls");
header("Content-type:application/vnd.ms-excel");
if(FILETYPE=="xls")
header("Content-Disposition:filename=AMY_studentslist.xls");
else
header("Content-Disposition:filename=report.csv");
$tag1 = iconv("UTF-8", "GB2312",'编号');
$tag2 = iconv("UTF-8", "GB2312",'中文名');
$tag3 = iconv("UTF-8", "GB2312",'英文名');

echo "$tag1t$tag2t$tag3n";

$sql = "SELECT manager.id,manager.EnName,user.TrueName AS stu_cname FROM user_lebal USER LEFT JOIN manager ON user.StudyAdID = manager.id WHERE manager.EnName='AMY'  AND (user.State=0 OR user.State=1) AND
user.STATUS<>2 ORDER BY signdate DESC";
$query = mysql_query($sql);
$i=0;
    while($rs = mysql_fetch_array($query)){
     if($i<10){
      $code = "00".$i;}
      elseif($i<100){
      $code = "0".$i;}
      else{
       $code = $i;
      }
      $com_name = iconv("UTF-8", "GB2312", $rs['stu_cname']);
      $com_address = iconv("UTF-8", "GB2312", $rs['stu_ename']);
      

      echo "$codet$com_namet$com_addressn";
      $i++;
 }
?>

上一篇:普通的图片上传类
下一篇:php 过滤特殊字符及sql防注入代码