< Portability: Error Mapping Example   (Previous) Table of Contents (Next)   Portability: Usage >

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!