displaying data in table using codeigniter

Question

table is not displaying any value in table. When i did var_dump($results). It printed NULL. Since, i am new to codeigniter, i am not able to solve this problem. I'm not getting, where i did mistake. Help Me.

View Page

 <tbody>
                    <?php
                    if(!empty($results) ) {
                        foreach($results as $row) {
                        echo '<tr>';
                        echo '<td>'." ".'</td>';
                        echo '<td>'.$row->FileTitle.'</td>';
                        echo '<td>'.$row->UploadedFile.'</td>';
                        echo '<td>'.$row->CreationDate.'</td>';
                        echo '<td>'.$row->UpdateDate.'</td>';
                        echo '<td>'." ".'</td>';
                        echo '</tr>';
                        }
                    }?>
                </tbody>

Controller

class Welcome extends CI_Controller {
public function __construct()
        {
                parent::__construct();
                $this->load->model('news_model');

        $this->load->helper('form');
        $this->load->library('form_validation');

        }
public function member_CAttachments()
    {
         $data['results'] = $this->news_model->member_MAttachments(); 
         $this->load->view('member/templates/header');
         $this->load->view('member/index',$data);
         $this->load->view('member/templates/footer');
        }
}

Model

class News_model extends CI_Model 
{

        public function __construct()
        {
                $this->load->database();
        }
     public function member_MAttachments()
    {
        $results = array();

            $query = $this->db->get('MemberFileDetails');

            if($query->num_rows() > 0)
        {
                $results = $query->result();
            }

            return $results;
    }
}

I think you are not getting any result from your query!!check result present in your database or not!! — Saty
– Saty, Commented Aug 21, 2015 at 9:57
$data['results'] print in controller and check that you are getting any result or not also $query->num_rows() print it — shafiq.rst
– shafiq.rst, Commented Aug 21, 2015 at 9:58
@syedmohamed: yeah. thank you. got it. Sorry all, i wasted all your time. In url, some different view was getting called. i didn't saw that. Just now, i discovered it. i changed to localhost/Project/index.php/welcome/member_CAttachments Previously it was localhost/Project/index.php/welcome/check_login So, i changed code their in check_login controller. I made it redirect to this page. Thank You Everyone. Sorry For Wasting all your important time. Embarass. — Nana Partykar
– Nana Partykar, Commented Aug 21, 2015 at 10:08

Viral · Accepted Answer · 2015-08-21 10:12:45Z

1

Instead you can do it in fewer lines with inbuilt CI Table library,

supports both 2.2 and 3.x versions.

Use it like,

$this->load->library('table');

$this->table->set_heading('FileTitle', 'UploadedFile', 'CreationDate', 'UpdateDate');

$query = $this->db->query('SELECT * FROM MemberFileDetails');

echo $this->table->generate($query);

answered Aug 21, 2015 at 10:12

Viral

3,7531 gold badge20 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nana Partykar Over a year ago

Wow. Is it. Nice. Let me use this. Thank you.

Saty · Accepted Answer · 2015-08-21 10:00:14Z

0

do you have records in your table ? if yes then please try to remove the

if($query->num_rows() > 0) condition in the model and try.

edited Aug 21, 2015 at 10:00

Saty

22.5k7 gold badges35 silver badges52 bronze badges

answered Aug 21, 2015 at 9:59

Rijesh

13 bronze badges

Comments

Saty · Accepted Answer · 2015-08-21 10:37:39Z

0

remove $results = array(); in your code

edited Aug 21, 2015 at 10:37

Saty

22.5k7 gold badges35 silver badges52 bronze badges

answered Aug 21, 2015 at 10:09

Syed mohamed aladeen

6,8134 gold badges36 silver badges60 bronze badges

Collectives™ on Stack Overflow

displaying data in table using codeigniter

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related