+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: help me solve this problem (/showthread.php?tid=57772)
help me solve this problem - El Forum - 04-09-2013
[eluser]C_Line[/eluser]
Code:
----------
model
----------
function ambilreq(){
$qbidding = $this->db->query("select b.idbidding,b.idrfq,b.txstatbid,b.txnmbid,b.txbidtype
from bidding b where b.txstatbid = 'open'");
return $qbidding;
-------------
controller
-------------
function daftarbidding(){
$this->load->model("invmod",'',TRUE);
$data['qbidding'] = $this->invmod->ambilreq();
$this->load->view("listbidding",$data);
}
----------
view
----------
$qidbidding = $this->db->query("select count(idbidding) as cnt from joinrequest where idbidding = '$idbidding'")->result_array();
foreach($qidbidding as $row){
foreach($row as $key => $val){
if($val != NULL)
$jum = $val;
}
}
<td>".$idbidding."</td><td>".$i."</td><td>".$namabid."</td><td>".$tipe."</td><td>( ".$jum." / 5 )</td>;my problem is, i call model from view, i wan move the code that connect to database in view to model but i dun know how to do it, anyone can help me solve this problem, thx before..
help me solve this problem - El Forum - 04-10-2013
[eluser]TheFuzzy0ne[/eluser]
Create a method in your model with a meaningful name, and have it pass back the data you need to your controller, so you can pass it into your view.
I don't quite understand what your app does, so I can't really make a suggestion. Since you're already doing this with one of your queries, I don't understand why you can't with the other.