Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $inputuser = $_REQUEST['Username'];
- $inputpass = $_REQUEST['Password'];
- $Server = "MyServer";
- $user = "user";
- $password = "pass";
- $database = "mydb";
- $table = "users";
- $connectionInfo = array( "Database"=>$database,"UID"=>$user, "PWD"=>$password);
- $link = sqlsrv_connect($Server, $connectionInfo);
- if ($link === false) {
- echo "Connection failed. n";
- die(print_r(sqlsrv_errors(), true));
- }
- $query = "SELECT `Username` FROM `onlinereporting` . `users` WHERE `Username` = '$inputuser'";
- $querypass = "SELECT `Password` FROM `onlinereporting` . `users` WHERE `Password` ='$inputpass'";
- $result = sqlsrv_query($link,$query);
- $resultpass = sqlsrv_query($link,$querypass);
- if ($result === false) {
- die(print_r(sqlsrv_errors(), true));
- }
- $row = sqlsrv_fetch_array($result);
- $rowpass = sqlsrv_fetch_array($resultpass);
- $serveruser = $row["Username"];
- $serverpass = $rowpass["Password"];
- if ($serveruser And $serverpass) {
- header('Location: index.html');
- }
- else {
- header('Location: FailedPage.html');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement