Variables defined from a db connection go null right afterwards

An usual error has shown up in the application I am developing. When I query a database with Eloquent or a raw SQL query, I get the desired values, and they are stored in the desired variable. I know this because I can do a data dump to reveal what was retrieved. However, the immediate next instruction, whether a conditional or a variable, is to capture an extracted value from an object or any PHP code at all that interacts with the variable, the variable immediately goes 'null'. The app fails because it insists it is null, but dd() has shown that it is not.

For example, $commentData = Comments::find($commentId); // // dd($commentData); // if ($commentData === null) { // Log::error('No comment found for ID: ' . $commentId); // throw new \Exception("Comment not found for ID: $commentId");

Disregard the comment //s. When I run the command to get $commentData, the data dump shows me that it is a fully populated object I expect. However, immediately as it is compared to null, it throws the error that the comment was not found. However, it was there! I removed the conditional and went straight to: $FirstName = $commentData->FirstName;

However, that throws an error with something about trying to get a value from a null object. So, right after the value is obtained from the database, it goes null. This has happened three times now across the project. I have refactored the code to make what is going on clearer, but this did not help. Can anyone illuminate what the variable immediately loses its value when programmatically addressed? Thank you.

JussiMannisto

1 year ago

Level 50

Format your code blocks with three backtics (```). See an example here.

Tray2

1 year ago

Level 73

That sounds very odd, however, I suggest taking a look here, it will help you understand how Laravel works.

https://laracasts.com/series/30-days-to-learn-laravel-11

mypylon

1 year ago

Level 1

@Tray2 too rudimentary

Tray2

1 year ago

Level 73

@mypylon I think not, it covers all the basics, and this is a basic eloquent query.

However, Compare your code to this.

 public function show(Book $book)
 {
    return view('books.show')->with([
         'book' => $book,
    ]);
 }

This is what you want with your comment.

Please or to participate in this conversation.