DB_common::affectedRows() -- Finds number of rows affected by a data changing query
Beschreibung
Number of rows affected by a data manipulation query
(for example INSERT,
UPDATE or DELETE).
Returns 0 for SELECT queries.
Rückgabewert
integer - number of rows
or a DB_Error object on failure
Fehler-Meldungen
Tabelle 39-1. Mögliche Fehler-Arten
| Error code | Error message | Reason | Solution |
|---|
| DB_ERROR_NOT_CAPABLE |
DB backend not capable
|
Function is not supported by the database backend
|
Switch to another database system, if you really
need this feature.
|
Hinweise
Diese Methode kann nicht
statisch aufgerufen werden.
Beispiel
Beispiel 39-1. Using affectedRows()
<?php
// Once you have a valid DB object named $db...
$res =& $db->query('DELETE * FROM clients');
if (PEAR::isError($res)) {
die($res->getMessage());
}
echo 'I have deleted ' . $db->affectedRows() . ' clients';
?>
|
|
