PHP上传本地文件到服务器

来源：互联网发布：极速开票软件编辑：程序博客网时间：2024/05/17 16:43

【html 页面】

<td align="right"><span style="font-size:15px;">上传Excel文件：</span></td>
<td><input type="file" name="xls_file" id="xls_file" /> </td>

【php页面】

    //批量上传文件
   public function upload()
   {
       if($_FILES["xls_file"]["name"]=='')
       {
           showmessage('对不起，请选择您要上传的文件！', HTTP_REFERER);
           return;
       }
       else if($_FILES["xls_file"]["type"]!='application/msexcel')
       {
           showmessage('对不起，您上传的文件格式不正确！', HTTP_REFERER);
           return;
       }
       else if($_FILES["xls_file"]["error"]>0)
       {
           showmessage('Error:'.$_FILES["xls_file"]["error"].'<br />', HTTP_REFERER);
           return;
       }
       else if(file_exists(PC_PATH.'modules/client/'.$_FILES["xls_file"]["name"]))
       {
           showmessage('对不起,文件'.$_FILES["xls_file"]["name"].'已上传,请选择其他文件或者将此文件重命名上传!', HTTP_REFERER);
           return;
       }
       else if(!file_exists(PC_PATH.'modules/client/'.$_FILES["xls_file"]["name"]))
       {
           move_uploaded_file($_FILES["xls_file"]["tmp_name"],
                           PC_PATH.'modules/client/'.$_FILES["xls_file"]["name"]);
       }

       header("Content-Type:text/html;charset=utf-8");
       require_once 'Excel/reader.php';
       include_once "adodb5/adodb.inc.php";//调用adodb5类库
       $data = new Spreadsheet_Excel_Reader();//创建对象
       $data->setOutputEncoding('UTF-8');//设置文本输出编码
       $excel = PC_PATH.'modules/client/'.$_FILES["xls_file"]["name"];
       $data->read($excel);//读取Excel文件
       $data->setOutputEncoding('gbk');
       error_reporting(E_ALL ^ E_NOTICE);
       $clientInfo = array();
       $count=0;
       for ($i = 6; $i <= $data->sheets[0]['numRows']; $i++)
       {
           $clientInfo['client']['catid'] = $data->sheets[0]['cells'][$i][1];
           $clientInfo['client']['name'] = $data->sheets[0]['cells'][$i][2];
           $clientInfo['client']['sex'] = $data->sheets[0]['cells'][$i][3];
           $clientInfo['client']['address'] = $data->sheets[0]['cells'][$i][4];
           $clientInfo['client']['qq'] = trim($data->sheets[0]['cells'][$i][5]);
           $clientInfo['client']['email'] = trim($data->sheets[0]['cells'][$i][6]);
           $clientInfo['client']['updatetime'] = SYS_TIME;
           $clientInfo['client']['inputtime'] = SYS_TIME;
           $this->db->set_model(12);      //12对应于content模块对应的modelid （PHPCMS）
           if($this->db->add_content($clientInfo['client']))
           {
               $count++;
           }
       }
           showmessage('客户成功录入'.$count.'条记录！', HTTP_REFERER);
   }

0 0