dongxiao_0528 2018-08-13 05:15
浏览 162
已采纳

Laravel:csv验证

How i can validate fields in csv file before uploading.

I want to get all duplicate email ids from csv file before uploading which are already available in db.

and if there is duplciate in file than upload the other except duplicate and after uploading display all duplicate email ids

    public function store(Request $request)
{
    $upload = $request->file('upload-file');
    $getPath = $upload->getRealPath();

    $file = fopen($getPath,'r');        

    while($columns = fgetcsv($file))
    {
        if($columns[0]=="")
        continue;


        $data =  $columns;


        foreach($data as $key=>$value)
        {
            $name = $data[0];
            $email = $data[1];
            $password = $data[2];

        }

        try{
            $user = User::Create(
                [
                    'name'=>$name,
                    'email'=>$email,
                    'password'=>$password,
                ]);
            $user->save();
        }
        catch(Exception $e)
        {
          if($e->getCode() == 23000)
              return 'we have found duplicate records';
          else
              $e->getCode();
        };

    }

展开全部

  • 写回答

2条回答 默认 最新

  • donglu8779 2018-08-13 20:57
    关注

    So you can do like this.

          public function store(Request $request)
        {
            $upload = $request->file('upload-file');
            $getPath = $upload->getRealPath();
    
            $file = fopen($getPath,'r');        
    
            while($columns = fgetcsv($file))
            {
                if($columns[0]=="")
                continue;
    
    
                $data =  $columns;
    
    
                foreach($data as $key=>$value)
                {
                    $name = $data[0];
                    $email = $data[1];
                    $password = $data[2];
    
                }
    
                try{
                 if (!User::whereEmail($email)->exists()) {
                    $user = User::Create(
                        [
                            'name'=>$name,
                            'email'=>$email,
                            'password'=>$password,
                        ]);
                    $user->save();
                 }
                }
                catch(Exception $e)
                {
                  if($e->getCode() == 23000)
                      return 'we have found duplicate records';
                  else
                      $e->getCode();
                };
    
            }
    

    展开全部

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)
编辑
预览

报告相同问题?

手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部