· 9 years ago · Jun 11, 2017, 12:30 PM
1SQL kod:
2
3CREATE TABLE IF NOT EXISTS `users` (
4 `id` int(4) NOT NULL AUTO_INCREMENT,
5 `username` varchar(65) NOT NULL DEFAULT '',
6 `password` varchar(65) NOT NULL DEFAULT '',
7 `name` varchar(40) NOT NULL DEFAULT '',
8 `email` varchar(40) NOT NULL DEFAULT '',
9 `group` varchar(40) NOT NULL DEFAULT '',
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
12
13HTML form:
14 <form action='login2.php' method='post'>
15 Username: <br /> <input type='text' name='username'><br />
16 Password: <br /> <input type='password' name='password'> <br />
17 <input type=submit name=submit value=Login></form>
18
19<?php
20include("config.php");
21 $username = safe($_POST['username']);
22 $password = safe($_POST['password']);
23 $username = mysql_real_escape_string($username);
24 $password = mysql_real_escape_string($password);
25 $username = addslashes($username);
26 $password = addslashes($password);
27
28 $sql = "SELECT * FROM `users` WHERE username = '$username' and password = '$password'";
29 $result = mysql_query($sql);
30 $count = mysql_num_rows($result);
31
32 if($count == 1) {
33 $_SESSION['loggedin'] = 1;
34 echo "You have now logged in. Click <a href='home.php'>Here</a> to go to your account.";
35 } else {
36 echo "Wrong username or password.";
37
38 }
39
40 ?>