Answer the question
In order to leave comments, you need to log in
How to get return of MS SQL procedure in PHP 7?
Greetings.
Function returns run perfectly through
$tsql = "SELECT * FROM dbo.GetInfo('.$value.')";
$stmt = sqlsrv_query($conn, $tsql);
$row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC); // И все получилось. Пришла таблица.
$tsql = "exec dbo.GetPrice 'abc'";
$stmt = sqlsrv_prepare($conn, $tsql);
if ($stmt) {
echo "Statement prepared.\n";
} else {
echo "Error in preparing statement.\n";
die(print_r(sqlsrv_errors(), true));
}
/* Execute the statement. Display any errors that occur. */
$result = sqlsrv_execute($stmt);
if ($result) {
echo "Statement executed.\n";
} else {
echo "Error in executing statement.\n";
die(print_r(sqlsrv_errors(), true));
}
$tsql = "exec dbo.GetPrice 'abc'";
$stmt = sqlsrv_query($conn, $tsql);
$row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question