I cant get lastInsertId on laravel 7 project

Question

$sql = DB::table('laravel_products')
    ->insert(array(
        'name' => $name,
        'price' => $price,
        'qty' => $qty,
        'description' => $description,
        'uruu' => $uruu,
        'garage' => $garage,
        'duureg' => $duureg,
        'tagt' => $tagt,
        'talbai' => $talbai,
        'haalga' => $haalga,
        'tsonh' => $tsonh,
        'shal' => $shal,
        'tsonhtoo' => $ttsonh,
        'hdawhar' => $bdawhar,
        'lizing' => $lizing,
        'utas' => $utas,
        'email' => $email,
        'hereg' => $hereg,
        'bairshil' => $bairshil,
        'bairlal' => $bairlal,
        'ashig' => $ashigon,
        'zahi' => $zahi,
        'image' => $data
    ));

$lastInsertedID = $sql->lastInsertId();

When I try to insert its responses:

"Call to a member function lastInsertId() on bool"

I used insertGetId but its cant save multiple rows of pictures on mysql.

Welcome to SO ... the `insert` method doesn't return an object you could call methods on, it returns a `bool` .., you could get the underlying PDO instance from the connection and call that method on it though: `DB::getPdo()->lastInsertId()` — lagbox, Dec 12 '21 at 04:10
Thanks, its gets id and the product tables id and images tables ids are same now but looks not linked is it okay ? — Heathcliff, Dec 12 '21 at 04:26
idk what you mean by linked, you are inserting a single record into one table here — lagbox, Dec 12 '21 at 04:27
now i edited main post and thanks for helping me ^^ here is the pictures and codes — Heathcliff, Dec 12 '21 at 04:37
so tried to add multiple images to mysql but its saves first image that i chosen so tried on php its works fine but not laravel — Heathcliff, Dec 12 '21 at 04:41
uploaded files would have to be moved to a permanent location then you could get that path and store in the database, but that is outside the scope of this question .... is there a problem with the loop inserting records in the database? — lagbox, Dec 12 '21 at 04:42
i think i cant use SO properly sorry should i post another questions ? — Heathcliff, Dec 12 '21 at 04:45
it depends what you are trying to ask about now ... in reality your original question is answered and solved, but you seem to have more database issues to work on — lagbox, Dec 12 '21 at 04:46
I am going to revert your question to the original version and you can create a new question about any further questions, about image upload or the next set of database queries, etc ... good luck — lagbox, Dec 12 '21 at 04:55

score 1 · Answer 1 · answered Dec 12 '21 at 05:15

If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID:

$id = DB::table('users')->insertGetId(
    ['email' => 'john@example.com', 'votes' => 0]
);

from : https://laravel.com/docs/5.8/queries#inserts

score 0 · Accepted Answer · answered Dec 12 '21 at 04:30

0

If you want to get the last inserted ID like that you can call that method on the PDO instance directly:

$id = DB::getPdo()->lastInsertId();

answered Dec 12 '21 at 04:30

lagbox

48,571
8
72
83

score 0 · Answer 3 · answered Dec 12 '21 at 06:31

        $data = new LaravelProducts(); //LaravelProducts is your Model Name
    
        $data->name= $name; //here 'name' is your column name
        $data->price= $price; //here 'price' is your column name
        $data->qty= $qty; //here 'qty' is your column name
        $data->description= $description; //here 'description' is your column name
        ..........
        ..........
        $data->image= $image; //here 'image' is your column name

        $data->save();
        
        $lastInsertedId = $data->id;

Ripon Uddin · Answer 4 · 2021-12-12T04:52:33.197

You don't have to write a new query to collect last inserted id from database.

$laravel_product = DB::table('laravel_products')
             ->insertGetId( array(
                 'name' => $name,
                 'price' => $price,
                 'qty' => $qty,
                 'description' => $description,
                 'uruu' => $uruu,
                 'garage' => $garage,
                 'duureg' => $duureg,
                 'tagt' => $tagt,
                 'talbai' => $talbai,
                 'haalga' => $haalga,
                 'tsonh' => $tsonh,
                 'shal' => $shal,
                 'tsonhtoo' => $ttsonh,
                 'hdawhar' => $bdawhar,
                 'lizing' => $lizing,
                 'utas' => $utas,
                 'email' => $email,
                 'hereg' => $hereg,
                 'bairshil' => $bairshil,
                 'bairlal' => $bairlal,
                 'ashig' => $ashigon,
                 'zahi' => $zahi,
                 'image' => $data
                 )
             );

  foreach ($filenamesToSave as $filename) {
            DB::insert('INSERT INTO laravel_products_images ( product_id, filename ) VALUES ( ?, ? )',[$laravel_product->id, $filename]);
            return view('createproduct');
        } // Foreach Closing

 // Echo your inserted ID Like Below
 echo $laravel_product->id;

It should be 100% working for you.

no ... `insert` returns a `bool` https://github.com/laravel/framework/blob/8.x/src/Illuminate/Database/Query/Builder.php#L2885 — lagbox, Dec 12 '21 at 04:49

I cant get lastInsertId on laravel 7 project

4 Answers4