python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - laravel-query-builder

How to resolve ambiguous error in the query

I am using laravel framework for developing API's ,i have one query that is executed without where condition without any error i need to execute with where condition but it's throwing an error query s...
test-img

usersuser

mysql

sql

laravel

join

laravel-query-builder

Votes: 0

Answers: 1

Latest Answer

The problem is its consider as a column so that's why syntax error is coming,try following way it will resolve your problem select count(*) as aggregate from `users` left join `books` on `books`.`bo...
test-img

Sai Tarun

Laravel Eloquent Builder: Get selected columns

I have a object (Illuminate\Database\Eloquent\Builder) that have a (Illuminate\Database\Query\Builder) inside it. I dump the object and can see this: The image bellow, is a dd($querybuilder) from the ...
test-img

Fernando Annecchini

php

laravel

eloquent

laravel-query-builder

Votes: 0

Answers: 1

Latest Answer

If you want to get all the columns of the table: $query = Products::where('product_name', 'pencil')->get(); If you want to get a spesific column: $query = Products::where('product_name', 'pencil')...
test-img

Halil İbrahim Yücel

Laravel: How to count number of membership with respect to status and the package purchased

How to count the number of membership with respect to status and the package purchased? | Membership Status | | Package Type | Pending | Active | Cancellation ...
test-img

xyz

laravel

laravel-query-builder

Votes: 0

Answers: 1

Latest Answer

I don't sure what you mean by "and the package purchased", but if you want count with if or case condition, you can change COUNT to SUM and you must grouping your query. $data = \DB::table('...
test-img

Vieri Lusen

How to retrieve records by as a range (As1-As10) in laravel?

is there any possibility to retrieve records as a range.For an example there is a table with column as ref_numbers.Sample values for the ref_numbers are A1,A2,A3,A4....AB1,AB2,AB3,AB4... I want to re...
test-img

Yohan Danushka

php

laravel

eloquent

query-builder

laravel-query-builder

Votes: 0

Answers: 1

Latest Answer

You can use this where between operator. $data = DB::table('table_name') ->whereBetween('ref_numbers', ['A1', 'A10']) ->get(); or $data = DB::table('table_name') ...
test-img

S N Sharma

Posts

Questions

Blogs

Jobs