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…

The query builder can also select existing records using the select method, you can specify a custom select clause for the query. $getdetail = DB::table(‘search_logs’) ->select(‘shape’, ‘color’, ‘cut’) ->get();

You can build your query step-by-step and then call get() method. But sometimes it gets a little tricky for more complicated queries – for example, if you have multiple whereIn OR whereIn conditions and you want to put brackets, do…

Just today, I was looking at using a ternary operator in Laravel’s Blade templating system. However, instead of writing a ternary statement, Blade provides you with the following convenient short-cut: {{ $string or ‘something’ }} In this example, if the…

Most of the time my clients need to download data from their database tables. Today, I decided to make a very small controller that is portable and efficient for exporting full MySQL tables to Excel using PHPExcel in laravel 8.…

The query builder may also be used to write join statements. To perform a basic “inner join”, you may use the join method on a query builder instance. The first argument passed to the join method is the name of…

The query builder may also be used to delete records from the table via the delete method. You may constrain delete statements by adding where clauses before calling the delete method. DB::table(‘cart_products’)->where(‘id’, ‘=’, $cart_id)->delete();

The query builder can also update existing records using the update method. The update method, like the insert method, accepts an array of column and value pairs containing the columns to be updated. $query_update = DB::table(‘cart_products’) ->where(‘user_id’, $id) ->update([‘status’ =>…