php man page for cubrid_affected_rows

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 statement

SYNOPSIS
int cubrid_affected_rows ([resource $conn_identifier])
DESCRIPTION
int 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).
PARAMETERS
o $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 VALUES
Number 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.
EXAMPLES
Example #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: 5
SEE ALSO
cubrid_execute(3). PHP Documentation Group CUBRID_AFFECTED_ROWS(3)
Related Man Pages
cubrid_lock_read(3) - php
cubrid_affected_rows(3) - php
cubrid_lock_write(3) - php
cubrid_query(3) - php
cubrid_set_drop(3) - php
Similar Topics in the Unix Linux Community
UPDATE statement: calculating changes
vbseo.php exploit (caught hacker) - UPDATE: VBSEO PATCH INSTALLED
File Formatting
Partial Delete Lines
Assign variable for INSERT INTO statement