编码点火器中的分页。传递给模型的额外值集和 db->limit 不起作用

Question

codeigniter分页。我似乎不能在每个页面上设置帖子的限制(它会在每个页面上显示所有帖子)。我认为链接正在工作(它们显示在uri上)，但它们不选择每页的行。

模型:

public function index(  $limit,$start,      $var1,$var2,$var3,$var4 ){
$sql = "SELECT 
        trabalho.var1
        trabalho.var2
        empregos.var3
        empregos.var4
        FROM trabalho.empregos
        JOIN trabalho.empresas
        ON empregos.id_empresa = empresas.id_empresa
        WHERE  
           trabalho.var1 LIKE ?
        OR trabalho.var2 LIKE ?
        OR empregos.var3 LIKE ?
        OR empregos.var4 LIKE ?
        ;";
 $variables_form = array($var1,$var2,$var3,$var4);
$this->db->limit($limit, $start);
$query2 = $this->db->query($sql,$variables_form);
return $query2->result();
}

控制器:

$config['base_url'] = base_url().'index.php/main_controller/index';
$config['total_rows'] = 10;
$config['per_page'] = 5;
$config['num_links'] = 2;
$config["uri_segment"] = 3;
$config['use_page_numbers'] = TRUE;
$this->pagination->initialize($config);
$page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;
$data["info"] = $this->search_display_m->
                    index($config["per_page"], $page, 
                    $var1 = 'a', $var2 = 'a', 
                    $var3 = 'a', $var4 = 'a',
                    );
$data["links"] = $this->pagination->create_links();

和view:

<?php echo $this->pagination->create_links(); ?>

是否有一种方法来简化uri?

Answer 1

可以了

public function index(  $limit,$start,      $var1,$var2,$var3,$var4 ){
$sql = "SELECT 
        trabalho.var1
        trabalho.var2
        empregos.var3
        empregos.var4
        FROM trabalho.empregos
        JOIN trabalho.empresas
        ON empregos.id_empresa = empresas.id_empresa
        WHERE  
           trabalho.var1 LIKE ?
        OR trabalho.var2 LIKE ?
        OR empregos.var3 LIKE ?
        OR empregos.var4 LIKE ?
        limit $start, $limit
    ;";
 $variables_form = array($var1,$var2,$var3,$var4);
 $query2 = $this->db->query($sql,$variables_form);
 return $query2->result();
}