+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Can't Get the result of a query in a view (/showthread.php?tid=44560)
Can't Get the result of a query in a view - El Forum - 08-18-2011
[eluser]Unknown[/eluser]
Hi Guys , what i'm doing is :
in model :
Code:
class user_model extends CI_Model{
public function getusers($input){
$query=$this->db->query("select u.code as ucode,u.level as ulevel,u.code_entite as uentite,u.name as uname,u.date_aff as udate
,e.code as ecode,e.nom_entite as entite FROM ci_users as u
inner join entite as e on (u.code_entite=e.code) where u.level = '".$input."'");
$row = $query->row_array();
return $row;
}
}Code:
class getusers extends CI_CONTROLLER {
public function arali(){
for($i=0;$i<count($_POST["idLevel"]);$i++){
$user=$this->user_model->getusers($_POST["idLevel"][$i]);
$this->load->view('tableau',$user);
}
}}Code:
<?php
echo $user;
?>Filename: views/tableau.php
Line Number: 2
Help ?
Can't Get the result of a query in a view - El Forum - 08-18-2011
[eluser]Kamarg[/eluser]
Try this.
Code:
$this->load->view('tableau',array('user' => $user));