本文整理汇总了PHP中Companies::join方法的典型用法代码示例。如果您正苦于以下问题：PHP Companies::join方法的具体用法？PHP Companies::join怎么用？PHP Companies::join使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Companies的用法示例。
在下文中一共展示了Companies::join方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: listItem
/**
* Display a listing of the resource.
*
* @return Response
*/
public function listItem()
{
$currUser = Auth::user()->id;
$oQuery = Companies::join('cities', 'cities.id', '=', 'city_id')->join('regions', 'regions.id', '=', 'cities.region_id')->join('country', 'country.id', '=', 'regions.country_id')->join('users', 'users.id', '=', 'companies.user_id')->select('companies.id as id', 'companies.phone', 'companies.email', 'companies.name', 'companies.web_site', 'companies.description', 'regions.name as region_name', 'regions.id as region_id', 'country.name as country_name', 'users.name as user_name', 'cities.name as city_name');
$aCompany = $oQuery->paginate(10);
return View::make('/company/list', array('aCompany' => $aCompany));
}