To perform a “cross join” use the crossJoin method with the name of the table you wish to cross join to. Cross joins generate a Cartesian product between the first table and the joined table. Let’s create a crossJoin method…

The leftJoin method has the same signature as the join method. When I fetch all columns from the get-go, the query takes too load to complete (around 5 secs on 350k rows), whereas with a left join that’s cut into…

One such cool feature us using raw queries in laravel. These expressions will be injected into the query as strings but this is really helpful when you want to use raw expressions like aggregate functions. The queries can be executed…

The query builder also provides a variety of aggregate methods such as count, max, min, avg, and sum. You may call any of these methods after constructing your query. Aggregate method is a method where the values of multiple rows…

If you want to retrieve a collection containing the values of a single column, you may use the pluck method. Let’s create a pluck method in laravel 5 namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Http\Requests; use DB; class PostController extends Controller…

We can retrieve single row/column from the database table, you may use the first method. This method will return a single StdClass object. Let’s create a first method in laravel 5 namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Http\Requests; use DB; class…

We can retrieve all record in table to using table method on the DB facade to begin a query. Several methods to connect like, get(), first() etc, that helps to get table record using table method. Let’s create a table…

We can select the record using the DB facade with execute a select statement (select the record from the database), you may execute a query using named bindings. Let’s create a select Statement in laravel 5 namespace App\Http\Controllers; use Illuminate\Http\Request;…

We can delete the record using the DB facade with execute a delete statement (delete the record from the database). Like update, the number of rows affected by the statement will be returned. Let’s create a delete Statement in laravel…

We can update the record using the DB facade with execute an update statement. The number of rows affected by the statement will be returned. Let’s create an update Statement in laravel 5 namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Http\Requests; use…