Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
297
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement