laravel搜索作者

Question

A code that searches with the author to show the publisher and the author's name.

Controller

case "writer":
    $msgs = $this->communityModel->searchWriter($search); 
    // $boardCount = $community->searchWriterCount($search);
    break;

Model

public function searchWriter($search){
    return DB::table('users')
    ->select(['users.name','communities.num','communities.country','communities.title', 'communities.content','communities.hits','communities.commend','communities.created_at',])
    ->join('communities', 'communities.user_id', '=', 'users.id')
    ->where('users.name', 'like', '%' . $search . '%')
    ->get();
}

View

@foreach($msgs as $msg)
    <tr>
        <td style="width:60px;">{{$msg->num}}</td>
        <td style="width:50px;"><img src="{{$msg->country}}" alt="국적"></td>
        <td style="overflow:hidden;white-space:nowrap;text-overflow:ellipsis;">
            <a href="{{route('community.show',['boardNum'=>$msg->num,'search'=>$search,'where'=>$where,'page'=>$page])}}">
                {{$msg->title}}
            </a>
        </td>

        @if($where == 'writer')
        <td style="width:150px;">{{$msg->name}}</td>
        @else
        <td style="width:150px;">{{$msg->user->name}}</td>
        @endif
        <td style="width:60px;">{{date('m-d',strtotime($msg->created_at))}}</td>
        <td class="text-right" style="width:70px;">{{$msg->hits}}</td>
        <td class="text-right" style="width:70px;">{{$msg->commend}}</td>
        <td class="text-right" style="width:150px;"></td>
    </tr>

This is an error problem. Is there a solution?

<td style="width:150px;">{{$msg->user->name}}</td>

Answer 1

Welcome to stackOverflow!

You can just check for the existence of the relationship before using it:

<td style="width:150px;">{{$msg->user?$msg->user->name:""}}</td>