[eluser]Thiago Leao[/eluser]
categoria_model
Code:
<?php
class Categoria_model extends Model{
function listar($id_category, $maximo, $inicio){
//$query = $this->db->get_where('products', array('id_category' => $id_category), $maximo, $inicio);
//return $query->result();
$this->db->select('*');
$this->db->from('products');
$this->db->join('pictures', 'pictures.id_products = products.id_products');
$this->db->where('id_category', $id_category);
$this->db->limit($inicio, $maximo);
$query = $this->db->get();
echo print_r($query);
}
function contaRegistros(){
return $this->db->count_all_results('products');
}
}
?>
categoria CONTROLLER
Code:
<?php
class Categoria extends Controller{
function __construct(){
parent::Controller();
}
function index($id_category){
$dados['titulo'] = 'Catalogo Collection - Sua coleção Online!';
$this->load->library('pagination');
$this->load->model('categoria_model');
$maximo = 20;
$inicio = $this->uri->segment(4,0);
$config['base_url'] = base_url() .'categoria/index/';
$config['uri_segment'] = 4;
$config['total_rows'] = $this->categoria_model->contaRegistros();
$config['per_page'] = $maximo;
$this->pagination->initialize($config);
$dados['paginacao'] = $this->pagination->create_links();
$dados['listar_category'] = $this->categoria_model->listar($id_category, $maximo, $inicio);
$this->load->model('home_model');
$dados['last_member'] = $this->home_model->listar_members();
$dados['categorys'] = $this->home_model->listar_category();
$this->load->view('categoria', $dados);
}
}
?>
VIEW
Code:
<div id="ver_categorias">
<ul>
<?php foreach($listar_category as $listar): ?>
<li><a href="#"><?=$listar->personagem;?></a></li>
<?php endforeach; ?>
</ul>
</div>
ERROR
CI_DB_mysql_result Object ( [conn_id] => Resource id #31 [result_id] => Resource id #44 [result_array] => Array ( ) [result_object] => Array ( ) [current_row] => 0 [num_rows] => 0 [row_data] => ) 1