Skip to content

Instantly share code, notes, and snippets.

@YuriFontella
Created October 23, 2014 15:30
Show Gist options
  • Save YuriFontella/e4c184b11332ab1f0154 to your computer and use it in GitHub Desktop.
Save YuriFontella/e4c184b11332ab1f0154 to your computer and use it in GitHub Desktop.
Model, View e Controller Categoria e os itens dessa categoria
//MODEL
public function categorias_item() {
$loja = $this->load->database('loja', TRUE);
$query = $loja->query("SELECT * FROM categorias ORDER BY categoria ASC");
foreach($query->result_array() as $row) {
$categoria = $row['categoria'];
$matriz[$categoria]['categoria'] = $categoria;
$matriz[$categoria]['itens_principais'] = $this->itens_categoria($categoria);
}
return $matriz;
}
public function itens_categoria($categoria) {
$loja = $this->load->database('loja', TRUE);
$query = $loja->query("SELECT * FROM itens WHERE categoria = '$categoria');
return $query->result();
}
//CONTROLLER
$data['categorias_item'] = $this->model->categorias_item();
//VIEW
{categorias_item}
<h4>{categoria}</h4>
{itens_principais}
<div class="pull-left">{item}</div>
{/itens_principais}
{/categorias_item}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment