Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

ZHoving's avatar

Raw query relationship trouble on view

In our controller we want to do the following query:

$query = "SELECT * FROM posts WHERE ";

the rest of the query will be filled with what the user filles out.

In our view we are trying to display the names of users that are assigned to the post whitch looks like this.

@php $allAssigned = ""; @endphp
@if($ticket->assignedUsers->count() > 1)                                
@foreach($ticket->assignedUsers as $medewerker)
@php $allAssigned .= $medewerker->user->name . ", " @endphp
@endforeach($gebruikers as $medewerker)
@else
@foreach($ticket->assignedUsers as $medewerker)
@php $allAssigned = $medewerker->user->name  @endphp
@endforeach($gebruikers as $medewerker)
@endif 

This is the error we get:

Undefined property: stdClass::$assignedUsers (View: /home/vagrant/code/Ready4It-Ticket/resources/views/posts/index.blade.php)

I hope someone can help us out on our problem.

Greetings,

Zervan

0 likes
3 replies
Braunson's avatar

The error says assignedUsersisn't a valid property.. Try dumping the $ticket param out to see what is there. Is it an object, array or collection?

Tray2's avatar

Since you don't share your model and controller it's hard to help. However try something like

$posts = Post::where($field, $value)->get();
return view(posts.index, compact('posts');

Or maybe $tickets but the SQL says posts so I went with that. And do as @Braunson suggested

ZHoving's avatar

Thank you for your response i will check both suggestions today!

Please or to participate in this conversation.