โดย M030 » 21/10/2015 4:30 pm
M030 เขียน:ขอดูวิธีการดึงข้อมูลเป็นทอดๆหน่อยได้มั้ยค่ะ
ได้แล้วค่ะ ผิดที่ syntax เกินค่ะ
โค้ด: เลือกทั้งหมด
$pagination = $phpbb_container->get('pagination');
$start = request_var('start', 0);
$per_page = request_var('per_page', 20);
$sql_ary = array(
'SELECT' => 'p.PROVINCE_NAME,u.AMPHUR_NAME,t.DISTRICT_NAME,u.POSTCODE ',
'FROM' => array(
'mod_province' => 'p',
'mod_amphur' => 'u',
'mod_district'=> 't'
),
'WHERE' => 'p.PROVINCE_ID = u.PROVINCE_ID
AND u.AMPHUR_ID = t.AMPHUR_ID ',
);
$sql = $db->sql_build_query('SELECT', $sql_ary);
$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(
'ID' => $id,
'PROVINCE' => $province,
'DISTRICT' => $district,
'SUBDISTRICT' => $subdistrict,
'ZIPCODE' => $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);
[quote="M030"]ขอดูวิธีการดึงข้อมูลเป็นทอดๆหน่อยได้มั้ยค่ะ[/quote]
ได้แล้วค่ะ ผิดที่ syntax เกินค่ะ
[code=php]
$pagination = $phpbb_container->get('pagination');
$start = request_var('start', 0);
$per_page = request_var('per_page', 20);
$sql_ary = array(
'SELECT' => 'p.PROVINCE_NAME,u.AMPHUR_NAME,t.DISTRICT_NAME,u.POSTCODE ',
'FROM' => array(
'mod_province' => 'p',
'mod_amphur' => 'u',
'mod_district'=> 't'
),
'WHERE' => 'p.PROVINCE_ID = u.PROVINCE_ID
AND u.AMPHUR_ID = t.AMPHUR_ID ',
);
$sql = $db->sql_build_query('SELECT', $sql_ary);
$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(
'ID' => $id,
'PROVINCE' => $province,
'DISTRICT' => $district,
'SUBDISTRICT' => $subdistrict,
'ZIPCODE' => $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);
[/code]