How to query a database from view - CodeIgniter

Question

I have query that runs in the controller:

$data['query'] = $this->Member->select_sql($id);    
$this->load->view('myform');

and then outputs data in the view:

foreach ($query->result() as $row):
   echo $row->post_title;
   echo $row->post_user_id;
endforeach;

So this outputs me a list of posts made by a user. Now I would like to run one more query that would for each post loop through my user table and output user information next to each post. (I dont want to select data from a view or joint those 2 tables at this time in MySQL)

Any ideas?

I'm not sure that this is such a good idea - the whole point of MVC is to enforce clean code structure. You're not supposed to have business logic in views. — Veeti
– Veeti, Commented Jan 15, 2010 at 23:33
this is only for a testing purpose, to concerning performance. thank you anyway. — Adnan
– Adnan, Commented Jan 15, 2010 at 23:52
@Veeti There is nothing wrong with calling upon the Model from the View. See stackoverflow.com/questions/1973221/… — Gordon
– Gordon, Commented Jan 16, 2010 at 10:29

Mihai MATEI · Accepted Answer · 2012-08-24 08:24:05Z

7

Although it is not a good practice, the "cleanest" approach would be as follows:

Grab the CI instance in the View
Load the model containing your desired data extraction query functions
Run the function from the model in the view

So, in the view:

$CI =& get_instance();
$CI->load->model('modelname');
$result = $CI->modelname->functionname();
var_dump($result);

Tested and working.

answered Aug 24, 2012 at 8:24

Mihai MATEI

5068 silver badges16 bronze badges

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

Comments

Gordon · Accepted Answer · 2010-01-15 23:30:56Z

5

Inject the database adapter or appropriate table object into the View.

From your code above, I'd assume this would be

$data['userModel'] = $this->User;

Then use it from there to run your query, e.g.

$user = $userModel->select_sql($row->post_user_id);

edited Jan 15, 2010 at 23:30

answered Jan 15, 2010 at 23:13

Gordon

318k76 gold badges548 silver badges566 bronze badges

Comments

Shailender Ahuja · Accepted Answer · 2019-11-20 06:48:29Z

0

Simply

<?php 
                        $qryd='select * from '.$tbname.'';
                        $queryd = $this->db->query($qryd);
                        $resultset = $queryd->result_array();
                    ?>

answered Nov 20, 2019 at 6:48

Shailender Ahuja

3121 gold badge3 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to query a database from view - CodeIgniter

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related