laravel 文件上传分页 excl导入导出

最新推荐文章于 2024-07-08 16:56:31 发布

li772030428

最新推荐文章于 2024-07-08 16:56:31 发布

阅读量763

点赞数

本文链接：https://blog.csdn.net/li772030428/article/details/52780578

版权

路由设置
Route::any('/','LianxiController@index');
Route::any('add','LianxiController@add');
Route::any('zhanshi','LianxiController@zhanshi');
控制器
<?php

namespace App\Http\Controllers;
use DB;
use App\Http\Requests\Request;
use App\Http\Controllers\Controller;
header('content-type:text/html;charset=utf8');
class LianxiController extends Controller
{
    public  function index(){
        return view('lianxi.index');
    }
    //上传图片
    public function add(){
        $arr['name']=\Request::input('name');
        $arr['miaoshu']=\Request::input('miaoshu');
        $file=$_FILES['filename'];
//        $type=substr($file['name'],strrpos($file['name'],'.')+1);
//        print_r($file);
        $name=$file['name'];
        $tmp=$file['tmp_name'];
        $path='./image/'.$name;
        move_uploaded_file($tmp,$path);
        $arr['filename']=$path;
        $re=DB::table('lianxi')->insert($arr);
        if($re){
            return redirect('zhanshi');
        }else{
            echo "上传失败";
        }
    }
    public function zhanshi(){
        $users = DB::table('lianxi')->simplePaginate(2);
        return view('lianxi.zhanshi', ['user' => $users]);
    }
}
页面
<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>练习</title>
</head>
<body>
<form action="add" method="post" enctype="multipart/form-data">
    <table>
        <input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">
        <tr>
            <td>账号</td>
            <td><input type="text" name="name"/></td>
        </tr>
        <tr>
            <td>密码</td>
            <td><input type="test" name="miaoshu"/></td>
        </tr>
        <tr>
            <td>上传</td>
            <td><input type="file" name="filename"/></td>
        </tr>
        <tr>
            <td><input type="submit" value="提交"/></td>
        </tr>
    </table>
</form>
</body>
</html>
展示
<table border="1">
    <tr>
        <td>账号</td>
        <td>描述</td>
        <td>图片</td>
    </tr>
    <?php foreach($user as $k=>$v){?>
    <tr>
        <td><?php echo $v['name']?></td>
        <td><?php echo $v['miaoshu']?></td>
        <td><img src="<?php echo $v['filename']?>"  height="100" width="100" alt=""/></td>
    </tr>
    <?php }?>
</table>
{!! $user->links() !!}
导出  注意是根据数据库的字段来设置
路由 
Route::any('/','ExclController@index');
Route::any('daochu','ExclController@daochu');
Route::any('daoru','ExclController@daoru');
控制器
<?php

namespace App\Http\Controllers;
use DB;
use App\Http\Requests\Request;
use App\Http\Controllers\Controller;
header('content-type:text/html;charset=utf8');
class ExclController extends Controller
{
    //展示
    public function index(){
        return view('index.index');
    }
    //导出
    public function daochu(){
    $arr=DB::table('diannao')->get();
        $str="编号\t名称\t品牌\tcpu\tcun\t描述"."\n";
        foreach($arr as $key=>$val){
            $str.=implode("\t",$val)."\n";
        }
        header("content-type:application/vnd.ms-excel");
        header("content-disposition:attachment;filename=brand.xls");
        echo $str;
    }
    //导入
    public function daoru(){
        $excl= $_FILES['filename'];
        $s=trim(file_get_contents($excl['tmp_name']));
        $res=explode("\n",$s);
        foreach($res as $key=>$val){
            $data[]=explode("\t",$val);
            //删除标题
            unset($data[0]);
        };
        foreach($data as $kk=>$v){
       //$i= iconv('GBK','UTF8',$v[2]);
     //  $i= mb_convert_encoding($v[2],'utf-8','GBK');
//         $re= DB::table('diannao')->insert($v);
//            $re=$this->db->query("insert into student values(null,'$v[0]','$v[1]','$i','$v[3]','$v[4]')");
          $re=  DB::insert('insert into diannao (id,goods_name,cart_name,cpu,cun,pan) values (?,?,?,?,?,?)', ["null","$v[1]","$v[2]","$v[3]","$v[4]","$v[5]"]);
            var_dump($re);
        }
      return view('index.index');
    }

}
html页面

    <form action="daoru" enctype="multipart/form-data" method="post">
        <input type="hidden" name="_token" value="<?php echo csrf_token() ?>"/>
        <table>
            <tr>
                <td>导入</td>
                <td><input type="file" name="filename"/></td>
            </tr>
            <tr>
                <td><input type="submit" value="提交"/></td>
            </tr>
        </table>
    </form>

       <a href="daochu">导出</a>