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
Eloquent has a method for that (Laravel 4.*/5.*); Model::whereNotNull(‘sent_at’) Laravel 3: Model::where_not_null(‘sent_at’)
When using ->get() you cannot simply use any of the below: if (empty($result)) { } if (!$result) { } if ($result) { } Because if you dd($result); you’ll notice an instance of Illuminate\Support\Collection is always returned, even when there are no results. Essentially what you’re checking is $a = new stdClass; if ($a) { … … Read more
With with() is for eager loading. That basically means, along the main model, Laravel will preload the relationship(s) you specify. This is especially helpful if you have a collection of models and you want to load a relation for all of them. Because with eager loading you run only one additional DB query instead of … Read more
Laravel >= 5.2: User::inRandomOrder()->get(); or to get the specific number of records // 5 indicates the number of records User::inRandomOrder()->limit(5)->get(); // get one random record User::inRandomOrder()->first(); or using the random method for collections: User::all()->random(); User::all()->random(10); // The amount of items you wish to receive Laravel 4.2.7 – 5.1: User::orderByRaw(“RAND()”)->get(); Laravel 4.0 – 4.2.6: User::orderBy(DB::raw(‘RAND()’))->get(); Laravel … Read more
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); });
It depends if you want to work with the user afterwards or only check if one exists. If you want to use the user object if it exists: $user = User::where(’email’, ‘=’, Input::get(’email’))->first(); if ($user === null) { // user doesn’t exist } And if you only want to check if (User::where(’email’, ‘=’, Input::get(’email’))->count() > … Read more
After save, $data->id should be the last id inserted. $data->save(); $data->id; Can be used like this. return Response::json(array(‘success’ => true, ‘last_insert_id’ => $data->id), 200); For updated laravel version try this return response()->json(array(‘success’ => true, ‘last_insert_id’ => $data->id), 200);
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
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