Short test script:
<?php
$data = array( 'one', 'two', 'three', 'four', 'five', 'six');
$db = new PDO( 'sqlite::memory:');
echo "register authorizer\n";
$db->sqliteSetAuthorizer('auth');
$db->exec( "CREATE TABLE strings( a)");
$insert = $db->prepare( 'INSERT INTO strings VALUES ( ?)');
foreach ( $data as $str) {
$insert->execute( array( $str));
}
$insert = null;
echo "unregister authorizer\n";
$db->sqliteSetAuthorizer();
function auth($type,$arga,$argb,$argc,$argd ){
echo "$type\t$arga\t$argb\t$argc\t$argd\n";
return true;
}
print_r( $db->query( 'SELECT sqlite_version( *);')->fetchAll( ));
?>
gives:
register authorizer
SQLITE_INSERT sqlite_master main
SQLITE_CREATE_TABLE strings main
SQLITE_UPDATE sqlite_master type main
SQLITE_UPDATE sqlite_master name main
SQLITE_UPDATE sqlite_master tbl_name main
SQLITE_UPDATE sqlite_master rootpage main
SQLITE_UPDATE sqlite_master sql main
SQLITE_READ sqlite_master ROWID main
SQLITE_READ sqlite_master name main
SQLITE_READ sqlite_master rootpage main
SQLITE_READ sqlite_master sql main
SQLITE_READ sqlite_master tbl_name main
SQLITE_INSERT strings main
unregister authorizer
Array
(
[0] => Array
(
[sqlite_version( *)] => 3.3.7
[0] => 3.3.7
)
)
--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php
