include 'connect.php';
$sday = '01/01/2021';
$eday = '03/31/2021';
$t = '1';
$query = "{ call dbo.GetProduct (
@StartDay = ?,
@EndDate = ?,@t= ?)}";
$params = array(
array(&$sday, SQLSRV_PARAM_IN),
array(&$eday, SQLSRV_PARAM_IN),
array(&$t, SQLSRV_PARAM_IN)
);
$smtp = sqlsrv_prepare($conn, $query, $params);
if( $smtp === false )
{
echo "Error in executing statement 3.\n";
die( print_r( sqlsrv_errors(), true));
}
while( $row = sqlsrv_fetch_array($smtp, SQLSRV_FETCH_ASSOC) ){
$result[] = $row;
}
print_r($result);