求导入导出.csv文件例子代码 求导入导出.csv文件例子代码,该文件是导入到数据库里面的(楼长会导入.txt文件)非常感谢!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 网络上有很多现成的类可以参考!http://www.php100.com/html/download/phpclass/2009/0508/2918.html 导入可以用:http://www.php100.com/html/download/phpclass/2009/0508/2919.html可以看看人家的源代码 我以前做的 你参考一下http://blog.csdn.net/wbandzlhgod/archive/2011/03/10/6237892.aspx function import(){// var_dump($_FILES);// echo $_FILES['userfile']['error']; if($_FILES){ //标记 $upload_success = false; $ = true; if(is_array($_FILES['userfile']) && $_FILES['userfile']['error']==0){ //上传文件名 $temp_arr = explode(".",$_FILES['userfile']['name']); //限定上传文件的类型 $mine = array('application/octet-stream','application/vnd.ms-excel'); if(!in_array($_FILES['userfile']['type'],$mine)){ $message .= '上传文件类型不正确'; $ = false; } if(!in_array($temp_arr[1],array('csv'))){ $message .= '上传的文件格式不正确、上传文件后缀限定为:<b>csv</b>'; $ = false; } if(is_array($temp_arr)){ //得到文件后缀 $file_exa = $temp_arr[1]; } $file_name = substr(dirname(__FILE__),0,-19)."cache\import_data_".date('YmdHms').".".$file_exa; //上传路径 if($){ if(is_uploaded_file($_FILES['userfile']['tmp_name'])){ if(move_uploaded_file($_FILES['userfile']['tmp_name'],$file_name)){// echo '文件上传成功';// $message .= "文件上传成功";// $message .= "<br />"; $upload_success = true; }else{ $message .= "文件上传失败"; $message .= "<br />"; } } } }elseif($_FILES['userfile']['error']>0){ if($_FILES['userfile']['error'] ==1){ $cur_filesize = $_FILES['userfile']['size']; } $message .= " 上传文件出现问题,请重新上传"; $message .= "<br />"; } //读取上传成功后的文件 插入数据库 if($upload_success){ $row = 1; $handle = fopen("$file_name","r"); while ($data = fgetcsv($handle, 1000, ",")) { $num = count($data); if($row == 1){ $row += 1;// echo "<p> $num 列 $row 行<br>\n"; }else{ $row++; // for($i=$row;$i<=$row;$i++){ for($i=$row;$i<=$row;$i++){ for ($c=0; $c < 1; $c++) { $dt['year'] = iconv("gb2312", "UTF-8", $data[0]); $dt['name'] = iconv("gb2312", "UTF-8", $data[2]); $dt['sex'] = iconv("gb2312", "UTF-8", $data[3]); $dt['birthday'] =$data[4]; if(strtotime($dt['birthday'])){ $dt['birthday'] = date("Y-m-d",strtotime($dt['birthday'])); }else{ $dt['birthday']=''; } $dt['nation'] = iconv("gb2312", "UTF-8", $data[5]); $dt['phone'] = iconv("gb2312", "UTF-8", $data[6]); $dt['email'] = iconv("gb2312", "UTF-8", $data[7]); $dt['country'] = iconv("gb2312", "UTF-8", $data[8]); $dt['recommend'] = iconv("gb2312", "UTF-8", $data[9]); $dt['school'] = iconv("gb2312", "UTF-8",$data[10]); $dt['specialty'] = iconv("gb2312", "UTF-8", $data[11]); $dt['intro'] = iconv("gb2312", "UTF-8", $data[12]);// var_dump($dt); //------------------写入数据库----------------------// if($this->CommonerModel->addCommoner($dt)){ continue; }else{ $message .= " ,此条数据导入失败"; $message .= "<hr />"; } //---------------------数据库----------------------// } } } }//while fclose($handle); $message .= "导入结束,共导入".($row-2)."条自费生数据"; } }//if($_FILES) $this->cismarty->assign('message', $message); $this->cismarty->display('admincp/commoner_import.html'); }本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/wbandzlhgod/archive/2011/03/10/6237892.aspx pear上有一个功能很强大的,叫Spreadsheet 总出现mysql_fetch_array(): supplied argument is not a valid MySQL result resource 在DISCUZ中密码的算法是怎么样的 如果根据不同文件类型显示图标 如何获取openlayer中的我添加的feature层的属性 帮忙分析下哪里错误 php怎么编写子目录绑定域名 php 解析dom后 汉字都编程类似ascii的东西了 关于lnmp下搭thinkPHP无法找打指定静态页面(求答案)(急) 请问下这个百分号是啥意思啊 看不懂 关于ThinkPHP的重定向问题,大神求助!! 求教 本地服务器的问题 请教PHP 模板的问题
// var_dump($_FILES);
// echo $_FILES['userfile']['error']; if($_FILES){
//标记
$upload_success = false;
$ = true; if(is_array($_FILES['userfile']) && $_FILES['userfile']['error']==0){
//上传文件名
$temp_arr = explode(".",$_FILES['userfile']['name']);
//限定上传文件的类型
$mine = array('application/octet-stream','application/vnd.ms-excel');
if(!in_array($_FILES['userfile']['type'],$mine)){
$message .= '上传文件类型不正确';
$ = false;
}
if(!in_array($temp_arr[1],array('csv'))){
$message .= '上传的文件格式不正确、上传文件后缀限定为:<b>csv</b>';
$ = false;
}
if(is_array($temp_arr)){
//得到文件后缀
$file_exa = $temp_arr[1];
}
$file_name = substr(dirname(__FILE__),0,-19)."cache\import_data_".date('YmdHms').".".$file_exa;
//上传路径 if($){
if(is_uploaded_file($_FILES['userfile']['tmp_name'])){
if(move_uploaded_file($_FILES['userfile']['tmp_name'],$file_name)){
// echo '文件上传成功';
// $message .= "文件上传成功";
// $message .= "<br />";
$upload_success = true;
}else{
$message .= "文件上传失败";
$message .= "<br />";
}
}
}
}elseif($_FILES['userfile']['error']>0){
if($_FILES['userfile']['error'] ==1){
$cur_filesize = $_FILES['userfile']['size'];
}
$message .= " 上传文件出现问题,请重新上传";
$message .= "<br />";
}
//读取上传成功后的文件 插入数据库
if($upload_success){ $row = 1;
$handle = fopen("$file_name","r");
while ($data = fgetcsv($handle, 1000, ",")) {
$num = count($data); if($row == 1){
$row += 1;
// echo "<p> $num 列 $row 行<br>\n";
}else{ $row++;
// for($i=$row;$i<=$row;$i++){
for($i=$row;$i<=$row;$i++){
for ($c=0; $c < 1; $c++) {
$dt['year'] = iconv("gb2312", "UTF-8", $data[0]);
$dt['name'] = iconv("gb2312", "UTF-8", $data[2]);
$dt['sex'] = iconv("gb2312", "UTF-8", $data[3]);
$dt['birthday'] =$data[4];
if(strtotime($dt['birthday'])){
$dt['birthday'] = date("Y-m-d",strtotime($dt['birthday']));
}else{
$dt['birthday']='';
}
$dt['nation'] = iconv("gb2312", "UTF-8", $data[5]);
$dt['phone'] = iconv("gb2312", "UTF-8", $data[6]);
$dt['email'] = iconv("gb2312", "UTF-8", $data[7]);
$dt['country'] = iconv("gb2312", "UTF-8", $data[8]);
$dt['recommend'] = iconv("gb2312", "UTF-8", $data[9]);
$dt['school'] = iconv("gb2312", "UTF-8",$data[10]);
$dt['specialty'] = iconv("gb2312", "UTF-8", $data[11]);
$dt['intro'] = iconv("gb2312", "UTF-8", $data[12]);
// var_dump($dt);
//------------------写入数据库----------------------//
if($this->CommonerModel->addCommoner($dt)){
continue;
}else{
$message .= " ,此条数据导入失败";
$message .= "<hr />";
}
//---------------------数据库----------------------//
}
}
}
}//while
fclose($handle);
$message .= "导入结束,共导入".($row-2)."条自费生数据";
}
}//if($_FILES)
$this->cismarty->assign('message', $message);
$this->cismarty->display('admincp/commoner_import.html');
}本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/wbandzlhgod/archive/2011/03/10/6237892.aspx