Portability: Delete Count
require_once './examples/connect.inc';
$$dbms->query('CREATE TABLE tbl (c CHAR(10))');
$$dbms->query("INSERT INTO tbl VALUES ('one')");
$$dbms->query('DELETE FROM tbl');
$count = $$dbms->affectedRows();
if ($count != 0) {
echo 'Yes!';
} else {
echo 'Does everything have to be funny?';
}
$$dbms->query('DROP TABLE tbl');
Default Behavior
| $dbms = 'sqlite'; |
$dbms = 'pgsql'; |
| Does everything have to be funny? |
Yes! |
$$dbms->setOption('portability', DB_PORTABILITY_DELETE_COUNT);
| $dbms = 'sqlite'; |
$dbms = 'pgsql'; |
| Yes! |
Yes! |