Columns are not saved in DB, Laravel

Question

I try to add value in DB, and after that to get the ID, and to use in another table ,for a column, but it's always null, and I am not sure why.

    $lkp_location = new LkpLocation();
    if (is_numeric($request->lkp_location_text)) {  // If I get number from request, the value exists in DB, Else create and return ID
        $lkp_location_id = $request->lkp_location_text;
    } else {
        $lkp_location->fill([
            'text' => $request->lkp_location_text,
        ])->save();
        $lastInsertedId = $lkp_location->id;
        $lkp_location_id = $lastInsertedId;
    }
    dump($lkp_location_id); //It's the ID from DB

    $person = new Person();
    $person->fill([
        //code with another columns...
        'lkp_location_id' => $lkp_location_id,
        //code with another columns...
    ]);

score 0 · Answer 1 · answered Feb 24 '20 at 05:35

0

You are using save method which returns boolean. You need to use create method, which will return you the object.

$lkp_location->fill([
            'text' => $request->lkp_location_text
])->create();

answered Feb 24 '20 at 05:35

Iynga Iyngaran Iyathurai

796
1
9
14

When I use create(), I get message that the field is null. – Beusebiu Feb 24 '20 at 06:59
Are you using $fillable ? Can you show me ur model ? – Iynga Iyngaran Iyathurai Feb 24 '20 at 07:03
Yes, protected $fillable = ['text']; – Beusebiu Feb 24 '20 at 07:03
However , you need to use create() method and make sure the $request->lkp_location_text has a value. – Iynga Iyngaran Iyathurai Feb 24 '20 at 07:06
I dump it, and I got a value. When I use save, it works ,and I receive it's last ID, but when I try to use it in People, the value is null, maybe is something the fact that is a FK, not sure. – Beusebiu Feb 24 '20 at 07:10

Columns are not saved in DB, Laravel

1 Answers1