I have a tinyint column named 'status' in the database which is created by boolean function of migration class.
My problem is;
when i use where('status', '1') it works on my server but does not work in my localhost
when i use where('status', 1) it works in my localhost but does not work on my server
ps: i tried where('status', true), where('status', '=', 1) and where('status', '=', true) the results are always the same.
did you create the tables manually or using migrations? if migrations, did you use boolean or tinyint(1)?
Also check where you are setting this value and how?
As I mentioned above, it is generated with migrations and I used boolean method (as I mentioned above).
Localhost: mysql Ver 15.1 Distrib 10.0.20-MariaDB, for Linux (x86_64) using readline 5.1
Server: mysql Ver 15.1 Distrib 10.0.20-MariaDB, for Linux (x86_64) using readline 5.1
The problem is that it does not query at all.
Guys i realized something. Types of the every attributes are strings, which is not normal I suppose.
check your db schema. also consider using eloquent's attribute casting. so the status is always stored as an int rather than a string.
but still where status = 1 is the same as status = "1" if you are storing the status as string.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast