Headache getting php and sql server 2005 to run together

Question

Below is the code that i cannot get to work. I know i have established a connection to the database but this returns nothing. What am i doing wrong?

$result = "SELECT * FROM images WHERE path = ?";
$params = array("blah");
$row = sqlsrv_query($conn, $result, $params);

$finished = sqlsrv_fetch_array($row);


if($finished)
{
echo "blach";
}

Answer 1

You may need to replace your ntwdblib.dll as explanied on the mssql_connect() page of the php.net manual.

Answer 2

Would it be worth checking that the query is not returning an error?

$result = "SELECT * FROM images WHERE path = ?";
$params = array("blah");
$row = sqlsrv_query($conn, $result, $params);

if( $row === false ) {
    print_r(sqlsrv_errors());
}

Answer 3

What if you don't use a literal? Most of the MSDN examples use variables.

I'd try:

$result = "SELECT * FROM images WHERE path = ?";
$var = "blah";
$row = sqlsrv_query($conn, $result, array($var));

$finished = sqlsrv_fetch_array($row);

Answer 4

I m facing same problem and even i m using literal also, see my code:

function GetAuto()
{
$params = array(array("InquiryForm"),   
    array("Last"),
    array(0),
    array(""),
    array($LastAuto,SQLSRV_PARAM_OUT,SQLSRV_SQLTYPE_DECIMAL(20, 0)));
$processauto = "{CALL GetSpecificAuto(?,?,?,?,?)}";  
$getauto = sqlsrv_query($conn,$processauto,$params);
if($getauto === false)
{
 echo "Error in executing GetSpecificAuto for LastRecord. \n";
 die( print_r( sqlsrv_errors(), true));
}
sqlsrv_free_stmt( $getauto);

return $LastAuto;

}

$auto = GetAuto();
echo $auto;

its not working. My Connection is also working fine. I have checked it with sqlsrv_server_info(), i m also trying this same with the return type array, i need to create a function which returns a array, but that function is also not working.

any help pls.....