Guest User

Untitled

a guest
Oct 25th, 2017
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.44 KB | None | 0 0
  1. =     <?php
  2. $host="mysql14.000webhost.com";
  3. $username="a2512574_user";
  4. $password="123hello";
  5. $db_name="a2512574_users";
  6. $tbl_name="Persons";
  7.  
  8. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  9. mysql_select_db("$db_name")or die("cannot select DB");
  10.  
  11. $myusername=$_POST['username'];
  12. $mypassword=$_POST['password'];
  13. $myusername = stripslashes($myusername);
  14. $mypassword = stripslashes($mypassword);
  15. $myusername = mysql_real_escape_string($myusername);
  16. $mypassword = mysql_real_escape_string($mypassword);
  17.  
  18. $sql= mysql_query("SELECT * FROM $tbl_name WHERE username='".$myusername."'");
  19. $rows = mysql_fetch_array($sql);
  20. // you don't need this in a loop, only ONE row of data is returned per user
  21.  
  22. if ($mypassword == $rows['password']) {
  23. //check to make sure the password is correct
  24.  
  25. setcookie("username", $myusername, time()+216000);
  26. setcookie("password", $mypassword, time()+216000);
  27. //Set cookies with username and password
  28.  
  29. $first_name = $rows['FirstName'];
  30. $last_name = $rows['LastName'];
  31. $email = $rows['Email'];
  32. $sex = $rows['Sex'];
  33. $age = $rows['Age'];
  34. $sex_or = $rows['Sex_Or'];
  35. echo "First Name: ", $first_name, "<br />";
  36. echo "Last Name: ", $last_name, "<br />";
  37. echo "Email: ", $email, "<br />";
  38. echo "Sex: ", $sex, "<br />";
  39. echo "Age: ", $age, "<br />";
  40. echo "Sexual Orientation: ", $sex_or;
  41. //Produce Information
  42.  
  43. } ELSE {
  44. //Else produce an error.
  45. Echo "Error invalid username or password";
  46. }
  47. ?>
Add Comment
Please, Sign In to add comment