mysql_connect('localhost','root','');
mysql_select_db('pan-78');
mysql_query('SET NAMES utf8');
$sql = "select a.*,b.* from vcms_info as a left join vcms_class as b on a.cid = b.classid where a.logo = 'item' order by a.cid ASC";
$result = mysql_query($sql);
header("Content-Type: application/vnd.ms-execl");
header("Content-Disposition: attachment; filename=myExcel.xls");
header("Pragma: no-cache");
header("Expires: 0");
/*first line*/
echo "id"."\t";
echo iconv("UTF-8", "gb2312", "标题")."\t";
echo iconv("UTF-8", "gb2312", "分类")."\t";
echo iconv("UTF-8", "gb2312", "简介")."\t";
echo "\t\n";
while($data = mysql_fetch_object($result)){
/*start of second line*/
echo $data->id."\t";
echo iconv("UTF-8", "gb2312", $data->title)."\t";
echo iconv("UTF-8", "gb2312", $data->classname)."\t";
echo iconv("UTF-8", "gb2312", $data->description)."\t";
echo "\t\n";
}
