会python真的可以为所欲为0(回)
355天前
这里还有人吗1(回)
540天前这里还有人吗0(回)
540天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
765天前到处都是羊，不想上班0(回)
845天前
鸽子
0(回)
849天前<? |
define("DB_HOST","localhost"); |
define("DB_USER","root"); |
define("DB_PASS","root"); |
define("DB_DATABASE","cowaw"); |
mysql_connect(DB_HOST,DB_USER,DB_PASS) or die('can not connect mysql database!'); |
mysql_select_db(DB_DATABASE) or die('can not select database!'); |
mysql_query('set names utf8'); |
header("Content-type:application/vnd.ms-excel"); //excel文件头 |
header("Content-Disposition:filename=xlstest.xls"); //excel文件头 |
$query = mysql_query("select name,sex,city,job from xlstest "); |
while ($result=mysql_fetch_array($query)){ |
echo $result['name']."\t".$result['sex']."\t".$result['city']."\t".$result['job']."\t\n"; |
} |
?> |
