I’m still not completely sure about your table relationships but from my guess, I came up with the following solution, first create the relationships using Eloquent models: User Model (for usres table): namespace App; use App\Course; use Illuminate\Notifications\Notifiable; use Illuminate\Foundation\Auth\User as Authenticatable; class User extends Authenticatable { use Notifiable; public function courses() { return $this->hasMany(Course::class); … Read more
Laravel 4+ Note for Laravel 5 users: You’ll need to call DB::enableQueryLog() before executing the query. Either just above the line that runs the query or inside a middleware. In Laravel 4 and later, you have to call DB::getQueryLog() to get all ran queries. $queries = DB::getQueryLog(); $last_query = end($queries); Or you can download a … Read more
Simply invoke orderBy() as many times as you need it. For instance: User::orderBy(‘name’, ‘DESC’) ->orderBy(’email’, ‘ASC’) ->get(); Produces the following query: SELECT * FROM `users` ORDER BY `name` DESC, `email` ASC
Here’s a full example of what “lu cip” was talking about: $user = User::firstOrNew(array(‘name’ => Input::get(‘name’))); $user->foo = Input::get(‘foo’); $user->save(); Below is the updated link of the docs which is on the latest version of Laravel Docs here: Updated link
Make use of Logical Grouping (Laravel 7.x/4.2). For your example, it’d be something like this: Model::where(function ($query) { $query->where(‘a’, ‘=’, 1) ->orWhere(‘b’, ‘=’, 1); })->where(function ($query) { $query->where(‘c’, ‘=’, 1) ->orWhere(‘d’, ‘=’, 1); });
Use the toSql() method on a QueryBuilder instance. DB::table(‘users’)->toSql() would return: select * from `users` This is easier than wiring up an event listener, and also lets you check what the query will actually look like at any point while you’re building it. Note: This method works for query builder or Eloquent, however toSql() is … Read more
Well I found the solution. It can be done one by passing a closure function in with() as second index of array like Post::query() ->with([‘user’ => function ($query) { $query->select(‘id’, ‘username’); }]) ->get() It will only select id and username from other table. I hope this will help others. Remember that the primary key (id … Read more
In Laravel 5.3 (and still true as of 7.x) you can use more granular wheres passed as an array: $query->where([ [‘column_1’, ‘=’, ‘value_1’], [‘column_2’, ‘<>’, ‘value_2′], [COLUMN, OPERATOR, VALUE], … ]) Personally I haven’t found use-case for this over just multiple where calls, but fact is you can use it. Since June 2014 you can … Read more