All pastes #835290 Raw Edit

Stuff

public text v1 · immutable
#835290 ·published 2007-12-28 20:11 UTC
rendered paste body
function catalogo($id = "none", $pag =  "none"){

                        $this->load->library('pagination');

                if (is_numeric($id)) {

                $config['base_url'] = base_url().'index.php/inicio/catalogo/'.$id.'/';
                $sql = $this->db->query("SELECT COUNT(*) AS num FROM producto WHERE catid = '$id'");
                $row = $sql->row();
                $config['total_rows']= $row->num;
                $config['per_page'] = 10;
                $this->pagination->initialize($config);



                if (is_numeric($pag)){

                        $contenido['productos'] = $this->db->query('SELECT * FROM producto WHERE
catid='.$id.' ORDER BY catid ASC LIMIT '.$pag.' , '.$config['per_page']);

                } else {

                        $contenido['productos'] = $this->db->query('SELECT * FROM producto WHERE
catid='.$id.' ORDER BY catid ASC LIMIT  0 , '.$config['per_page']);

                }




                $contenido['titulo'] = $this->db->query("SELECT * FROM categorias WHERE id='$id'");
                $contenido['paginado'] = $this->pagination->create_links();
                $template['contenido'] = $this->load->view('catalogo',$contenido,true);

                } else {
                        $contenido['productos'] = $this->db->query("SELECT * FROM categorias ORDER BY id");
 }




                $contenido['titulo'] = $this->db->query("SELECT * FROM categorias WHERE id='$id'");
                $contenido['paginado'] = $this->pagination->create_links();
                $template['contenido'] = $this->load->view('catalogo',$contenido,true);

                } else {
                        $contenido['productos'] = $this->db->query("SELECT * FROM categorias ORDER BY id");
                        $template['contenido'] = $this->load->view('categoria',$contenido,True);
                }

                $template['articulos'] = $this->db->query("SELECT * FROM temas ORDER BY id DESC");
                $this->load->view('main',$template);


        }