CodeIgniter Forums
Pagination tutorial -> i`m needing help! - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Pagination tutorial -> i`m needing help! (/showthread.php?tid=2852)



Pagination tutorial -> i`m needing help! - El Forum - 08-28-2007

[eluser]rafael apocalypse[/eluser]
Hello!

I'm trying to use pagination in my app. But just with the user guide, I couldn't find how to set it up.

In my controller I have this code
Code:
//Load the CI LIbraries we need for this functuon
      $this->load->library('table');
      $this->load->library('pagination');
      
          $this->load->model('admin/dominio');
          $dominios = $this->dominio->get_pai();
      
      $rows = $dominios['num_rows'];
      
      //Config for Pagination including getting the total number rows in DB
      $config['base_url'] = base_url().'admin/dominios/index/';
      $config['total_rows'] = $rows;
      $config['per_page'] = '25';
      $config['uri_segment'] = '3';
      $config['num_links'] = '2';
      $this->pagination->initialize($config);
      
            $output = "<table>
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>área temáticas</th>
                                            <th>filhos</th>
                                            <th>traduções</th>
                                            <th>traduzir</th>
                                            <th>termos</th>
                                            <th>ver +</th>
                                            <th>editar</th>
                                            <th>excluir</th>
                                        </tr>
                                    </thead>
                                    <tbody>";
            //contador para efeito zebra
            $counter = 0;
            foreach($dominios['result'] as $dominio):

                //lista as subcategorias
                $id = $dominio->id_dominio;
                $filhos = $this->dominio->get_child($id);

                //lista a quantidade de termos em um domínio
                $this->load->model('admin/termo');
                $termos = $this->termo->count_termos($id);

                $traducoes = $this->dominio->traducoes($id);

                if($counter == 0): $class = 'class="odd"'; $counter++; else: $class = 'class=""'; $counter = 0; endif;
                $output .= "<tr ".$class.">";
                    $output .= "<td>".$dominio->id_dominio."</td>";
                    $output .= "<td>".$dominio->dominio."</td>";
                    $output .= "<td>".$filhos['rows']."</td>";
          $output .= "<td>".$traducoes."</td>";
          $output .= "<td>".anchor('admin/dominios/traduz/'.$id, 'traduzir')."</td>";
                    $output .= "<td>".$termos."</td>";
                    $output .= "<td>".anchor('admin/dominios/vermais/'.$id, 'ver +')."</td>";
                    $output .= "<td>".anchor('admin/dominios/edit/'.$id, 'editar')."</td>";
                    $output .= "<td>".anchor('admin/dominios/del/'.$id, 'excluir')."</td>";
                $output .= "</tr>";
           endforeach;
            $output .= "</tbody>
                            </table>";
                            
            $output .= $this->pagination->create_links();

            return $output;

in this controller I use a model to get some data from db. Well the pagination are being made ok, but it doesn't work.

My model are
Code:
function get_pai(){
            $this->db->where('father is null');
            $this->db->where('original', 0);
            $query = $this->db->get('dominio');
            $result['result'] = $query->result();
      $result['num_rows'] = $query->num_rows();
      
            return $result;
        }

Is there anybody who can help me, or send me a real tutorial on pagination with CI?

Thanks

RA


Pagination tutorial -> i`m needing help! - El Forum - 08-28-2007

[eluser]gunter[/eluser]
This ist the place to go: Godbit Pagination Tutorial