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 | ?> |