SHOW:
|
|
- or go back to the newest paste.
1 | public static function logIn(){ | |
2 | $request = \Slim\Slim::getInstance()->request(); | |
3 | // Since the request is in JSON format, we need to decode it | |
4 | $user = json_decode($request->getBody()); | |
5 | // the rest of the code is just PDO stuff | |
6 | $sql = "SELECT id, passkey FROM users WHERE username=:username AND password=:password"; | |
7 | try{ | |
8 | $db = getConnection(); | |
9 | $stmt=$db->prepare($sql); | |
10 | $stmt->bindParam(":username", $user->username); | |
11 | - | $stmt->bindParam(":password", md5sum($user->password)); |
11 | + | $stmt->bindParam(":password", md5sum($user->password + "salt")); |
12 | $stmt->execute(); | |
13 | $db = null; | |
14 | $row=$stmt->fetchAll(PDO::FETCH_OBJ); | |
15 | // here we check if there are rows | |
16 | if($row){ | |
17 | echo '{"user":'.json_encode($row).'}'; | |
18 | //echo json_encode($row); | |
19 | } | |
20 | else{ | |
21 | $errArray = array('passkey'=>'false'); | |
22 | echo '{"user":'.json_encode($errArray).'}'; | |
23 | //echo json_encode($errArray); | |
24 | } | |
25 | } | |
26 | catch(PDOException $e){ | |
27 | echo $e->getMessage(); | |
28 | } | |
29 | } |