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…

We can insert the record using the DB facade with execute an insert statement. This method takes the raw SQL query as its first argument and bindings as its second argument. Let’s create an insert Statement in laravel 5 namespace…

In this article, i share with you that how to use date_format() with where condition of Laravel query builder.When i was working on my project, i require to search with get only selected month, year and date records from created_at(timestamp)…

If you want to get duplicate values count in an comma separated string in laravel 8, first need to create array using explode function. Count duplicate value in array using below function. The array_count_values() function counts all the values of…