Files
archived-pecl-database-ibm-db2/tests/test_010_UpdateRowCount.phpt
2009-02-09 09:41:37 +00:00

26 lines
531 B
PHP

--TEST--
IBM-DB2: db2_num_rows - update
--SKIPIF--
<?php require_once('skipif.inc'); ?>
--FILE--
<?php
require_once('connection.inc');
$conn = db2_connect($database, $user, $password);
db2_autocommit( $conn, DB2_AUTOCOMMIT_OFF );
if ($conn) {
$stmt = db2_exec( $conn, "UPDATE animals SET name = 'flyweight' WHERE weight < 10.0" );
echo "Number of affected rows: " . db2_num_rows( $stmt );
db2_rollback($conn);
db2_close($conn);
}
else {
echo "Connection failed.";
}
?>
--EXPECT--
Number of affected rows: 4