导入以csv为后缀的文件

来源：互联网发布：淘宝7了个3 编辑：程序博客网时间：2024/05/01 14:30

/****************************************************************************
*自费生管理项-自费生导入改为只导入文件以csv后缀的文件所需要函数 fgetcsv
****************************************************************************/
function import(){
// var_dump($_FILES);
// echo $_FILES['userfile']['error'];

  if($_FILES){
   //标记
   $upload_success = false;
   $mark = 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 .= '上传文件类型不正确';
     $mark = false;
    }
    if(!in_array($temp_arr[1],array('csv'))){
     $message .= '上传的文件格式不正确、上传文件后缀限定为：<b>csv</b>';
     $mark = 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($mark){
     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');
}

/*************************************** 结束*************************************/

php图片上传存储源码，可实现预览

<?php
header("content-Type: text/html; charset=UTF-8");
//确定文件上传类型
$uptypes=array('image/jpg','image/jpeg','image/png','image/pjpeg','image/gif','image/bmp','application/x-shockwave-flash','image/x-png','application/msword','audio/x-ms-wma','audio/mp3','application/vnd.rn-realmedia','application/x-zip-compressed','application/octet-stream');
//上传文件大小限制, 单位BYTE
$max_file_size=10000000;
$path_parts=pathinfo($_SERVER['PHP_SELF']); //取得当前路径
$destination_folder="up/"; //上传文件路径
$watermark=0; //是否附加水印(1为加水印,0为不加水印);
$watertype=1; //水印类型(1为文字,2为图片)
$waterposition=2; //水印位置(1为左下角,2为右下角,3为左上角,4为右上角,5为居中);
$waterstring="www.wangbin.cn"; //水印字符串
$waterimg="xplore.gif"; //水印图片
$imgpreview=1; //是否生成预览图(1为生成,0为不生成);
$imgpreviewsize=1/1; //缩略图比例
?>

<html xmlns="undefined">
<head>
<title>图片上传储存</title>
<LINK rel="Bookmark" href="http://www.yinao.tk/ico.ico" >
<LINK rel="Shortcut Icon" href="http://www.yinao.tk/ico.ico" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="description" content="亿脑网盘_免费网络无限大图片上传储存" />
<style type="text/css">
body,td{font-family:tahoma,verdana,arial;font-size:11px;line-height:15px;background-color:white;color:#666666;
strong{font-size:12px;}
a:link{color:#0066CC;}
a:hover{color:#FF6600;}
a:visited{color:#003366;}
a:active{color:#9DCC00;}
a{TEXT-DECORATION:none}
td.irows{height:20px;background:url("index.php?i=dots") repeat-x bottom}
</style>
</head>

<script type="text/javascript">
function oCopy(obj){obj.select();js=obj.createTextRange();js.execCommand("Copy");};function sendtof(url){window.clipboardData.setData('Text',url);alert('复制地址成功，粘贴给你好友一起分享。');};function select_format(){var on=document.getElementById('fmt').checked;document.getElementById('site').style.display=on?'none':'';document.getElementById('sited').style.display=!on?'none':'';};var flag=false;function DrawImage(ImgD){var image=new Image();image.src=ImgD.src;if(image.width>0&&image.height>0){flag=true;if(image.width/image.height>=120/80){if(image.width>120){ImgD.width=120;ImgD.height=(image.height*120)/image.width;}else {ImgD.width=image.width;ImgD.height=image.height;};ImgD.alt=image.width+"×"+image.height;}else {if(image.height>80){ImgD.height=80;ImgD.width=(image.width*80)/image.height;}else {ImgD.width=image.width;ImgD.height=image.height;};ImgD.alt=image.width+"×"+image.height;}};};function FileChange(Value){flag=false;document.all.uploadimage.width=10;document.all.uploadimage.height=10;document.all.uploadimage.alt="";document.all.uploadimage.src=Value;};
</script>

<body bgcolor="#FFFFFF">
<center>
  <form enctype="multipart/form-data" method="post" name="upform">
   <table border="1" width="55%" id="table1" cellspacing=0>
   <tr>
   <td colspan="2"><p align="center">最大文件限制1M </td>
   </tr>
   <tr>
   <td width="10%"><div style="width:120px; height:80px;overflow:hidden;text-align: center;" ><IMG id=uploadimage height=0 width=0 src="" onload="javascript:DrawImage(this);" ></div></td>
   <td width="71%"><div style="width:361px; height:80px;overflow:hidden;text-align: center;padding:30px; " >
   <input style="width:208;border:1 solid #9a9999; font-size:9pt; background-color:#ffffff; height:18" size="17" name=upfile type=file
onchange="javascript:FileChange(this.value);">
   <input type="submit" value="上传" style="width:60;border:1 solid #9a9999; font-size:9pt; background-color:#ffffff; height:18" size="17"></td>
   </tr>
   </table>

   允许上传的文件类型为:jpg|jpeg|gif|bmp|png|swf|mp3|wma|zip|rar|doc</form>

  <?php
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
if (!is_uploaded_file($_FILES['upfile']['tmp_name']))//是否存在文件
{
echo "<font color='red'>文件不存在！</font>";
exit;
}
$file = $_FILES["upfile"];
if($max_file_size < $file["size"])//检查文件大小
{
echo "<font color='red'>文件太大！</font>";
   exit;
}
if(!in_array($file["type"], $uptypes))//检查文件类型
{
echo "<font color='red'>不能上传此类型文件！</font>";
exit;
}
if(!file_exists($destination_folder))
mkdir($destination_folder);
$filename=$file["tmp_name"];
$image_size = getimagesize($filename);
$pinfo=pathinfo($file["name"]);
$ftype=$pinfo['extension'];
$destination = $destination_folder.time().".".$ftype;
if (file_exists($destination) && $overwrite != true)
{
echo "<font color='red'>同名文件已经存在了！</a>";
exit;
}
if(!move_uploaded_file ($filename, $destination))
{
echo "<font color='red'>移动文件出错！</a>";
exit;
}
$pinfo=pathinfo($destination);
$fname=$pinfo['basename'];
echo " <font color=red>成功上传,鼠标移动到地址栏自动复制</font><br><table width=\"348\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\" class=\"table_decoration\" align=\"center\"><tr><td><input type=\"checkbox\" id=\"fmt\" onclick=\"select_format()\"/>图片UBB代码<br/><div id=\"site\"><table border=\"0\"><tr><td valign=\"top\">文件地址:</td><td><input type=\"text\" onclick=\"sendtof(this.value)\" onmouseover=\"oCopy(this)\" style=font-size=9pt;color:blue size=\"44\" value=\"http://".$_SERVER['SERVER_NAME'].$path_parts["dirname"]."/".$destination_folder.$fname."\"/>

</td></tr></table></div><div id=\"sited\" style=\"display:none\"><table border=\"0\"><tr><td valign=\"top\">文件地址:</td><td><input type=\"text\" onclick=\"sendtof(this.value)\" onmouseover=\"oCopy(this)\" style=font-size=9pt;color:blue size=\"44\" value=\"[img]http://".$_SERVER['SERVER_NAME'].$path_parts["dirname"]."/".$destination_folder.$fname."[/img]\"/></td></tr></table></div></td></tr></table>";
echo " 宽度:".$image_size[0];
echo " 长度:".$image_size[1];
if($watermark==1)
{
$iinfo=getimagesize($destination,$iinfo);
$nimage=imagecreatetruecolor($image_size[0],$image_size[1]);
$white=imagecolorallocate($nimage,255,255,255);
$black=imagecolorallocate($nimage,0,0,0);
$red=imagecolorallocate($nimage,255,0,0);
imagefill($nimage,0,0,$white);
switch ($iinfo[2])
{
case 1:
$simage =imagecreatefromgif($destination);
break;
case 2:
$simage =imagecreatefromjpeg($destination);
break;
case 3:
$simage =imagecreatefrompng($destination);
break;
case 6:
$simage =imagecreatefromwbmp($destination);
break;
default:
die("<font color='red'>不能上传此类型文件！</a>");
exit;
}
imagecopy($nimage,$simage,0,0,0,0,$image_size[0],$image_size[1]);
imagefilledrectangle($nimage,1,$image_size[1]-15,80,$image_size[1],$white);
switch($watertype)
{
case 1: //加水印字符串
imagestring($nimage,2,3,$image_size[1]-15,$waterstring,$black);
break;
case 2: //加水印图片
$simage1 =imagecreatefromgif("xplore.gif");
imagecopy($nimage,$simage1,0,0,0,0,85,15);
imagedestroy($simage1);
break;
}

switch ($iinfo[2])
{
case 1:
//imagegif($nimage, $destination);
imagejpeg($nimage, $destination);
break;
case 2:
imagejpeg($nimage, $destination);
break;
case 3:
imagepng($nimage, $destination);
break;
case 6:
imagewbmp($nimage, $destination);
//imagejpeg($nimage, $destination);
break;
}

//覆盖原上传文件
imagedestroy($nimage);
imagedestroy($simage);
}

if($imgpreview==1){
echo "<br>图片预览:<br>";
echo "<a href=\"".$destination."\" target='_blank'><img src=\"".$destination."\" width=".($image_size[0]*$imgpreviewsize)." height=".($image_size[1]*$imgpreviewsize);
echo " alt=\"图片预览:\r文件名:".$fname."\r上传时间:".date('m/d/Y h:i')."\" border='0'></a>";
}
}
?>

</center>

</body>

</html>