Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Login</title>
- </head>
- <body>
- <br>
- <br>
- <center><div class="container">
- <a href=""><img src="L.jpg" alt="DCU" style="width:200px;height:200px;"></a>
- <br>
- <a href=""><img src="LN.jpg" alt="DCU" style="width:400px;height:90px;"></a>
- <br>
- <br>
- <form action="verify.php">
- <div class="row">
- <div class="col-25">
- <label for="User Name">Username</label>
- </div>
- <div class="col-75">
- <input type="text" name="Username" placeholder="Username">
- </div>
- </div>
- <br>
- <div class="row">
- <div class="col-25">
- <label for="Password">Password</label>
- </div>
- <div class="col-75">
- <input type="password" name="Password" placeholder="Password">
- </div>
- </div>
- <br>
- <div class="row">
- <input type="submit" value="Login">
- </div>
- </form>
- </div></center>
- </body>
- </html>
- <?php
- if(isset($_POST['submit'])){
- $serverName = "xxxx";
- $options = array( "UID" => "xxx", "PWD" => "xxxx",
- "Database" => "xxxx");
- $conn = sqlsrv_connect($serverName, $options);
- if( $conn === false )
- {
- echo "Could not connect.n";
- die( print_r( sqlsrv_errors(), true));
- }
- $usr = $_POST['username'];
- $pas = = $_POST['password'];
- $sql = sqlsrv_query("SELECT username FROM dbo.users
- WHERE username='$usr' AND
- password='$pas'
- LIMIT 1");
- if(sqlsrv_num_rows($sql) == 1){
- $row = sqlsrv_fetch_array($sql);
- session_start();
- $_SESSION['username'] = $row['username']= TRUE;
- header("Location: index.html");
- exit;
- }else{
- header("Location: login_page.html");
- exit;
- }
- }else{ //If the form button wasn't submitted go to the index
- page, or login page
- header("Location: login_page.html");
- exit;
- }
- ?>
Add Comment
Please, Sign In to add comment