โค้ด: เลือกทั้งหมด
$pagination = $phpbb_container->get('pagination');
$start = request_var('start', 0);
$per_page = request_var('per_page', 20);
$sql_ary = array(
'SELECT' => 'p.PROVINCE_ID, p.PROVINCE_CODE, p.PROVINCE_NAME, u.AMPHUR_ID,'
. 'u.AMPHUR_CODE, u.AMPHUR_NAME, u.POSTCODE, u.PROVINCE_ID,'
. 't.DISTRICT_ID, t.DISTRICT_CODE, t.DISTRICT_NAME, t.AMPHUR_ID, '
. 't.PROVINCE_ID',
'FROM' => array(
'mod_province' => 'p',
'mod_amphur' => 'u',
'mod_district'=> 't'
),
'WHARE' => 'p.PROVINCE_ID = u.PROVINCE_ID'.'AND u.AMPHUR_ID = t.AMPHUR_ID ',
);
$sql = $db->sql_build_query('SELECT', $sql_ary);
// print_r ($sql); exit;
$result = $db->sql_query_limit($sql, $per_page, $start);
while ($row = $db->sql_fetchrow($result)) {
$id = $row['PROVINCE_ID'];
$province = $row['PROVINCE_NAME'];
$district = $row['AMPHUR_NAME'];
$subdistrict = $row['DISTRICT_NAME'];
$zipcode = $row['POSTCODE'];
$this->template->assign_block_vars('m_thai', array(
'PROVINCE_ID' => $id,
'PROVINCE_NAME' => $province,
'AMPHUR_NAME' => $district,
'DISTRICT_NAME' => $subdistrict,
'POSTCODE' => $zipcode,
));
}
$sql_ary['SELECT'] = 'COUNT(t.DISTRICT_ID) as total_id';
$sql = $db->sql_build_query('SELECT', $sql_ary);
$result = $db->sql_query($sql);
$total_id = $db->sql_fetchfield('total_id');
$base_url = generate_board_url() . '/app.' . $this->php_ext . '/m_thaipost';
$pagination->generate_template_pagination($base_url, 'pagination', 'start', $total_id, $per_page, $start);