public function editSave($id) { $data = array(); $data['user_id'] = $id; $data['login'] = trim($_POST['login']); $data['password'] = Hash::create_hash('md5', trim($_POST['password']), HASH_KEY); $data['role'] = trim($_POST['role']); ///print_r($data); die; $this->model->editUser($data); header('Location: ' . URL . 'user'); }
public function editUser($data) { //echo $data['role']; die; $postData = array('login' => $data['login'], 'password' => Hash::create_hash('md5', $data['password'], HASH_PASSWORD_KEY), 'role' => $data['role']); $this->db->update('users', $postData, "`id` = {$data['user_id']}"); // $stm = $this->db->prepare("UPDATE users // SET login = :login, // password = :password, // role = :role // WHERE id = :id"); // // //var_dump($stm);die; // $stm->execute(array( // ':id' => $data['id'], // ':login' => $data['login'], // ':password' => $data['password'], // ':role' => $data['role'] // )); }
public function runLogin() { $stm = $this->db->prepare("SELECT user_id, role from users WHERE login = :login\n AND password = :password"); $stm->execute(array(':login' => $_POST['login'], ':password' => Hash::create_hash('md5', $_POST['password'], HASH_KEY))); //var_dump($stm); die(); $stm->setFetchMode(PDO::FETCH_ASSOC); $data = $stm->fetch(); //var_dump($stm); die(); $count = $stm->rowCount(); //var_dump($count); die(); if ($count > 0) { //login Session::set('role', $data['role']); Session::set('loggedIn', true); Session::set('user_id', $data['user_id']); header('location: ../dashboard'); } else { //show an error header('location: ../login'); } }
function index() { echo Hash::create_hash('md5', 'secret', HASH_KEY); $this->view->render('login/index'); }