a6eHMyfH

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');
24	
25if(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");