CodeIgniter, how to return multiple queries from model to controller?

Question

I'm trying to get my model to return two queries, one for the data itself which are multiple records from the table 'Categories', and a count field, from the table 'Posts'.

I've tried alot of possible solutions, but so far none fixed it for me.

My view does work with the correct route /forum/$id, but loading the categories and a post count per category won't work.

Categories Controller:

$this->load->database();
$this->load->model("Categories_model");

$results=$this->Categories_model->getCategories();

$data=array('results'=>$results);

$this->load->view('Categories_view',$results);

Categories Model:

// this works if I only want to get all the categories  
// $query=$this->db->get('Categories');
// return $query->result();

$query1 = $this->db->get('Categories');
$query2 = $this->db->query("SELECT COUNT(*) AS rowCount FROM Posts");

$return array('categories' => $query1, 'count' => $query2);

Categories View:

<tbody>
    <?php foreach ($results['categories'] as $r):?>
        <tr>
            <td><a href="<?php echo site_url('forum'); ?>/<?=$r->CategorieId?>"><?=$r->Name?></a></td>
            <td><?=$r->rowCount?></td>
        </tr>
    <?php endforeach;?> 
</tbody>

When I load the Categories view, I get this error:

syntax error, unexpected 'array' (T_ARRAY), Filename: models/Categories_model.php

Can somebody help me with some sample code on how to do this, or a fix for my current code?

Thank you in advance!

Try using this $query1 = $this->db->get('Categories')->result(); $query2 = $this->db->query("SELECT COUNT(*) AS rowCount FROM Posts")->result(); Also include the full error message. and should be return not $return — Shaiful Islam
– Shaiful Islam, Commented Apr 29, 2015 at 12:44
Thanks for your quick reply, however I don't think it has anything to do with my queries, hence the error message I get. I think it's because it's not an array that I pass to the view? — StephanB
– StephanB, Commented Apr 29, 2015 at 12:46
I guess you need = after $return or may be you need return only without $ — M Khalid Junaid
– M Khalid Junaid, Commented Apr 29, 2015 at 12:48

Saty · Accepted Answer · 2015-04-29 12:49:43Z

3

return is wrong in your code remove $ from your return type

$return array('categories' => $query1, 'count' => $query2);

it should be

return array('categories' => $query1, 'count' => $query2);

answered Apr 29, 2015 at 12:49

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

2 Comments

StephanB Over a year ago

Wow that was dumb of me haha! Can you take a look into my View code? I need to also get data out of the $results['count'], but another foreach won't fix the problem cause it needs to get printed on the same table row.

Saty Over a year ago

@StephanB your $data array contain your array so you pass $data into view not $result $this->load->view('Categories_view',$data);

Rain · Accepted Answer · 2015-12-29 06:08:09Z

1

Running Transactions:
To run your queries using transactions you will use the $this->db->trans_start() and $this->db->trans_complete() functions as follows:

$this->db->trans_start();
$this->db->query('AN SQL QUERY...');
$this->db->query('ANOTHER QUERY...');
$this->db->query('AND YET ANOTHER QUERY...');
$this->db->trans_complete();

You can run as many queries as you want between the start/complete functions and they will all be committed or rolled back based on success or failure of any given query. Click here to see more

answered Dec 29, 2015 at 6:08

Rain

6016 silver badges10 bronze badges

Comments

Arcanyx · Accepted Answer · 2015-04-29 12:58:58Z

0

$query['categories'] = $this->db->get('Categories')->result_array();
$query['count']  = $this->db->query("SELECT COUNT(*) AS rowCount FROM Posts")->result();

return $query;

Try this. Not done anything great. Just used result_array() and result(). I hope they are compatible with your version of CI!!

answered Apr 29, 2015 at 12:58

Arcanyx

89010 silver badges25 bronze badges

2 Comments

StephanB Over a year ago

@saty fixed the (dumb) problem. Although I can't seem to find out how to get data out of the $results['count'] (in the view), I think another foreach won't fix the problem cause it needs to get printed on the same table row.

Arcanyx Over a year ago

Looking at your code the categories will be present in $categories and the count in $count. You can do print_r($categories) or print_r($count) and check it in your view!!

Collectives™ on Stack Overflow

CodeIgniter, how to return multiple queries from model to controller?

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related