Guest User

Untitled

a guest
Feb 13th, 2018
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. <form action="loginuser.php" method="POST">
  2. <div class="form-group">
  3. <select name="userList">
  4. <option> - - - </option>
  5.  
  6. <?php
  7. include 'db.php';
  8.  
  9. $sql = "SELECT username FROM dbusers";
  10. $result = $conn->query($sql);
  11.  
  12. if ($result->num_rows > 0) {
  13.  
  14. while($row = $result->fetch_assoc()) {
  15. echo "<option>" . $row["username"]. "</option>";
  16. }
  17. }
  18. ?>
  19. </select>
  20. </div>
  21. <div class="form-group">
  22. <input name "password" type="password" class="form-control" id="inputPassword">
  23. </div>
  24. <div class="form-group">
  25. <button type="submit" class="btn btn-info btn-sm btn-block">Login</button>
  26. </div>
  27.  
  28. <?php
  29. session_start();
  30. require('db.php');
  31.  
  32. if (isset($_POST['username']) and isset($_POST['password'])){
  33. echo "TEST - GOOD";
  34.  
  35. $username = $_POST['username'];
  36. $password = $_POST['password'];
  37.  
  38. $query = "SELECT * FROM `dbusers` WHERE username='$username' and password='$password'";
  39.  
  40. $result = mysqli_query($conn, $query) or die(mysqli_error($conn));
  41. $count = mysqli_num_rows($result);
  42.  
  43. if ($count == 1){
  44. $_SESSION['username'] = $username;
  45. }else{
  46.  
  47. $fmsg = "Invalid Login Credentials.";
  48. }
  49. }
  50. if (isset($_SESSION['username'])){
  51. $username = $_SESSION['username'];
  52. echo "Succes";
  53.  
  54. }else{
  55. echo "TEST - FALSE";
  56. }
  57. ?>
Add Comment
Please, Sign In to add comment