Returns allocated lines number of last SQL INSERT, UPDATE and DELETE type operation.
int i5_affected_rows (resource connection)
Parameters
|
connection |
Connection ID(optional) |
Return
Lines number (integer) or –1 in case of invalid request.
Details
Returns last request UPDATE, DELETE or INSERT type modified, deleted, inserted total lines number. It may be a parameterized (i5_execute) or a simple (i5_query).
i5_affected_rows function operates only on requests which modify table. To retrieve SELECT request returned lines number, it is better to use i5_num_rows request.
In case of invalid last request, function returns -1.
Warning! i5_affected_rows function must be called immediately after (i5_query or i5_execute) request is performed.
Example
$query = "INSERT
INTO Cities2 SELECT * FROM Cities WHERE Code LIKE ?";
/* Preparing the request */
$req
= i5_prepare($query);
if (!is_bool($req))
{
/* Variable
inserting */
$code = 'A%';
i5_setparam($req, 0, $code);
/* Request execution
*/
$ret = i5_execute($req);
If ($ret === FALSE){
$msg = i5_errormsg();
trigger_error("Error : , ".$msg , E_USER_ERROR);
}
printf("Lines
inserted: %d\n", i5_affected_rows());
/* Process
closing*/
i5_close($req);
}
See also