Guest User

Untitled

a guest
Jul 5th, 2018
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. <?php
  2. define('DBHOST','localhost');
  3. define('DBUSER','id6394288_rohitdatabase');
  4. define('DBPASS','mysprite');
  5. define('DBNAME','id6394288_db');
  6. $conn=mysqli_connect(DBHOST,DBUSER,DBPASS) or die("cannot connect");
  7. $dbcon=mysqli_select_db($conn,DBNAME) or die("cannot select Db");
  8. if(!$conn)
  9. {
  10. echo "Error Connection";
  11. }
  12. ?>
  13. <html>
  14. <head>
  15. <title>ROHITDATABASE </title>
  16. </head>
  17. <body>
  18. <form method="post">
  19. <input type="text" name="username" placeholder="Username">
  20. <input type="password" name="password" placeholder="Password">
  21. <input type="submit" name="submit">
  22.  
  23. </form>
  24. <?php
  25. if(isset($_POST["submit"]))
  26. {
  27. $username=$_POST["username"];
  28. $password=$_POST["password"];
  29. $query="select * from tb1 where (username ='$username')and (password='$password')";
  30. $result=mysqli_query($conn,$query);
  31. if(mysqli_num_rows($result)==1)
  32. {
  33. echo " Login Accepted";
  34. }
  35. else
  36. {
  37. echo "Login Rejected ";
  38. }
  39.  
  40. }
  41. ?>
  42. </body>
  43. </html>
Add Comment
Please, Sign In to add comment