gjqzcLct

1function 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	
15CREATE 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
22INSERT INTO `users` (`id`, `user`, `pass`) VALUES
23(1, 'admin', 'admin');