Laravel query getting data even it doesn't match

Question

I have created a get request function that gets the id from the url http://localhost/user/list?id=1. And now as per testing, even though it has characters like http://localhost/user/list?id=1DFasdf, it retrieves the data values of column 1. I'm a bit confused to this one since I'm new to this issue:

public function lists(Request $request)
{
    // $id value is 1 or 1DFasdf
    $id = $request->id;
    dd($this->roomList->where('id', $id)->get());
}

so when I display the result with or without the dummy characters, it retrieves the data of column 1, but if I use other id (that is not existing in db) or characters first, it works as expected. How can I prevent this one from happening?

What is assigned to $this->roomList does it already contain some query setup ? — Mike
– Mike, Commented Nov 14, 2019 at 10:37

Prateik Darji · Accepted Answer · 2019-11-14 11:16:32Z

1

You should read about type juggling:-

public function lists(Request $request)
{
    // $id value is 1 or 1DFasdf
    $id = $request->id;
    dd($this->roomList->where('id','like', $id)->get());
}

edited Nov 14, 2019 at 11:16

Prateik Darji

2,3071 gold badge15 silver badges29 bronze badges

answered Nov 14, 2019 at 11:06

phpdroid

1,6631 gold badge19 silver badges37 bronze badges

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

Comments

Prateik Darji · Accepted Answer · 2019-11-14 11:15:05Z

1

MySQL considers the value as integer for field type is integer for e.g

if id = 2 and you enter id = "2test" the output will be the id match in the database, but if you put id = "test2" then it will returns nothing.

Also you can check the same thing in MySQL query.

Please check this question.

if you need to match exactly then first you need to cast that field as char in laravel.

$this->roomList->whereRaw("CAST(id AS CHAR(12))", $id)->get()

edited Nov 14, 2019 at 11:15

answered Nov 14, 2019 at 10:45

Prateik Darji

2,3071 gold badge15 silver badges29 bronze badges

Collectives™ on Stack Overflow

Laravel query getting data even it doesn't match

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related