PHP中怎么用SQL把一些数据资料导出到本地电脑呢

[zqq88]

如题，我想在系统中把数据导出到本地，而不是服务器，请高手帮忙，推荐几个例子

[raid79]

可以借助数据导入导出工具

[raulhhf]

set_time_limit(0);
ob_start();
$Host ='localhost';
$User ='root';
$Password='';
$Database='IdInfo';
$Server = mysql_connect($Host, $User, $Password);
$Select = mysql_select_db($Database, $Server);
function CradID ($mId)
{
switch ($mId)
{
case '11':
return "身份证";
case '15':
return "学生证";
case '90':
return "军官证";
case '91':
return "警官证";
case '92':
return "士兵证";
case '93':
return "户口簿";
case '94':
return "护照";
case '95':
return "台胞证";
case '96':
return "回乡证";
case '99':
return "其他证件";
default:
return "其他证件";
}
}

$tSql = base64_decode($tSQL);
$ret=mysql_query($tSql,$Server);
$data="";
//这个部分写你的操作数据库的代码，准备就绪后就看下边
while($row=@mysql_fetch_row($ret))
{
//转义证件类型
$row[4]=CradID($row[4]);
//为了在excel中能把长数字显示出来，在数字前面加'号
$row[5]="'".$row[5];
$row[6]="'".$row[6];
$line=@join(",",$row);
$line=preg_replace("!\r\n|\r\n!","<br>",$line);
$line.="\r\n";
$data.=$line;
}
//第一条记录为标题
$rowfirst[0]="卡号";
$rowfirst[1]="上机时间";
$rowfirst[2]="下机时间";
$rowfirst[3]="用户姓名";
$rowfirst[4]="证件类型";
$rowfirst[5]="证件号码";
$rowfirst[6]="网吧ID";
$rowfirst[7]="网吧名称";
$rowfirst[8]="机器名";
$rowfirst[9]="内部IP";
$title=@join(",",$rowfirst);
$title=preg_replace("!\r\n|\r\n!","<br>",$title);
$title.="\r\n";
$data=$title.$data;

$name="data.csv";
$filesize=strlen($data);

@header("Content-Type:application/x-msdownload");
@header("Content-Disposition:".(strstr($_SERVER[TTP_USER_AGENT],"MSIE")?"":"attachment;")."filename=$_SERVER[SERVER_NAME]-$name");
@header("Content-Length:$filesize");
echo $data;
ob_end_flush();
die;