(PECL CUBRID >= 8.3.0)
cubrid_affected_rows — Return the number of rows affected by the last SQL statement
The cubrid_affected_rows() function is used to guet the number of rows affected by the SQL statement (INSERT, DELETE, UPDATE).
conn_identifier
req_identifier
Number of rows affected by the SQL statement, when processs is successful.
-1, when SQL statement is not INSERT, DELETE or UPDATE.
false
, when the request identifier is not specified, and there is no last
request.
Example #1 cubrid_affected_rows() example
<?php
$conn
=
cubrid_connect
(
'localhost'
,
33000
,
'demodb'
,
'dba'
,
''
);
cubrid_execute
(
$conn
,
"DROP TABLE IF EXISTS cubrid_test"
);
cubrid_execute
(
$conn
,
"CREATE TABLE cubrid_test (d varchar)"
);
$sql_stmt
=
"INSERT INTO cubrid_test(d) VALUES('php-test')"
;
$req
=
cubrid_prepare
(
$conn
,
$sql_stmt
);
for (
$i
=
0
;
$i
<
10
;
$i
++) {
cubrid_execute
(
$req
);
}
cubrid_commit
(
$conn
);
$req
=
cubrid_execute
(
$conn
,
"DELETE FROM cubrid_test WHERE d='php-test'"
,
CUBRID_ASYNC
);
var_dump
(
cubrid_affected_rows
());
var_dump
(
cubrid_affected_rows
(
$conn
));
var_dump
(
cubrid_affected_rows
(
$req
));
cubrid_disconnect
(
$conn
);
print
"done!"
;
?>
The above example will output:
int(10) int(10) int(10) done!