laravel save create the object but not insert in database

Question

I have problems in keeping the data in the database, the query creates the object for me returns the id of the same, but not the row inserted in the table.

This is the way in which I keep the data:

  $lineup = new lineup(); <br>
  $lineup->user_id = Auth::user()->id;<br>
  $lineup->date = $fecha; <br>
  $lineup->salary_rest = $salary_rest;<br>

   $lineup->save();

PD: I am using laravel 4.2.

What database are you using? If you look in your config/database.php file it should have 'default' => "something here" — Brett
– Brett, Commented May 24, 2016 at 22:48
I am working with mysql, but the rare is that in other seccion the save() works fine. — theband
– theband, Commented May 24, 2016 at 23:14
Is any of your code calling DB::beginTransaction() ? and never commiting it? DB::commit()? — Brett
– Brett, Commented May 24, 2016 at 23:19
It is not just this section, change the way of doing the insert but not serves me. — theband
– theband, Commented May 24, 2016 at 23:27
Brett thank you very much, I did well review the code and me di account the commit() was commented. — theband
– theband, Commented May 24, 2016 at 23:52

Brett · Accepted Answer · 2016-05-25 01:38:02Z

2

There are 2 things to check when items aren't saving to the database.

Check the config/database.php file to ensure it's using the correct database driver.

Secondly ensure if a Transaction is being used that a commit statement is called.

DB::beginTransaction()
// Your code
DB::commit()

Without the commit the changes won't flow through to the database

answered May 25, 2016 at 1:38

Brett

2,0202 gold badges30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

laravel save create the object but not insert in database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related