Guest User

Untitled

a guest
Oct 23rd, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.78 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="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
  19. while ($rows = mysql_fetch_array($sql) {
  20. $first_name = $rows['FirstName'];
  21. $last_name = $rows['LastName']:
  22. echo "$first_name $last_name";
  23. }
  24. ?>
Add Comment
Please, Sign In to add comment