CODEWITHSUNDEEP
phpmysqlcodeigniter
Nana Partykar
Nana Partykar

Reputation: 10548

displaying data in table using codeigniter

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;
    }
}

Upvotes: 0

Views: 1184

Answers (3)

Syed mohamed aladeen
Syed mohamed aladeen

Reputation: 6755

remove $results = array(); in your code

Upvotes: 0

viral
viral

Reputation: 3743

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);

Upvotes: 1

Rijesh
Rijesh

Reputation: 1

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.

Upvotes: 0

Related Questions