php导入导出excel到mysql

php导入excel到mysql:
<?php
$fname = $_FILES['MyFile']['name'];
$do = copy($_FILES['MyFile']['tmp_name'],$fname);
if ($do)
{
echo"导入数据成功<br>";
} else {
echo "";
}
?>
<form ENCTYPE="multipart/form-data" METHOD="POST">
<p>导入CVS数据 <input action="<?php echo"".$_SERVER["PHP_SELF"].""; ?>" NAME="MyFile" TYPE="file">
<input VALUE="提交" TYPE="submit">
</p>
</form>
<?
error_reporting(0);
//导入CSV格式的文件
$connect=mysql_connect("localhost","root","root") or die("could not connect to database");
mysql_select_db("test",$connect) or die (mysql_error());
$fname = $_FILES['MyFile']['name'];
$handle=fopen("$fname","r");
while($data=fgetcsv($handle,10000,","))
{
$q="insert into test (code,name,date) values ('$data[0]','$data[1]','$data[2]')";

mysql_query($q) or die (mysql_error());

}
fclose($handle);
unlink($fname);
?>
注：在linux服务器上注意编码格式，在文件最前面加上setlocale(LC_ALL,'zh_CN.gb2312');


php导出mysql到excel:
<?
Header("Content-type: application/octet-stream");
Header("Accept-Ranges: bytes");
Header("Content-type:application/vnd.ms-excel");
Header("Content-Disposition:attachment;filename=".date("Y-m-d").".xls");
$S_Data_User = "root";
$S_Data_Pass = "root";
$S_Data_Host = "localhost";
$S_Data_Post = "3306";
$conn=mysql_connect($S_Data_Host,$S_Data_User,$S_Data_Pass) or die("服务器繁忙，请稍候访问，谢谢！ ");
$select = mysql_select_db("destoon",$conn);
mysql_query("SET character_set_connection='gbk', character_set_results='gbk', character_set_client=binary");
echo "产品编号"."\t";
echo "公司名"."\t";
echo "报价"."\t";
echo "时间"."\t";
echo "日期"."\t";
echo "天数"."\t";
echo "城市"."\t";
echo "备注"."\t";
echo "\n";
$sql = "select * from destoon_orderlist";
$query_count = mysql_query($sql,$conn);
while ($array = mysql_fetch_array($query_count)){
echo "=\"".$array['id']."\""."\t";
echo "=\"".$array['company']."\""."\t";
echo "=\"".$array['price']."\""."\t";
echo "=\"".date("H:i:s",$array['addtime'])."\""."\t";
echo "=\"".$array['adddate']."\""."\t";
echo "=\"".$array['tody']."\""."\t";
echo "=\"".$array['city']."\""."\t";
echo "=\"".$array['content']."\""."\t";
echo "\n";

}
?>