Query: cubrid_affected_rows
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
CUBRID_AFFECTED_ROWS(3) 1 CUBRID_AFFECTED_ROWS(3) cubrid_affected_rows - Return the number of rows affected by the last SQL statementSYNOPSISint cubrid_affected_rows ([resource $conn_identifier])DESCRIPTIONint cubrid_affected_rows ([resource $req_identifier]) The cubrid_affected_rows(3) function is used to get the number of rows affected by the SQL statement (INSERT, DELETE, UPDATE).PARAMETERSo $conn_identifier -The CUBRID connection. If the connection identifier is not specified, the last link opend by cubrid_connect(3) is assumed. o $req_identifier - Request Identifier, could be returned from either cubrid_prepare(3) or cubrid_execute(3). If the request identifier is not spec- ified, the last identifier requested by cubrid_prepare(3) or cubrid_execute(3) is assumed.RETURN VALUESNumber of rows affected by the SQL statement, when process 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.EXAMPLESExample #1 cubrid_affected_rows(3) 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: Rows deleted: 5SEE ALSOcubrid_execute(3). PHP Documentation Group CUBRID_AFFECTED_ROWS(3)
Related Man Pages |
---|
cubrid_col_size(3) - php |
cubrid_drop(3) - php |
cubrid_insert_id(3) - php |
cubrid_real_escape_string(3) - php |
cubrid_set_add(3) - php |
Similar Topics in the Unix Linux Community |
---|
UPDATE statement: calculating changes |
File Formatting |
File Formatting |
Partial Delete Lines |
How to use loop to convert a DML statement into DDL? |