本文整理匯總了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));
}