Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $con = mysqli_connect("localhost", "root", "", "smartdev");
  4.  
  5. // Check connection
  6. if (mysqli_connect_errno())
  7. {
  8. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  9. }
  10. else
  11. {
  12. echo "Connected to database ";
  13. }
  14.  
  15. ?>
  16.  
  17. <?php
  18. include("/web/scripts/mysqli_conf.php");
  19. $error="";
  20. if(isset($_POST['login'])){
  21. if(empty($_POST['username']) || empty($_POST['password'])){
  22. $error = "Username or password is not valid";
  23. }
  24. else
  25. {
  26. $user=$_POST['username'];
  27. $pass=$_POST['password'];
  28. $db = mysqli_select_db($conn, "smartdev");
  29. $query = mysqli_query($conn, "SELECT * FROM users WHERE pass='$pass' AND user=$user";
  30.  
  31. $rows = mysqli_num_rows($query);
  32. if($rows == 1){
  33. header("Location: /web/index.html");
  34. }
  35. else
  36. {
  37. $error = "Username or password is invalid";
  38. }
  39. mysqli_close($conn);
  40. }
  41. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement