Laravel：csv验证

Question

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();
        };

    }

Answer 1

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();
            };

        }