Top "Laravel-query-builder" questions

Laravel upsert operations with Query Builder

In one of the my worker scripts to store aggregate counts based on some metrics, I am not using Eloquent …

laravel laravel-5 eloquent query-builder laravel-query-builder

Laravel 5.4: Directly Subtract number from column in database

I want to subtract 100 number from credit column in database that is having int data type. I am looking for …

php mysql laravel laravel-5.4 laravel-query-builder

Laravel query builder where and or where

I want to build a query something like this: select * from users where id=1 AND address="USA" AND (status="active" …

mysql laravel-query-builder

Add lists() method in Query Builder in Laravel 5.4

I know the fact that Laravel has removed lists() function and moved functions signature as pluck(). But, this leads to …

php laravel eloquent laravel-query-builder pluck

Get Data from Multiple Tables Laravel

I am trying to build a coupon site in Laravel. Each merchant has their own deals/coupons. I have been …

php laravel laravel-5.2 laravel-query-builder

Laravel change date format in where clause to match Carbon::now()

I need to select entries based on dates happening in the future and the entries contain the date format: 12/30/17 I'm …

php laravel date-formatting laravel-query-builder

Laravel 4 query builder - with complicated left joins

I'm new to Laravel 4. I have this query: SELECT a.id, active, name, email, img_location, IFNULL(b.Total, 0) AS …

php mysql sql laravel-4 laravel-query-builder