小弟写了一段代码，先读取数据库中数据生成EXCEL（.CSV），再读取生成的EXCEL文档重新倒入库中，可出现了问题，好像再次重新倒入的数据每个字段前都有空格一样。
PHP生成EXCEL代码如下：
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=$filename");
echo "pp,\t";
echo "xh,\t";
echo "cm,\t";
echo "time,\t";
echo "name,\t";
echo "zt,\t";
echo "dlsname,\t";
echo "qy,\t";
echo "beizhu,\t";
echo "fhj,\t";
echo "thj,\t";
echo "lsj,\t";
echo "gtfl,\t";
echo "yjzt,\t";
echo "dlszt,\t";
echo "jxlb,\t";
echo "rwpd,\t";
echo "sftp\t\n";
//一下是数据库的输出
echo "$ref[pp],\t";
echo "$ref[xh],\t";
echo "$ref[cm],\t";
echo "$ref[time],\t";
echo "$ref[name],\t";
echo "$ref[zt],\t";
echo "$ref[dlsname],\t";
echo "$ref[qy],\t";
echo "$ref[beizhu],\t";
echo "$ref[fhj],\t";
echo "$ref[thj],\t";
echo "$ref[lsj],\t";
echo "$ref[gtfl],\t";
echo "$ref[yjzt],\t";
echo "$ref[dlszt],\t";
echo "$ref[jxlb],\t";
echo "$ref[rwpd],\t";
echo "$ref[sftp]\t\n";
倒回库中代码如下：
$upload_file=$HTTP_POST_FILES ['upload_file']['tmp_name'];
$upload_file_name=$HTTP_POST_FILES ['upload_file']['name'];
if($upload_file){
$store_dir = "/www/Webs/Vhost/jinyu/office/upload/";
move_uploaded_file($upload_file,$store_dir.$upload_file_name);
$handle = fopen ($store_dir.$upload_file_name,"r");
while ($data = fgetcsv ($handle, 1000, ",")) {
//此处代码为将data数组值依次insert到数据库中
}
}
在将data数组值insert到库中前我试着用trim去掉空格，可是入到库中后没有效果，类似空格依然存在。
请各位高手指点。