How to run query on multiple values on single column in laravel 8

Question

I have used multi-select in laravel search. I want to search for data on multiple values. Here is my code

getting an array from the request

$req->state

Getting all the data from request

[
'DELHI','MAHARASHTRA','KARNATAKA',
]

$data = tbl_company::query()
                ->where(
                    "state",
                    [$req->state]
                )->paginate(100);

use whereIn laravel.com/docs/9.x/queries#additional-where-clauses — Aslam H
– Aslam H, Commented Aug 13, 2022 at 10:21
SQLSTATE[HY093]: Invalid parameter number GETTING THIS ERROR — swapnil mane
– swapnil mane, Commented Aug 13, 2022 at 10:22

swapnil mane · Accepted Answer · 2022-08-13 10:40:26Z

1

I was passing an arary inside an array and istead of where i wrote whereIn

$data = tbl_company::where(
                    "state",
                    [$req->state] //passing array inside an array
                )->paginate(100);

Answer

$data = tbl_company::query()
                ->whereIn(
                    "state",
                    $req->state
                )->paginate(100);

answered Aug 13, 2022 at 10:40

swapnil mane

27110 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to run query on multiple values on single column in laravel 8

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related