I am having a issue where when i write out a eloquent query using a variable it is returning NULL but if i write out that variable value in text it returns data.

This is my code

$code = 'Test123';

LiveProducts::where('code', $code)->first();

When i dump that query out i get NULL, but if i type it out like this:

LiveProducts::where('code', 'Test123')->first();

Then it will return data from the database.

I have dumped out the variable and it is defiantly a string.

I am having a issue where when i write out a eloquent query using a variable it is returning NULL but if i write out that variable value in text it returns data.

This is my code

$code = 'Test123';

LiveProducts::where('code', $code)->first();

When i dump that query out i get NULL, but if i type it out like this:

LiveProducts::where('code', 'Test123')->first();

Then it will return data from the database.

I have dumped out the variable and it is defiantly a string.

• php
• laravel
• laravel-5
• eloquent

Share Improve this question Follow edited Mar 26 at 18:46 Tim Lewis 29.3k1414 gold badges8080 silver badges107107 bronze badges Recognized by PHP Collective asked Mar 26 at 9:07 Adam AllenAdam Allen 20411 gold badge33 silver badges1212 bronze badges 9

• 2 Please keep in mind that Laravel 5 is EOL since nearly five years! – Nico Haase Commented Mar 26 at 9:22
• 2 For the reason Nico Haase specified, I don't have a Laravel 5 app available to test this, but in Laravel 10 and 11 running the query $uuid = '...', then Model::where('uuid', $uuid)->first() and Model::where('uuid', '...')->first() both return the same single result (I don't have a code column, but same idea)... I can't recreate this, and I have no idea why this would be an error in your code; that's the syntax I've been using for over a decade

  发布者：admin，转转请注明出处：http://www.yc00.com/questions/1744156353a4560880.html