function semakidlama() { /* echo '<pre>$_POST->'; print_r($_POST) . '</pre>| '; echo 'Kod:' . Hash::rahsia('md5', $_POST['password']) . ': '; echo 'Kod:' . Hash::create('sha256', $_POST['password'], HASH_PASSWORD_KEY) . ': '; $sql="SELECT id, login, role FROM users WHERE login = :login AND password = :password"; $sql2="SELECT namaPegawai,kataLaluan,level FROM nama_pegawai WHERE username = :username AND password = :password"; */ $sth = $this->db->prepare("SELECT namaPegawai,kataLaluan,level \n\t\t\tFROM nama_pegawai WHERE \n\t\t\tnamaPegawai = :username AND kataLaluan = :password"); $sth->execute(array(':username' => $_POST['username'], ':password' => Hash::rahsia('md5', $_POST['password']))); //$sth->debugDumpParams(); //echo ' | $sth=<pre>' . print_r($sth) . '</pre>'; // dapatkan medan terlibat $data = $sth->fetch(); // kira jumlah data $count = $sth->rowCount(); //echo ' | $count=' . $count; if ($count == 1) { // login berjaya Sesi::init(); // namaPegawai,kataLaluan,level Sesi::set('namaPegawai', $data['namaPegawai']); Sesi::set('levelPegawai', $data['level']); Sesi::set('loggedIn', true); header('location:' . URL . 'ruangtamu'); } else { // login gagal header('location:' . URL . 'login/salah'); } }