Cannot get the value from database in PHP

Question

I'm trying to get a value from database using the following code

    $request = Registrationrequest::where('course_id', $id)
                                   ->where('user_id', Auth::user()->id)
                                   ->where('registered', true)->count();

I'm using Laravel. I have a row with course_id = 4, user_id=3 and registered=true. When I var_dump each values separately, I'm confirming it. But when I use this where condition together, I'm not getting the count value as 1, instead getting 0.

I have another query where I use

$request = Registrationrequest::where('course_id', $id)
                                ->where('user_id', Auth::user()->id)
                                ->where('registered', false)->first();

This works perfect when the registered value is false.

Can anybody tell me where am I wrong?

Does it work if you set it to 1 instead of true, and 0 instead of false? — Sverri M. Olsen
– Sverri M. Olsen, Commented Dec 15, 2014 at 4:40
I found the problem. When I save the data, I saved registered as 'true' or 'false'. It has to be 1 or 0. When I changed all the false and true through out the code with 0 and 1, it worked. — user1012181
– user1012181, Commented Dec 15, 2014 at 4:42

Sverri M. Olsen · Accepted Answer · 2014-12-15 04:47:18Z

4

Change true with 1, and false with 0.

answered Dec 15, 2014 at 4:47

Sverri M. Olsen

13.2k3 gold badges38 silver badges54 bronze badges

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

2 Comments

user1012181 Over a year ago

Normally true and false should work. True is working. But not false case. Anyway, changing it to 1 and 0 works.

Sverri M. Olsen Over a year ago

It is because they are being cast to string. When boolean values are cast to string they are turned into: true = '1' and false = '' (empty string).

user1012181 · Accepted Answer · 2014-12-15 16:16:19Z

0

Changed all the false and true from the insert, delete and select queries.

$request = Registrationrequest::where('course_id', $id)
                                ->where('user_id', Auth::user()->id)
                                ->where('registered', 0)->first();

answered Dec 15, 2014 at 16:16

user1012181

8,72611 gold badges74 silver badges110 bronze badges

Collectives™ on Stack Overflow

Cannot get the value from database in PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related