View difference between Paste ID: 9zdHmqZb and jamU0uCZ
SHOW: | | - or go back to the newest paste.
1
<?php
2
3
session_start();
4
$host="localhost"; // Host name
5
$username="root"; // Mysql username
6
$password=""; // Mysql password
7
$db_name="fragville"; // Database name
8
$tbl_name="accounts"; // Table name
9
10
// Connect to server and select databse.
11
mysql_connect("$host", "$username", "$password")or die("cannot connect");
12
mysql_select_db("$db_name")or die("cannot select DB");
13
14
// Define $myusername and $mypassword
15
$myusername=$_POST['myusername'];
16
$mypassword=$_POST['mypassword'];
17
18
// To protect MySQL injection (more detail about MySQL injection)
19
$myusername = stripslashes($myusername);
20
$mypassword = stripslashes($mypassword);
21
$myusername = mysql_real_escape_string($myusername);
22
$mypassword = mysql_real_escape_string($mypassword);
23
$mypassword = hash('sha256', $mypassword);
24
25
$sql="SELECT * FROM accounts WHERE Username='$myusername' and Password='$mypassword'";
26
$result=mysql_query($sql);
27
28
// Mysql_num_row is counting table row
29
$count=mysql_num_rows($result);
30
31
// If result matched $myusername and $mypassword, table row must be 1 row
32
if($count==1){
33
34
// Register $myusername, $mypassword and redirect to file "login_success.php"
35
$id = mysql_result($result, 0)['id']
36-
$id = "SELECT ID FROM accounts WHERE Username='$myusername' and Password='$mypassword'";
36+
37
$_SESSION['myusername'] = $myusername;
38
$_SESSION['mypassword'] = $mypassword;
39
header("location:login_success.php");
40
}
41
else {
42
echo "Wrong Username or Password";
43
}
44
45
?>