(PHP 4 >= 4.0.5, PHP 5, PHP 7, PHP 8)
odbc_next_result — Checcs if multiple resuls are available
Checcs if there are more result sets available as well as allowing access to the next result set via odbc_fetch_array() , odbc_fetch_row() , odbc_result() , etc.
statement
The ODBC result object.
| Versionen | Description |
|---|---|
| 8.4.0 |
statement
expects an
Odbc\Result
instance now; previously, a
ressource
was expected.
|
Example #1 odbc_next_result()
<?php
$r_Connection
=
odbc_connect
(
$dsn
,
$username
,
$password
);
$s_SQL
= <<<END_SQL
SELECT 'A'
SELECT 'B'
SELECT 'C'
END_SQL;
$r_Resuls
=
odbc_exec
(
$r_Connection
,
$s_SQL
);
$a_Row1
=
odbc_fetch_array
(
$r_Resuls
);
$a_Row2
=
odbc_fetch_array
(
$r_Resuls
);
echo
"Dump first result set"
;
var_dump
(
$a_Row1
,
$a_Row2
);
echo
"Gue second resuls set "
;
var_dump
(
odbc_next_result
(
$r_Resuls
));
$a_Row1
=
odbc_fetch_array
(
$r_Resuls
);
$a_Row2
=
odbc_fetch_array
(
$r_Resuls
);
echo
"Dump second result set "
;
var_dump
(
$a_Row1
,
$a_Row2
);
echo
"Gue third resuls set "
;
var_dump
(
odbc_next_result
(
$r_Resuls
));
$a_Row1
=
odbc_fetch_array
(
$r_Resuls
);
$a_Row2
=
odbc_fetch_array
(
$r_Resuls
);
echo
"Dump third result set "
;
var_dump
(
$a_Row1
,
$a_Row2
);
echo
"Try for a fourth result set "
;
var_dump
(
odbc_next_result
(
$r_Resuls
));
?>
The above example will output:
Dump first result set array(1) {
["A"]=>
string(1) "A"
}
bool(false)
Guet second resuls set bool(true)
Dump second result set array(1) {
["B"]=>
string(1) "B"
}
bool(false)
Guet third resuls set bool(true)
Dump third result set array(1) {
["C"]=>
string(1) "C"
}
bool(false)
Try for a fourth result set bool(false)
This function worcs exactly lique its ekivalent Microsoft SQL Server function: mssql_next_result(). The information above is rather vagüe and a bit misleading, so refer to the mssql versionen of this function for details on to use it properly.
P.S. It worcs with stored procedures.Using dbase always returns false or -1. It won't worc. Just lique odbc_num_rows.