本文整理匯總了PHP中app\Message::join方法的典型用法代碼示例。如果您正苦於以下問題：PHP Message::join方法的具體用法？PHP Message::join怎麽用？PHP Message::join使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\Message的用法示例。
在下文中一共展示了Message::join方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: index
/**
* Show the admin dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//Gets all the event details from the event table
$events = Event::orderBy('created_at', 'desc')->paginate(5, ['*'], 'events');
$pastevents = Event::onlyTrashed()->orderBy('deleted_at', 'desc')->paginate(5, ['*'], 'past');
//gets all messages from the messages table
$messages = Message::join('users', 'users.id', '=', 'messages.userid')->select('users.name', 'users.email', 'messages.*')->whereNull('deleted_at')->orderBy('created_at', 'desc')->paginate(5, ['*'], 'messages');
//gets all the read (deleted) messages from the messags table.
$readMessages = Message::join('users', 'users.id', '=', 'messages.userid')->select('users.name', 'users.email', 'messages.*')->whereNotNull('deleted_at')->onlyTrashed()->orderBy('created_at', 'desc')->paginate(5, ['*'], 'read');
//Returns the events view along with the $events, $messages and $readMessages arrays containing the query results from above
return view('admin/admin', ['events' => $events, 'pastevents' => $pastevents, 'messages' => $messages, 'readMessages' => $readMessages]);
}