Welcome Guest, Not a member yet? Register   Sign In
Can't Get the result of a query in a view
#1

[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;
}
}
and in controller
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);
}
}}
in view
Code:
&lt;?php
echo $user;

?&gt;
but i have this error : Message: Undefined variable: user

Filename: views/tableau.php

Line Number: 2
Help ?
#2

[eluser]Kamarg[/eluser]
Try this.

Code:
$this->load->view('tableau',array('user' => $user));




Theme © iAndrew 2016 - Forum software by © MyBB