This:
$page = new \Page;
$page->fill(\Input::only('name', 'slug', 'content', 'type'));
$page->order = \DB::raw('MAX(order)+1');
Throws me error:
Illuminate \ Database \ QueryException (HY000)
SQLSTATE[HY000]: General error: 1 near "order": syntax error (SQL: insert into "pages" ("name", "slug", "content", "type", "order") values (tududu, tududu, <p>tamdam</p> , 0, (MAX(order)+1)))
Last updated
10 months ago.
0
Solution
You could take advantage of Eloquent model events:
Page::creating(function($page)
{
$page->order = Page::max('order')+1;
});
Last updated
10 months ago.
0
Sign in to participate in this thread!
Moderators
-
driesvints
Joined 16 Dec 2013
-
joedixon
Joined 23 Jun 2014
-
tvbeek
Joined 8 Jan 2018
-
tomhatzer
Joined 28 Oct 2021
Laravel
Laravel News
Laracasts
Laravel Podcast