I have a stored procedure with 2 parameters. I'm able to execute stored procedures with one parameter using the same script below. But I couldn't make it work with two parameters.
$stmt = "{CALL VM_GETPRs_CAMPS (?,?)}";**//SP has 160 rows of data.**
$fdate=date("Y-m-d");
$tdate=date("Y-m-d");
$params = array(
array($fdate,SQLSRV_PARAM_IN),
array($tdate,SQLSRV_PARAM_IN)
);
$result = sqlsrv_query( $conn, $stmt,$params,array('Scrollable' => 'buffered')); //not getting any error
if( $result === false) {
die( print_r( sqlsrv_errors(), true) );
} else{
**//**I tried sqlsrv_num_rows and sqlsrv_has_rows sqlsrv_fetch_array all are giving zero rows.**
$row_count = sqlsrv_num_rows( $result );
if ($row_count === false)
echo "No rows";
else if ($row_count >=0)
echo "\n$row_count\n"; //outputs 0
----------------------------------
if(sqlsrv_has_rows($result))
echo "has rows";
else
echo "No rows"; //outputs No rows
----------------------------------
$data = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC);
var_dump($data); //outputs bool(false)
I'm looking for a solution since four days. Please help me.
