Eloquent query returning null when using a variable

Question

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.

Answer 1

You can check with the following code as there may be some data value or data type matching issue with database column

$code = trim($code); // It will remove extra spaces
$code = (string) $code; // It will Ensure about string type value

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

Answer 2

What you show makes no sense. Regardless the Laravel version (as somebody pointed out is way outdated) a variable that equals the text is the same as writing the test.

If I assume that you have this code in your Controller, both should be in the same function and then send them to the view.

LiveProductController should look like this (I'd prefer this query instead):

public function getCode() {
    $code = 'Test123';
    $product = LiveProducts::query()
        ->where('code', $code)
        ->first();
    return view('liveproducts.index', compact('product'));
}

Then your liveproducts.blade.index should be able to access the variable thru blade

{{ $product }}