Fetch the record for database using Codeigniter

Question

I am a beginner in Codeigniter framework and I am also learning from youtube

In my admin.php code is

<?php 
class Admin extends MY_Controller {
    public function dashboard(){
        $this->load->model('articlesmodel');
        $articles = $this->articlesmodel->articles_list();
        $this->load->view('admin/dashboard', ['articles'=> $articles]);
    }
}
?>

And in my dashboard.php code is

<table class="table">
    <thead>
        <th>Sr. No</th>
        <th>Title</th>
        <th>Action</th>
    </thead>
    <tbody>
        <?php if ( count($articles) ):?>
            <?php foreach($articles as $article): ?>
                <tr>
                    <td>1</td>
                    <td>
                        <?= $article->title ?>
                    </td>
                    <td>
                        <a href="" class="btn btn-info">Edit</a>
                        <a href="" class="btn btn-danger">Delete</a>
                    </td>
                </tr>
        <?php endforeach;  ?>
        <?php else:?>
            <tr>
                <td colspan="3">No Records Found</td>
            </tr>
        <?php endif;?>
    </tbody>
</table>

I am fetching the articles from my database in table format, but the following error is presented: Undefined variable: articles in dashboard.php page

Sajith Herath · Accepted Answer · 2018-12-20 13:32:01Z

2

change My_Controller to CI_Controller in Admin controller class definition.

When creating a controller class in Codeigniter, you should always extend CI_Controller class. Because $this->load() function is implemented in CI_Controller class. See the documentation

As a best practice create an array and pass it into view() function instead of initializing an array within view() function parameters. ex:

$data['articles'] = $this->articlesmodel->articles_list();
$this->load->view('admin/dashboard',$data);

edited Dec 20, 2018 at 13:32

answered Dec 20, 2018 at 10:46

Sajith Herath

1,0512 gold badges12 silver badges24 bronze badges

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

2 Comments

Ahil Khan Over a year ago

My_Controller is extends from CI_Controller

Sajith Herath Over a year ago

@AhilKhan Then you can use only whatever which are inside in the My_Controller class. In order to use load functions from the CI_Controller, you have to create a function inside the My_Controller which returns load function from the CI_Controller. Remember this kind of inheritance isn't a right way to do

Amir Khan · Accepted Answer · 2018-12-20 10:42:57Z

1

controller

change these lines

$articles = $this->articlesmodel->articles_list();

$this->load->view('admin/dashboard', ['articles'=> $articles]);

to this

$data['articles'] = $this->articlesmodel->articles_list();

$this->load->view('admin/dashboard',$data);

Tip: try to look at documentation syntax

https://www.codeigniter.com/user_guide/general/views.html

edited Dec 20, 2018 at 10:42

answered Dec 20, 2018 at 10:38

Amir Khan

4415 silver badges14 bronze badges

2 Comments

Amir Khan Over a year ago

try this $data['articles'] = $this->articlesmodel->articles_list(); echo "<pre>"; print_r ($data); echo "</pre>"; exit(); post the complete error also

Amir Khan Over a year ago

@AhilKhan check above answer well explained

Collectives™ on Stack Overflow

Fetch the record for database using Codeigniter

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related