Guest User

Untitled

a guest
May 21st, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Login</title>
  4. </head>
  5. <body>
  6.  
  7. <br>
  8. <br>
  9.  
  10. <center><div class="container">
  11. <a href=""><img src="L.jpg" alt="DCU" style="width:200px;height:200px;"></a>
  12. <br>
  13. <a href=""><img src="LN.jpg" alt="DCU" style="width:400px;height:90px;"></a>
  14. <br>
  15. <br>
  16.  
  17. <form action="verify.php">
  18. <div class="row">
  19. <div class="col-25">
  20. <label for="User Name">Username</label>
  21. </div>
  22. <div class="col-75">
  23. <input type="text" name="Username" placeholder="Username">
  24. </div>
  25. </div>
  26. <br>
  27. <div class="row">
  28. <div class="col-25">
  29. <label for="Password">Password</label>
  30. </div>
  31. <div class="col-75">
  32. <input type="password" name="Password" placeholder="Password">
  33. </div>
  34. </div>
  35. <br>
  36. <div class="row">
  37. <input type="submit" value="Login">
  38. </div>
  39. </form>
  40. </div></center>
  41.  
  42.  
  43.  
  44. </body>
  45. </html>
  46.  
  47. <?php
  48. if(isset($_POST['submit'])){
  49. $serverName = "xxxx";
  50. $options = array( "UID" => "xxx", "PWD" => "xxxx",
  51. "Database" => "xxxx");
  52. $conn = sqlsrv_connect($serverName, $options);
  53.  
  54. if( $conn === false )
  55. {
  56. echo "Could not connect.n";
  57. die( print_r( sqlsrv_errors(), true));
  58. }
  59.  
  60.  
  61. $usr = $_POST['username'];
  62. $pas = = $_POST['password'];
  63. $sql = sqlsrv_query("SELECT username FROM dbo.users
  64. WHERE username='$usr' AND
  65. password='$pas'
  66. LIMIT 1");
  67. if(sqlsrv_num_rows($sql) == 1){
  68. $row = sqlsrv_fetch_array($sql);
  69. session_start();
  70. $_SESSION['username'] = $row['username']= TRUE;
  71. header("Location: index.html");
  72. exit;
  73. }else{
  74. header("Location: login_page.html");
  75. exit;
  76. }
  77. }else{ //If the form button wasn't submitted go to the index
  78. page, or login page
  79. header("Location: login_page.html");
  80. exit;
  81. }
  82. ?>
Add Comment
Please, Sign In to add comment