Returns lines number from a result set.
int i5_num_rows (resource result/query)
Parameter
|
result |
File or request ID |
Return
Returns lines number in case of success or FALSE if it fails.
Error returned
|
I5_ERR_PHP_HDLDFT |
256 |
No default connection found. |
|
I5_ERR_PHP_OPTIONSTYPE |
259 |
The type of " I5_OPTIONS_ALIAS" option must be x and not x |
|
I5_ERR_PHP_OPTIONSNUMBER |
260 |
Option number -1 is unknown. |
Details
Retrieves lines number in results set. This command is available only to SELECT requests or file opened with i5_open.
To retrieve lines number involved with an INSERT, UPDATE or DELETE request, use i5_affected_rows function.
Example
$nom = 'C-01';
//Prepared request creation
$req = i5_prepare('SELECT FIRSTNAME, LASTNAME FROM EASYCOMXMP/SP_CUST WHERE CUST_ID=?');
if ($req)
{
$ret = i5_setparam($req, 0, $nom);
if (!$ret)
{
print_r("i5_setparam error : ".i5_errormsg().'<br/>');
}
/* Request execution */
$ret = i5_execute($req);
if (!$ret)
{
print_r("i5_execute error : ".i5_errormsg().'<br/>');
}
if (!$ret)
{
print_r("i5_execute error : ".i5_errormsg().'<br/>');
}
else
{
$nbrows = i5_num_rows($req);
if (is_bool ( $nbrows ) && $nbrows == FALSE)
{
print_r("i5_num_rows error : ".i5_errormsg().'<br/>');
}
else
{
printf("Lines selected: %d<BR>", $nbrows);
}
}
}
else
{
print_r("i5_prepare error : ".i5_errormsg().'<br/>');
}
See also