In XAMPP 7.1.12 I am not getting any output

Question

I wrote a function to fetch the user_status from SQL Server but its seems everything is correct but still I am not getting any output.

My connection with SQL Server is established. And my function is as follows:

function fetchuserStatus($username,$password) {
    include("db-settings.php");   
    if ($conn) {
        $sql = "SELECT User_status from _yb_all_users_tbl where User_name = ? AND Password = ?";
        $parameters = array($username,$password);
        $stmt = sqlsrv_query($conn, $sql, $parameters);
        if( $stmt === false ) {
          die( print_r( sqlsrv_errors(), true));
         }
        if(sqlsrv_has_rows($stmt) === true) {
            sqlsrv_fetch($stmt);  
        }
        sqlsrv_free_stmt($stmt);
        sqlsrv_close($conn);
    } else {
        echo "Connection is not established";
    }
}
echo fetchuserStatus($username,$password);

And my db-settings.php file is:

$serverName = ".";
$connectionOptions = array(
    "Database" => "yaadbook",
    "UID" => "sa",
    "PWD" => "shiftu"
);
$conn = sqlsrv_connect( $serverName, $connectionOptions);
if($conn) {
} else {
    echo "Connection Failure";
    die(print_r(sqlsrv_errors(),TRUE));
}

I am using PHP version 7.1.12. How can I resolve this issue?

use my sqlsrv_errors() to see any errors.after you execute query — RohitS, Dec 16 '17 at 09:55
@RohitS yes i have used. But still i am not getting any errors. I had edit the code.Please check. I am new with SQL SERVER database — Nikita Agrawal, Dec 16 '17 at 09:59
@NikitaAgrawal while adding question please add relevant tags also — kunal, Dec 16 '17 at 10:02
@kunal Can you please rewrite the code. I didn't get exactly what you saying. Thanks — Nikita Agrawal, Dec 16 '17 at 10:04
I am not too much familiar with sql server .Even Hope this link helps you :- https://stackoverflow.com/questions/40456078/how-to-connect-to-sql-server-using-php7-what-am-i-missing — kunal, Dec 16 '17 at 10:05
@kunal The following link used PDO. which i am not aware of. — Nikita Agrawal, Dec 16 '17 at 10:07
@NikitaAgrawal try this :- https://stackoverflow.com/questions/17342000/sql-server-database-query-with-php — kunal, Dec 16 '17 at 10:07

score 0 · Answer 1 · edited Mar 17 '19 at 14:05

I am not getting output because I need to use sqlsrv_execute() after sqlsrv_prepare().

Here is my complete code:

function fetchuserStatus($username,$password){ 
  include("db-settings.php");   
  $sql = "SELECT * from _yb_all_users_tbl where User_name = ? AND Password = ?";
  $parameters = array($username,$password);
  $stmt = sqlsrv_prepare($conn, $sql, $parameters);
  sqlsrv_execute($stmt); 
  if(!$stmt) {
      die( print_r( sqlsrv_errors(), true));
  }
  while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
     return $row;
  }
  sqlsrv_free_stmt($stmt);
  sqlsrv_close($conn);
}

In XAMPP 7.1.12 I am not getting any output

1 Answers1