protected function wordsearch() { if ($this->method === 'GET') { $userModel = new \DAO\UserDAO(); $offset = isset($this->request['offset']) ? $this->request['offset'] : 0; $orderby = isset($this->request['orderby']) ? $this->request['orderby'] : 'user_id'; $keyword = isset($this->request['keyword']) ? $this->request['keyword'] : ''; return array('users' => $userModel->keywordSearch($keyword, $orderby, $offset)); } else { return "Invalid method: {$this->method}"; } }
function login() { $request = Slim::getInstance()->request(); $user = json_decode($request->getBody()); $dao = new \DAO\UserDAO(); session_start(); if ($dao->validateUser($user->username, $user->password)) { $u = $dao->getUserById($user->username); $_SESSION["loggedIn"] = true; $_SESSION["username"] = $u->getUsername(); $_SESSION["role"] = $u->getRole(); } else { session_destroy(); } }
<?php namespace DAO; //@todo add in PHPUnit tests if time permits. require "../src/dao/UserDAO.php"; $userModel = new \DAO\UserDAO(); echo "\n Testing getUserById() \n "; $user = $userModel->getUserById(3); echo $user['first_name']; echo "\n Testing getUsers() \n "; $users = $userModel->getUsers('first_name', 0, 3); echo print_r($users, true); echo "\n Testing getCount() \n "; $count = $userModel->getCount(); echo print_r($count, true); echo "\n Testing keywordSearch() \n "; $results = $userModel->keywordSearch('Williamson'); echo print_r($result, true);