Skip to main content
Home

ambil data dari model ke controller

May 6, 2011 by outtaste

outtaste's picture

agan2 master ,,ane newbie nih..mau tanya kalo ane mau ambil data dari database,, tapi cuma salah satu field aja,, misal ane mau ambil data "npm" dari table "admin",, trus data npm itu dimasukkin ke variabel baru di controllerr,, sintaksnya gimana yah mastah??

saya udah coba cript ini..
model :
function check_npm($table,$username, $password){
$query = $this->db->select('npm')
->from($table)
->where('userName', $username)
->where('password', md5($password))
->limit(1)
->get();
if($query->num_rows() > 0)
return $query->row()->npm;
return false;
}

controller :
$this->load->model('hal_utama_mod');
$table = $this->hal_utama_mod->selectlog($user1,$pass1);
$data = $this->hal_utama_mod->check_npm($table,$user1,$pass1);
$data2 = array("NPM"=>$data);
$this->load->view('tampil',$data2);
(select log itu akan ngembaliin nilai nama tabel nya..)

view :

	echo $NPM;

waktu dijalanin ga ada error,, tapi ga ada outputnya juga agan2,, kosong doang..
mohon pencerahannya yah..
thxx before...

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

aduhh..aduh... Human error

May 6, 2011 by outtaste, 6 days 4 hours ago
Comment: 8123

outtaste's picture

sorry mas,, ternyata ini salah saya,, lupa kalo ternyata password di database saya ga di enkrip jadi ga perlu md5..

setelah cek di phpmyadmin nya baru sadar...
hehehehee...thx ya agan joedy...

Pertama2 cek dl, apakah query

May 6, 2011 by joedy, 6 days 4 hours ago
Comment: 8122

joedy's picture

Pertama2 cek dl, apakah query yg dihasilkan dr aktive record yg bung :D outtase sudah benar, yaitu cek dengan:

echo $this->db->last_query(); 
print_r($query);

setelah itu, jalankan query yg terlihat d brower (hasil dr function last_query ke SQL query (misalnya: di phpmyadmin). Supaya tau apa benar datanya ada.

Coddingnya ribet :D. klo blh saya sederhanakan:

$where = array('userName'=>$username, 'password'=>md5($password));
 $this->db->select('npm');
 $this->db->from($table);
 $this->db->where($where);
 $query = $this->db->get();

happy codding ;)
kasi tau y solusinya, biar teman2 yg lain bs blajar jg, trmasuk saya :D

Premium Drupal Themes by Adaptivethemes