/****************************************************************************
*自费生管理项-自费生导入改为只导入文件以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="" οnlοad="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
οnchange="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\" οnclick=\"select_format()\"/>图片UBB代码<br/><div id=\"site\"><table border=\"0\"><tr><td valign=\"top\">文件地址:</td><td><input type=\"text\" οnclick=\"sendtof(this.value)\" οnmοuseοver=\"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\" οnclick=\"sendtof(this.value)\" οnmοuseοver=\"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>