Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. class ConnectioUtil {
  2.     $servername = "localhost";
  3.     $username = "username";
  4.     $password = "password";
  5.     $dbname = "myDB";
  6.  
  7.     function getConnection() {
  8.         return new mysqli($servername, $username, $password, $dbname);
  9.     }
  10. }
  11.  
  12. class User {
  13.     $login;
  14.     $password;
  15.     // getters, setters
  16. }
  17.  
  18. class UserDao {
  19.     function getUserByLoginAndPassword($login, $password) {
  20.         $connection = ConnectionUtil.getConnection();
  21.         $sql = "SELECT * FROM user WHERE login = ? AND password = ?;
  22.         $result = $connection->query($sql);
  23.         // create user object from result
  24.         return $user;
  25.     }
  26. }
  27.  
  28. class UserController {
  29.     // if url path == "http://sitename/login";
  30.     $user = UserDao.getUserByLoginAndPassword(request.getAttribute("login"), request.getAttribute("password"));
  31.     if ($user == null) {
  32.         // not found in db 
  33.         // redirect to login.html with error attribute
  34.     } else {
  35.         // user exists in db
  36.         //redirect to main.html
  37.     }
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement