เว็บบอร์ด PHP เว็บส่งเสริมการเรียนรู้ Hosting CRM ERP Server Programming ถาม-ตอบปัญหา

โค้ด: เลือกทั้งหมด

else {

            $pagination = $phpbb_container->get('pagination');
            $start = request_var('start', 0);
           
             $per_page = request_var('per_page', $config['topics_per_page']); 
            
            $sql_ary = array(
                        'SELECT'    => '*',
                        'FROM'      => array(
                                $table_prefix.'thailand'        => 't',
                                ),
                        );
//                        print_r($sql_ary);   
            $sql = $db->sql_build_query('SELECT', $sql_ary);
//             echo $sql;exit;
            $result = $db->sql_query_limit($sql, $per_page, $start);
          
            //    $result = $db->sql_query_limit($sql, 20, 20);
            while ($row = $db->sql_fetchrow($result)) {
                //print_r($row);
                $id = $row['id'];
                $province = $row['province'];
                $district = $row['district'];
                $subdistrict = $row['subdistrict'];
                $zipcode = $row['zipcode'];
                $this->template->assign_block_vars('m_thai', array(
                    'ID' => $id,
                    'PROVINCE' => $province,
                    'DISTRICT' => $district,
                    'SUBDISTRICT' => $subdistrict,
                    'ZIPCODE' => $zipcode,
                ));
            }
            $sql_ary['SELECT'] = 'COUNT(t.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);
           
            
            }
 

โค้ด: เลือกทั้งหมด

$sql = 'SELECT a.*, u.username, u.user_colour, t.topic_title
                    FROM ' . ATTACHMENTS_TABLE . ' a
                    LEFT JOIN ' . USERS_TABLE . ' u ON (u.user_id = a.poster_id)
                    LEFT JOIN ' . TOPICS_TABLE . " t ON (a.topic_id = t.topic_id)
                    WHERE a.is_orphan = 0
                        $limit_filetime
                    ORDER BY $sql_sort_order";
                $result = $db->sql_query_limit($sql, $sql_limit, $sql_start); 

โค้ด: เลือกทั้งหมด

 $pagination = $phpbb_container->get('pagination'); 
             $start  = request_var('start',0);
            $per_page = request_var('per_page', $config['topics_per_page']);
             $result = $db->sql_query_limit($sql, $per_page, $start);
             
               $sql_ary = array(
                        'SELECT id,province,district,subdistrict,zipcode 
                            FROM '      => array(
                                $table_prefix . 'thailand'  => 't',
                                ),
                        );
               $sql = $db->sql_build_query('SELECT', $sql_ary)

โค้ด: เลือกทั้งหมด

 $sql_ary = array(
                        'SELECT'    => '*',
                        'FROM'      => array(
                                FORUMS_TABLE         => 'f',
                                ),
                        );
                        $sql = $db->sql_build_query('SELECT', $sql_ary);
                        $result = $db->sql_query_limit($sql, $per_page, $start); 

โค้ด: เลือกทั้งหมด

else {
          
        //    $sql =  'SELECT province,district,subdistrict,zipcode 
        //FROM ' . $table_prefix . 'thailand';

            $pagination = $phpbb_container->get('pagination'); 
             $start  = request_var('start',0);
            $per_page = request_var('per_page', $config['topics_per_page']);
             $result = $db->sql_query_limit($sql, $per_page, $start);
             
               $sql_ary = array(
                        'SELECT id,province,district,subdistrict,zipcode 
                            FROM '      => array(
                                $table_prefix . 'thailand'  => 't',
                                ),
                        );
               $sql = $db->sql_build_query('SELECT', $sql_ary);
        //    $result = $db->sql_query_limit($sql, 20, 20);
            while ($row = $db->sql_fetchrow($result)) {
                //print_r($row);
                $id =  $row['id'];  
                $province = $row['province'];
                $district = $row['district'];
                $subdistrict = $row['subdistrict'];
                $zipcode = $row['zipcode'];
                $this->template->assign_block_vars('m_thai', array(
                    'ID' => $id,
                    'PROVINCE' => $province,
                    'DISTRICT' => $district,
                    'SUBDISTRICT' => $subdistrict,
                    'ZIPCODE' => $zipcode,
                ));
            }
            $sql_ary['SELECT'] = 'COUNT(t.id) as total_id'; 
            $total_id = $db->sql_fetchfield('total_id');
              $base_url =  $this->m_action ; 
              $pagination->generate_template_pagination($base_url, 'pagination', 'start', $total_id,$per_page,$start); 
        }