Guest User

Untitled

a guest
Jul 28th, 2013
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. $_SESSION['id'] = $id;
  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. ?>
Advertisement
Add Comment
Please, Sign In to add comment