Advertisement
Guest User

Untitled

a guest
Jun 30th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 0.62 KB | None | 0 0
  1. <?php
  2. ob_start();
  3. $host="localhost";
  4. $username="SQL_USER";
  5. $password="SQL_PASS";
  6. $db_name="test";  
  7. $tbl_name="members";
  8.  
  9. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  10. mysql_select_db("$db_name")or die("cannot select DB");
  11.  
  12. $myusername=$_POST['myusername'];
  13.  
  14. $myusername = stripslashes($myusername);
  15. $myusername = mysql_real_escape_string($myusername);
  16.  
  17.        
  18. $sql="SELECT * FROM $tbl_name WHERE username='$myusername'";
  19. $result=mysql_query($sql);
  20.  
  21. $count=mysql_num_rows($result);
  22.  
  23.  
  24. if($count==1){
  25. echo "Success!";
  26. }
  27. else {
  28. echo "Wrong Username or Password";
  29. }
  30.  
  31. ob_end_flush();
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement