Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. function makeLogin($user, $pass) {
  2. $pdo = new PDO("mysql:host=".HOSTNAME.";dbname=".DATABASE.";charset=utf8;", USERNAME, PASSWORD);
  3. $sql = $pdo->prepare("SELECT user, pass FROM users WHERE user = :user AND pass = :pass");
  4. $sql->bindParam(":user", $user);
  5. $sql->bindParam(":pass", $pass);
  6. $sql->execute();
  7. $users = $sql->fetchAll(PDO::FETCH_ASSOC);
  8. if(count($users) <= 0) {
  9. return "false";
  10. } else {
  11. return "true";
  12. }
  13. }
  14.  
  15. CREATE TABLE IF NOT EXISTS `users` (
  16. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  17. `user` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  18. `pass` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
  19. PRIMARY KEY (`id`)
  20. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
  21.  
  22. INSERT INTO `users` (`id`, `user`, `pass`) VALUES
  23. (1, 'admin', 'admin');
  24.  
  25. if(makeLogin($_POST['usuario'], $_POST['senha']) == 'true') {
  26. setcookie('logged', true, time() + 86400);
  27. } else {
  28. setcookie('logged', false, time() + 86400);
  29. }
  30.  
  31. $sql = $pdo->prepare("SELECT user, pass FROM users WHERE user = :user AND pass = :pass");
  32.  
  33. $sql = $pdo->prepare("SELECT `user`, `pass` FROM `users` WHERE `user` = :user AND `pass` = :pass");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement