php写的B/S,想点击链接后把服务器那边数据库里的有关数据导成xls下载下来,求实现方法 RT 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?php$DB_Server = "localhost";$DB_Username = "root";$DB_Password = "root";$DB_DBName = " ";$DB_TBLName = " ";$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)or die("Couldn't connect.");$Db = @mysql_select_db($DB_DBName, $Connect)or die("Couldn't select database.");mysql_query("set names gb2312");$file_type = "vnd.ms-excel";$file_ending = "xls";header("Content-Type: application/$file_type");header("Content-Disposition: attachment; filename=$DB_TBLName.$file_ending");header("Pragma: no-cache");header("Expires: 0");date_default_timezone_set("Etc/GMT-8");$now_date = date('Y-m-d H:i');$title = "数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date";$sql = "Select * from $DB_TBLName";$ALT_Db = @mysql_select_db($DB_DBName, $Connect)or die("Couldn't select database");$result = @mysql_query($sql,$Connect)or die(mysql_error());echo("$title\n");$sep = "\t";for ($i = 0; $i < mysql_num_fields($result); $i++) {echo mysql_field_name($result,$i) . "\t";}print("\n");$i = 0;while($row = mysql_fetch_row($result)){$schema_insert = "";for($j=0; $j<mysql_num_fields($result);$j++){if(!isset($row[$j]))$schema_insert .= "NULL".$sep;elseif ($row[$j] != "")$schema_insert .= "$row[$j]".$sep;else$schema_insert .= "".$sep;}$schema_insert = str_replace($sep."$", "", $schema_insert);$schema_insert .= "\t";print(trim($schema_insert));print "\n";$i++;}return (true);?> 高分寻求nginx下网址大小写问题的解决办法 请问这种将链接限制在本网站或者某几个网站的技术如何实现? 没分了,谁能帮忙写个这样的shell脚本 200分求助: linux下怎么升级gd的freetype? mysql中的空间如何释放? 请各位帮忙,谢谢! 郁闷,100分的问题,不想重复浪费分,因为有可能没有答案,我为PHP难过 对象也应该可以作为session变量吧? php怎么设置只提交一次,并且点击提交后,跳转页面 php非常诡异的抓取网页问题,亟待高手解决,在线等 自定义函数返回二维数组死活却为空 sql语句筛选当前时间和固定时间数据
<?php
$DB_Server = "localhost";
$DB_Username = "root";
$DB_Password = "root";
$DB_DBName = " ";
$DB_TBLName = " ";
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
or die("Couldn't connect.");
$Db = @mysql_select_db($DB_DBName, $Connect)
or die("Couldn't select database.");
mysql_query("set names gb2312");
$file_type = "vnd.ms-excel";
$file_ending = "xls";
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=$DB_TBLName.$file_ending");
header("Pragma: no-cache");
header("Expires: 0");
date_default_timezone_set("Etc/GMT-8");
$now_date = date('Y-m-d H:i');
$title = "数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date";
$sql = "Select * from $DB_TBLName";
$ALT_Db = @mysql_select_db($DB_DBName, $Connect)
or die("Couldn't select database");
$result = @mysql_query($sql,$Connect)
or die(mysql_error());
echo("$title\n");
$sep = "\t";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
$i = 0;
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
$i++;
}
return (true);
?>