本文整理匯總了PHP中app\Article::join方法的典型用法代碼示例。如果您正苦於以下問題：PHP Article::join方法的具體用法？PHP Article::join怎麽用？PHP Article::join使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\Article的用法示例。
在下文中一共展示了Article::join方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: articlebyid
public function articlebyid($id)
{
// $articles = Article::find($id);
$articles = Article::join('users', 'users.id', '=', 'articles.autor')->select('users.name as autor', 'articles.title as title', 'articles.subtitle as subtitle', 'articles.message as message', 'articles.created_at as created_at', 'articles.id as id')->where('articles.id', $id)->get();
$comments = Article::join('comments', 'articles.id', '=', 'comments.article')->join('users', 'users.id', '=', 'comments.autor')->select('comments.message as comment', 'users.name as autor', 'users.image as image', 'comments.created_at as date')->where('articles.id', $id)->where('comments.ephemere', '>=', new \DateTime('today'))->get();
// return \view('Link/articlebyid')->with('articles', $articles); //on passe les information de l'articles récupéré par son id
return \view('Link/articlebyid', array('articles' => $articles, 'comments' => $comments));
}示例2: data
/**
* Show a list of all the languages posts formatted for Datatables.
*
* @return Datatables JSON
*/
public function data()
{
$news = Article::join('languages', 'languages.id', '=', 'articles.language_id')->join('article_categories', 'article_categories.id', '=', 'articles.article_category_id')->select(array('articles.id', 'articles.title', 'article_categories.title as category', 'languages.name', 'articles.created_at'))->orderBy('articles.position', 'ASC');
return Datatables::of($news)->add_column('actions', '<a href="{{{ URL::to(\'admin/news/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm iframe" ><span class="glyphicon glyphicon-pencil"></span> {{ trans("admin/modal.edit") }}</a>
<a href="{{{ URL::to(\'admin/news/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe"><span class="glyphicon glyphicon-trash"></span> {{ trans("admin/modal.delete") }}</a>
<input type="hidden" name="row" value="{{$id}}" id="row">')->remove_column('id')->make();
}示例3: data
/**
* Show a list of all the languages posts formatted for Datatables.
*
* @return Datatables JSON
*/
public function data()
{
$article = Article::join('languages', 'languages.id', '=', 'articles.language_id')->join('article_categories', 'article_categories.id', '=', 'articles.article_category_id')->select(array('articles.id', 'articles.title', 'article_categories.title as category', 'languages.name', 'articles.created_at'));
return Datatables::of($article)->add_column('actions', '<a href="{{{ URL::to(\'admin/article/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm iframe" >{{ trans("admin/modal.edit") }}</a>
<a href="{{{ URL::to(\'admin/article/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe">{{ trans("admin/modal.delete") }}</a>
<input type="hidden" name="row" value="{{$id}}" id="row">')->make();
}