[eluser]Asinox[/eluser]
Hi, i want to display all articles and group_by and sort_by, well i get all articles but y get too php error...why?
errors :
Code:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: query
Filename: views/front_view.php
Line Number: 19
----------------------------------------------
A PHP Error was encountered
Severity: Warning
Message: Invalid argument supplied for foreach()
Filename: views/front_view.php
Line Number: 19
my controller function (function articulos)
Code:
class Front extends Controller{
function Front(){
parent::Controller();
$this->load->model(""); // header
$this->load->model(""); // columna derecha
$this->load->model(""); // columna central
$this->load->model(""); // columna izquierda
$this->load->model(""); // pie
$this->load->helper('url');
$data['SITE_TITULO'] = 'Paso a Paso Online';
$this->load->view('front_view', $data);
}
function index(){
$this->load->helper('url');
$this->articulos(); // por defecto muestra todos los articulos
}
function articulos() { //listar todos los articulos
$this->load->database();
$this->load->model('front_model','', TRUE);
$data['query'] = $this->front_model->get_articulos();
$this->load->view('front_view',$data);
}
/*function leer($id=false){ //lee articulo particular
if (!$id) redirect('front/articulos');
$this->load->model('articulos/articulos_model','', TRUE);
$data['articulo'] = $this->front_model->get_articulo($id);
$this->load->view('leer_view',$data);
}*/
}
my model
Code:
class Front_model extends Model{
function Front_model(){
parent::Model();
}
function get_articulos(){
$this->db->select('*');
$this->db->from('articles',0,30);
$this->db->join('comments', 'comments.id_comment = articles.id');
$this->db->join('categories', 'categories.id = articles.category_id');
$this->db->group_by('categoria');
$this->db->order_by('articles.id','desc');
$query = $this->db->get();
//return $query->result();
foreach($query->result_array() as $row){
$result[] = $row;
}
return $result;
}
}
my view
Code:
<?php foreach ($query as $row): ?>
<span><?php echo anchor('front/leer/'.$row['id'],$row['titulo']);?></span>
<span><?php echo $row['intro'];?></span>
<span><?php echo $row['categoria'];?></span>
<?php endforeach; ?>
Please where is my problem?