Returns allocated lines number of last SQL INSERT, UPDATE and DELETE type operation.
int i5_affected_rows ( |
resource connection ) |
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 witch 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.
connection |
Connection ID(optional) |
Returns:
lines number (integer) or –1 in case of invalid request.
$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_bind_param($req, "s", $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($req));
/* Process closing*/
i5_close($req);
}