Home Backend Development PHP Tutorial How to use ThinkPHP, uploadify, upload, PHPExcel to import data without refreshing

How to use ThinkPHP, uploadify, upload, PHPExcel to import data without refreshing

Sep 12, 2017 am 10:21 AM
phpexcel thinkphp

Front-end HTML+JQuery Note Jquery requires version 1.x, version 2.x cannot be used

1.Introduce necessary files and upload input


  <load file="__PUBLIC__/js/jquery-1.11.3.min.js" />
  <load file="__PUBLIC__/uploadify/jquery.uploadify.min.js" />
  <load file="__PUBLIC__/uploadify/uploadify.css" />
Copy after login


<input type="file" class="" id="student" name="student">
Copy after login

2.uploadify usage operation


 <script>
  $(function(){    //ThinkPHP上传地址
    var upload = "{:U(MODULE_NAME.&#39;/Student/upload&#39;)}";    //ThinkPHP sessionID的提交变量
    //&#39;VAR_SESSION_ID&#39;=>&#39;session_id&#39;,在ThinkPHP/Conf/convention.php中进行配置,默认关闭的需要开启
    var sid = &#39;{:session_id()}&#39;;    //导入数据地址
    var daoruUrl = "{:U(MODULE_NAME.&#39;/Student/daoruHandle&#39;)}"    //Amaze ui 模态框
    var modal = $(&#39;#my-modal-loading&#39;);    //uploadify使用方法
    $(&#39;#student&#39;).uploadify({      &#39;swf&#39;      : &#39;__PUBLIC__/uploadify/uploadify.swf&#39;,      &#39;uploader&#39; : upload,      &#39;buttonText&#39; : &#39;选择文件...&#39;,      &#39;width&#39;:120,      &#39;height&#39;:30,      &#39;formData&#39;:{&#39;session_id&#39;:sid},      &#39;fileTypeExts&#39;:&#39;*.xls&#39;,      //开始上传弹出模态框
      &#39;onUploadStart&#39; : function(file) {
        $(&#39;#alert-content&#39;).html(&#39;正在上传文件&#39;);
          modal.modal();
        },      //上传成功关闭模态框,并用后台函数导入数据
      &#39;onUploadSuccess&#39;:function(file, data, response){
        $(&#39;#alert-content&#39;).html(&#39;正在导入数据&#39;);
        data = eval("("+data+")");
        $.ajax({
          type: &#39;POST&#39;,
          url: daoruUrl,
          data: {&#39;file&#39;:data.file},
          success: function(retdata){
            modal.modal(&#39;close&#39;);            if(retdata==1){
              alert(&#39;导入成功&#39;);
            }else{
              alert(&#39;导入失败&#39;);
            }
          },
          dataType: &#39;json&#39;
        });
      }
    });
  });  </script>
Copy after login

3. ThinkPHP controller upload operation: Note that the Upload.class.php space needs to be introduced


    function upload(){        $config = array(            &#39;maxSize&#39;    =>    3145728,
            &#39;rootPath&#39;   =>    &#39;./Uploads/&#39;,
            &#39;savePath&#39;   =>    &#39;&#39;,
            &#39;saveName&#39;   =>    array(&#39;uniqid&#39;,&#39;&#39;),
            &#39;exts&#39;       =>    array(&#39;xls&#39;),
            &#39;autoSub&#39;    =>    true,
            &#39;subName&#39;    =>    array(&#39;date&#39;,&#39;Ymd&#39;),
            );        $upload = new Upload($config);        // 上传文件 
        $info   =   $upload->upload();        if(!$info) {// 上传错误提示错误信息
            $this->error($upload->getError());
        }else{// 上传成功 获取上传文件信息           
            $file = $info[&#39;Filedata&#39;][&#39;savepath&#39;].$info[&#39;Filedata&#39;][&#39;savename&#39;];
        }        //p($info);
        $data = array(            &#39;file&#39;=>&#39;./Uploads/&#39;.$file,
            );        echo json_encode($data);
    }
Copy after login

4. Import data into mysql


//导入数据处理
    function daoruHandle(){        $file = I(&#39;file&#39;);        $excelData = excel_to_mysql($file);        foreach($excelData[&#39;data&#39;] as $row){            $data = array(                &#39;xuehao&#39;=>$row[&#39;xuehao&#39;],
                &#39;xingming&#39;=>$row[&#39;xingming&#39;],
                &#39;xingbie&#39;=>($row[&#39;xingbie&#39;]==&#39;男&#39;)?1:0,
                &#39;mima&#39;=>md5($row[&#39;mima&#39;]),
                );
            M(&#39;student&#39;)->add($data);
        }        echo 1;
    }
Copy after login

5.PHPExcel reads Excel file and returns data function


function excel_to_mysql($file){        //导入PHPExcel第三方类库
        //vendor(&#39;PHPExcel.PHPExcel&#39;);
        import(&#39;Classes.PHPExcel&#39;,COMMON_PATH,&#39;.php&#39;);        //实例化PHPExcel类,用于接收Excel文件
        $PHPExcel = new PHPExcel();        //读取Excel文件类实例化
        $PHPReader = new PHPExcel_reader_Excel5();        //检测Excel版本是否可读
        if(!$PHPReader->canRead($file)){            
            $PHPReader = new PHPExcel_Reader_Excel2007();            
            if(!$PHPReader->canRead($file)) return array(&#39;error&#39;=>1);//未知版本的Excel        }        //读取Excel文件
        $PHPExcel = $PHPReader->load($file);        //获得Excel中表的数量
        $sheetCount = $PHPExcel->getSheetCount();        //获得第一张工作表
        $sheet=$PHPExcel->getSheet(0);        //获得表中最大数据列名
        $column = $sheet->getHighestColumn();        //获得表中最大数据行名
        $row = $sheet->getHighestRow();        //循环获得表中数据
        for($i=1;$i<=$row;$i++){            
            $data[] = array(                //通过工作表对象的getCell方法获得单元格 getValue方法获得该单元格数值
                &#39;xuehao&#39;=>$sheet->getCell(&#39;A&#39;.$i)->getValue(),              
                &#39;xingming&#39;=>$sheet->getCell(&#39;B&#39;.$i)->getValue(),
                &#39;xingbie&#39;=>$sheet->getCell(&#39;C&#39;.$i)->getValue(),
                &#39;mima&#39;=>$sheet->getCell(&#39;D&#39;.$i)->getValue(),
                        );
        }        //释放工作表对象
        unset($sheet);        //释放读取Excel文件对象
        unset($PHPReader);        //释放Excel文件对象
        unset($PHPExcel);        //返回数据
        return array(&#39;error&#39;=>0,&#39;data&#39;=>$data);
    }
Copy after login

The above is the detailed content of How to use ThinkPHP, uploadify, upload, PHPExcel to import data without refreshing. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to run thinkphp project How to run thinkphp project Apr 09, 2024 pm 05:33 PM

To run the ThinkPHP project, you need to: install Composer; use Composer to create the project; enter the project directory and execute php bin/console serve; visit http://localhost:8000 to view the welcome page.

There are several versions of thinkphp There are several versions of thinkphp Apr 09, 2024 pm 06:09 PM

ThinkPHP has multiple versions designed for different PHP versions. Major versions include 3.2, 5.0, 5.1, and 6.0, while minor versions are used to fix bugs and provide new features. The latest stable version is ThinkPHP 6.0.16. When choosing a version, consider the PHP version, feature requirements, and community support. It is recommended to use the latest stable version for best performance and support.

How to run thinkphp How to run thinkphp Apr 09, 2024 pm 05:39 PM

Steps to run ThinkPHP Framework locally: Download and unzip ThinkPHP Framework to a local directory. Create a virtual host (optional) pointing to the ThinkPHP root directory. Configure database connection parameters. Start the web server. Initialize the ThinkPHP application. Access the ThinkPHP application URL and run it.

Which one is better, laravel or thinkphp? Which one is better, laravel or thinkphp? Apr 09, 2024 pm 03:18 PM

Performance comparison of Laravel and ThinkPHP frameworks: ThinkPHP generally performs better than Laravel, focusing on optimization and caching. Laravel performs well, but for complex applications, ThinkPHP may be a better fit.

Development suggestions: How to use the ThinkPHP framework to implement asynchronous tasks Development suggestions: How to use the ThinkPHP framework to implement asynchronous tasks Nov 22, 2023 pm 12:01 PM

"Development Suggestions: How to Use the ThinkPHP Framework to Implement Asynchronous Tasks" With the rapid development of Internet technology, Web applications have increasingly higher requirements for handling a large number of concurrent requests and complex business logic. In order to improve system performance and user experience, developers often consider using asynchronous tasks to perform some time-consuming operations, such as sending emails, processing file uploads, generating reports, etc. In the field of PHP, the ThinkPHP framework, as a popular development framework, provides some convenient ways to implement asynchronous tasks.

How to install thinkphp How to install thinkphp Apr 09, 2024 pm 05:42 PM

ThinkPHP installation steps: Prepare PHP, Composer, and MySQL environments. Create projects using Composer. Install the ThinkPHP framework and dependencies. Configure database connection. Generate application code. Launch the application and visit http://localhost:8000.

How is the performance of thinkphp? How is the performance of thinkphp? Apr 09, 2024 pm 05:24 PM

ThinkPHP is a high-performance PHP framework with advantages such as caching mechanism, code optimization, parallel processing and database optimization. Official performance tests show that it can handle more than 10,000 requests per second and is widely used in large-scale websites and enterprise systems such as JD.com and Ctrip in actual applications.

Development suggestions: How to use the ThinkPHP framework for API development Development suggestions: How to use the ThinkPHP framework for API development Nov 22, 2023 pm 05:18 PM

Development suggestions: How to use the ThinkPHP framework for API development. With the continuous development of the Internet, the importance of API (Application Programming Interface) has become increasingly prominent. API is a bridge for communication between different applications. It can realize data sharing, function calling and other operations, and provides developers with a relatively simple and fast development method. As an excellent PHP development framework, the ThinkPHP framework is efficient, scalable and easy to use.

See all articles