Advertisement
Guest User

Untitled

a guest
Jun 13th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. <?php
  2. ob_start();
  3.  
  4. $host="localhost"; // Host name
  5. $username=""; // Mysql username
  6. $password=""; // Mysql password
  7. $db_name=""; // Database name
  8. $tbl_name="konto"; // 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. $login_username=$_POST['login_username'];
  16. $login_password=$_POST['login_password'];
  17.  
  18. // To protect MySQL injection (more detail about MySQL injection)
  19. $login_username = stripslashes($login_username);
  20. $login_password = stripslashes($login_password);
  21. $login_username = mysql_real_escape_string($login_username);
  22. $login_password = mysql_real_escape_string($login_password);
  23.  
  24. $sql="SELECT * FROM $tbl_name WHERE username='$login_username' and password='$login_password'";
  25. $result=mysql_query($sql);
  26.  
  27. // Mysql_num_row is counting table row
  28. $count=mysql_num_rows($result);
  29. // If result matched $myusername and $mypassword, table row must be 1 row
  30.  
  31. if($count==1){
  32. // Register $myusername, $mypassword and redirect to file "login_success.php"
  33. session_register("login_username");
  34. session_register("login_password");
  35. header("location:dev/index.php");
  36. }
  37. else {
  38. echo "Wrong Username or Password";
  39. }
  40.  
  41. ob_end_flush();
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement