forge104
-
Posts
4 -
Joined
-
Last visited
forge104's Achievements
Newbie (1/5)
0
Reputation
-
PHP SQLSRV_query function does not seem to work
forge104 replied to forge104's topic in PHP Coding Help
Hi, Changing the code to : $result2 = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC); if (!$result2){ header('Location: index.html'); } else { } worked, thanks a lot you saved me a lot of time! -
PHP SQLSRV_query function does not seem to work
forge104 replied to forge104's topic in PHP Coding Help
Hello, I've streamlined the code to this but for some reason it is still registering as 0 results from the query even though the query works in SQL Server. Also I have the same exact code working on a test server that uses MySQL instead of SQL Server. <?php ob_start(); session_start(); $uname = $_POST['username']; $pword = $_POST['password']; $serverName = "localhost"; $connectionInfo = array("Database"=>"Derm", "UID"=>"xxxxxxxx", "pwd"=>"xxxxxxxxx"); $conn = sqlsrv_connect( $serverName, $connectionInfo); $query = "SELECT username, password, userlevel, usertype, location FROM user_access WHERE username = '$uname' and password='$pword'"; $result = sqlsrv_query($conn, $query); $result2 = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC); if(sqlsrv_num_rows($result) == 0) { header('Location: index.html'); }else{ session_regenerate_id(); $_SESSION['username'] = $result2['username']; $_SESSION['level'] = $result2['userlevel']; $_SESSION['type'] = $result2['usertype']; $_SESSION['location'] = $result2['location']; session_write_close(); header('Location: main.php'); } ?> </body> -
PHP SQLSRV_query function does not seem to work
forge104 replied to forge104's topic in PHP Coding Help
Hi, I have used echo around the $result variable and I get "resource id#2" However when I put the same query directly into sql server manager it works. I am using a post method from the login box through to this page. -
Hello, I have successfully installed PHP onto an IIS/SQL Server environment. I can get a DB connection and I can also post and display variables from one PHP page to another. I am trying to create a login script for a web application, but I am am having trouble getting any results from any select query that I write. Here is my login.php page: <body> <?php ob_start(); session_start(); $username = $_POST['username']; $password = $_POST['password']; $serverName = "localhost"; $connectionInfo = array("Database"=>"Derm", "UID"=>"xxxxxxxx", "pwd"=>"xxxxxxxxx"); $conn = sqlsrv_connect( $serverName, $connectionInfo); $query = "SELECT username, password, level, type, location FROM user_access WHERE username = '$username'"; $result = sqlsrv_query($conn, $query); if(sqlsrv_num_rows($result) == 0) // User not found. So, redirect to login_form again. { header('Location: index.html'); } $userData = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC); $hash = hash("sha512", $password); if($hash != $userData['password']) // Incorrect password. So, redirect to login_form again. { header('Location: index.html'); } else{ session_regenerate_id(); $_SESSION['username'] = $userData['username']; $_SESSION['level'] = $userData['level']; $_SESSION['type'] = $userData['type']; $_SESSION['location'] = $userData['location']; session_write_close(); header('Location: main.php'); } ?> </body> I have checked the query many times in SQL Server management studio and it always returns the correct result using my username. However, here, the page keeps refreshing itself and never progresses to 'main.php'. Is there a way to solve this or are there any alternatives to do the same thing? I don't actually want to display the query results, rather just assign them as session variables. Thanks