Error in laravel 7.0, with import list excel to collection :

ErrorException Trying to get property 'id' of non-object Stack trace Request App User Context Debug Share

Collapse vendor frames 57 C:\xampp\htdocs\evaluation_controle\app\Imports\ImportReponses.php Illuminate\Foundation\Bootstrap\HandleExceptions :29 56 C:\xampp\htdocs\evaluation_controle\app\Imports\ImportReponses.php App\Imports\ImportReponses :29 55 Maatwebsite\Excel\Sheet :252 54 Maatwebsite\Excel\Reader :111 53 Illuminate\Database\Connection :28 52 Maatwebsite\Excel\Transactions\DbTransactionHandler :30 51 Maatwebsite\Excel\Reader :115 50 Maatwebsite\Excel\Excel :146 49 Illuminate\Support\Facades\Facade :261 48 App\Http\Controllers\Admin\ImportController :35

1 unknown frame 46 C:\xampp\htdocs\evaluation_controle\vendor\laravel\framework\src\Illuminate\Routing\Controller.php Illuminate\Routing\Controller :54 45 Illuminate\Routing\ControllerDispatcher :45 44 Illuminate\Routing\Route :225 43 Illuminate\Routing\Route :182 42 Illuminate\Routing\Router :681 41 Illuminate\Pipeline\Pipeline :128 40 App\Http\Middleware\SetLocale :24 39 Illuminate\Pipeline\Pipeline :167 38 App\Http\Middleware\AuthGates :34 37 Illuminate\Pipeline\Pipeline :167 36 Illuminate\Routing\Middleware\SubstituteBindings :41 35 Illuminate\Pipeline\Pipeline :167 34 Illuminate\Auth\Middleware\Authenticate :44 33 Illuminate\Pipeline\Pipeline :167 32 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken :76 31 Illuminate\Pipeline\Pipeline :167 30 Illuminate\View\Middleware\ShareErrorsFromSession :49 29 Illuminate\Pipeline\Pipeline :167 28 Illuminate\Session\Middleware\StartSession :56 27 Illuminate\Pipeline\Pipeline :167 26 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse :37 25 Illuminate\Pipeline\Pipeline :167 24 Illuminate\Cookie\Middleware\EncryptCookies :66 23 Illuminate\Pipeline\Pipeline :167 22 Illuminate\Pipeline\Pipeline :103 21 Illuminate\Routing\Router :683 20 Illuminate\Routing\Router :658 19 Illuminate\Routing\Router :624 18 Illuminate\Routing\Router :613 17 Illuminate\Foundation\Http\Kernel :165 16 Illuminate\Pipeline\Pipeline :128 15 Illuminate\Foundation\Http\Middleware\TransformsRequest :21 14 Illuminate\Pipeline\Pipeline :167 13 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode :63 12 Illuminate\Pipeline\Pipeline :167 11 Illuminate\Foundation\Http\Middleware\ValidatePostSize :27 10 Illuminate\Pipeline\Pipeline :167 9 Fideloper\Proxy\TrustProxies :57 8 Illuminate\Pipeline\Pipeline :167 7 Illuminate\Foundation\Http\Middleware\TransformsRequest :21 6 Illuminate\Pipeline\Pipeline :167 5 Illuminate\Pipeline\Pipeline :103 4 Illuminate\Foundation\Http\Kernel :140 3 Illuminate\Foundation\Http\Kernel :109 2 :55 1 :21 Illuminate\Foundation\Bootstrap\HandleExceptions::handleError C:\xampp\htdocs\evaluation_controle\app\Imports\ImportReponses.php:29

*

* @return \Illuminate\Database\Eloquent\Model|null

*/

    public function collection(Collection $rows)

    {

       // print_r(count($rows));

     //  print_r("question-id :". Question::where('question',$rows[0][0])->get()->first()->id);





        for ($row=0; $row < count($rows); $row++) {

       // $question_id = Question::where('question',$rows[$row][0])->first()->id;

      //  $question_id = Question::where('question',$rows[$row][0])->first();

        //print_r($question_id);

   //   if((Question::where('question',$rows[$row][0])->get()->first()->id) != null){

        for ($q=1; $q <= 9; $q++) {

            print_r(Question::firstWhere('question',$rows[$row][0])->id);

           print_r("option :". $rows[$row][$q]);

           print_r("reponse_img :". $rows[$row][11]);







       // if($row[1] || $row[2]){ $isanswer = 1; }

        Reponse::create([

            'question_id'  => Question::where('question',$rows[$row][0])->get()->first()->id,

            //'question_id'  =>65,

            'option'       => $rows[$row][$q],

            'reponse_img'  => $rows[$row][11],

            'isanswer'     => 1,

            'compteur'      => 0,

        ]);

    }

via Chebli Mohamed