Home / Questions / 333958
Accepted
Rafael Monroy Rodriguez
Asked: 2020-03-03 15:54:17 +0800 CST 2020-03-03 15:54:17 +0800 CST

FirstOrCreate does not insert Laravel

  • 772

Hello , I am inserting data through a file exceland I am implementing the method firstOrCreatefor one of my tables, the problem is that it does not insert the data.

 public function model(array $row)
{



    //TABLA INSTRUMENTOS
    $tipo = tbl_tipo_instrumento::firstOrCreate([
        'tipo_nombre' => $row[14]
    ]);
    $marca = tbl_marca::firstOrCreate([
        'mar_nombre' => $row[15]
    ]);
    $id = Auth::id(); //trae el id del usuario logeado


    return new tbl_instrumentos([
        'ins_codigo'   => $row[0],
        'ins_observacionInicial'   => $row[4],
        'ins_claseOexactitud'    => $row[6],
        'ins_nSerie' => $row[1],
        'ins_divOescala'=>$row[5],
        'ins_claseOexactitud' =>$row[6] ,
        'ins_consecutivoInterno' => $row[7],
        'ins_observaciones' =>$row[8],
        'ins_observacionFinal' => $row[9],
        'ins_magnitud' => $row[10],
        'ins_modelo' => $row[11],
        'ins_codActividad' => $row[12],
        'ins_area' => 'null',
        'ins_usu_id' =>  $id,
        'ins_tipo_id' => $tipo->tipo_id,
        'ins_mar_id' => $marca->mar_id,
    ]);


}

That is the code that I am using and my model is the following:

class tbl_marca extends Model
{
use Authenticatable;

public $timestamps = false;
public $table="tbl_marca";
protected $primaryKey = 'mar_id';
protected $fillable = [ 'mar_nombre'];

}

If I enter the data manually in phpmyadminthe search without problems, $row[15] y $row[14]the names of each one are there. What could be the fault? I'm usinglaravel 6

Thank you

laravel

1 Answers

  1. Best Answer

    The method is supposed to firstOrCreatereceive an array of vectors where:

    • The first vector is the value to look for ( first)
    • The second vector is the value to insert if the first one was not found ( create)

    So I think you should write it like this:

    $data = Model::firstOrCreate(
            ['tipo_nombre' => $row[14]],
            ['columna1' => 'valor 1', 'columnaN' => 'valor N']
        );

    Where:

    • We tell it to look for the value you get $row[14]that corresponds to the column or propertytipo_nombre
    • In case the above does not return any value then we insert the values ​​to each of the respective columns

    Only modify the createwith the columns or values ​​that, depending on the case, are required

    • 1