Re: Enable authorizer-feature in PDO_SQLITE
| From: | Mario Wolff | Date: | Thu, 16 Nov 2006 15:52:52 +0000 |
| Subject: | Re: Enable authorizer-feature in PDO_SQLITE | ||
| References: | 1 2 3 4 | Groups: | php.internals |
| Request: | Send a blank email to internals+get-26645@lists.php.net to get a copy of this message | ||
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 mainunregister authorizer Array ( [0] => Array
(
[sqlite_version( *)] => 3.3.7
[0] => 3.3.7
)
)