$schools = Db::name('schools')->alias('a')->field('a.id,left(a.school_name,12) as school_name,a.school_img,a.is_authentication,a.hot_number,a.label,left(a.hot_major,18) as hot_major,city.city_name,substring(a.school_address,15)')
->join('__SEARCH_CITY__ city', 'city.id=a.city_id')
->where('a.city_id',$cityId)
->where($where)->order('a.id','desc')->paginate(10);
}
//var_dump($schools);
if(!empty($schools)){
$data = $schools->items();
foreach ($data as $key => &$value) {
//$temp = $value;
$value['school_address'] = mb_substr($value['school_address'],1,10,'utf-8');
$value['school_name'] = mb_substr($value['school_name'],1,10,'utf-8');
}
//$schools->data = (Object)$data;
//unset($schools->data);
} 最佳答案
