+- 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: What am I doing wrong? DB, select, array (/showthread.php?tid=59302)
What am I doing wrong? DB, select, array - El Forum - 09-18-2013
[eluser]ZioN[/eluser]
I want to pass information from a database table to a view, but I cannot get it to pass over the result.
Controller (acp):
Code:
public function get_users(){
$this->load->model('users_model');
if ($this->users_model->get_users_model()){
print_r ($data);
//redirect('acp/users/manage_users', $test);
}
else{
//
}
}Model (users_model):
Code:
public function get_users_model(){
$query = $this->db->get('users');
if ($query){ // if succesful
$data = $query->result();
return $data;
}
else{ // if not successful
return false;
}
}A print_r (to test if the $data contains variables) on the model works, but it will not give the data back to the controller and thus not to the view.
What am I doing wrong? DB, select, array - El Forum - 09-18-2013
[eluser]mejlo[/eluser]
replace
Code:
if ($this->users_model->get_users_model()){Code:
if ($data = $this->users_model->get_users_model()){What am I doing wrong? DB, select, array - El Forum - 09-18-2013
[eluser]ZioN[/eluser]
Almost perfect. I tried sending it to the view but it does not recognize it.
Controller:
Code:
public function get_users(){
$this->load->model('users_model');
if ($data = $this->users_model->get_users_model()){
$this->load->view('acp/manage_users_view', $data);
}
else{ }
}Code:
public function get_users_model(){
$query = $this->db->get('users');
if ($query){ // if succesful
$data = $query->result();
return $data;
}
else{ // if not successful
echo "Unable to get data";
return false;
}
}Error:
Code:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: data
Filename: acp/manage_users_view.php
Line Number: 53What am I doing wrong? DB, select, array - El Forum - 09-18-2013
[eluser]mejlo[/eluser]
try:
Code:
$this->load->view('acp/manage_users_view', array('data' => $data));What am I doing wrong? DB, select, array - El Forum - 09-18-2013
[eluser]ZioN[/eluser]
That fixed it. Thanks!