Welcome Guest, Not a member yet? Register   Sign In
Show result but i got a php error..why?
#1

[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>&lt;?php echo anchor('front/leer/'.$row['id'],$row['titulo']);?&gt;</span>
    <span>&lt;?php echo $row['intro'];?&gt;</span>
    <span>&lt;?php echo $row['categoria'];?&gt;</span>

&lt;?php endforeach; ?&gt;

Please where is my problem?


Messages In This Thread
Show result but i got a php error..why? - by El Forum - 06-30-2008, 01:00 AM
Show result but i got a php error..why? - by El Forum - 06-30-2008, 02:43 AM
Show result but i got a php error..why? - by El Forum - 06-30-2008, 03:00 AM
Show result but i got a php error..why? - by El Forum - 06-30-2008, 03:03 AM



Theme © iAndrew 2016 - Forum software by © MyBB