Laravel: DB where return true when compare to (boolean)false

Question

Why when I pass false to Model::where() and then trying to get first() element it always returns me first element instead of null?

Example:

I have Referrer model with hash_id = 123aSd456fGh

and I try to get this like below:

$requestReferrer = false;

$referrer = Referrer::where('hash_id', $requestReferrer)->first();
dd($referrer); // returns first Referrer model with hash_id = 123aSd456fGh

FYI

when I pass null in exchange for false it returns null.

Why are you using false? It seems null would be most suitable for this use case? Then you can do ->whereNull('hash_id') . — Kyle Wardle
– Kyle Wardle, Commented Jul 5, 2019 at 9:02
$requestReferrer cames form HTTP request and I don't know what value it has. Anyway. The main question is why it works like that and can I prevent these situations in the feature. — Witold Tkaczyk
– Witold Tkaczyk, Commented Jul 5, 2019 at 9:07

Arun J · Accepted Answer · 2019-07-05 09:22:23Z

1

Reason: SQL Server will automatically change the bit value to the varchar value of true or false.

The following works there:

$requestReferrer=false;
$referrer = Referrer::where('hash_id', "$requestReferrer")->first();

Or

$requestReferrer = 'false';
$referrer=Referrer::where('hash_id',$requestReferrer)->first();

edited Jul 5, 2019 at 9:22

answered Jul 5, 2019 at 8:56

Arun J

6834 gold badges15 silver badges27 bronze badges

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

2 Comments

Witold Tkaczyk Over a year ago

It will work but I wonder why it works like that and can I prevent these situations in the feature. Passing null works too, it's not the point

Arun J Over a year ago

I have updated my answer. For clarity check the same where condition you have used with different column of datatype interger/decimal etc

Collectives™ on Stack Overflow

Laravel: DB where return true when compare to (boolean)false

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related