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); }