ID: 49518
Updated by: scott...@php.net
Reported By: wjzhhr at gmail dot com
Status: Feedback
Bug Type: SQLite related
Operating System: windwos xp
PHP Version: 5.3.0
New Comment:
Pretty sure wxSQLite is SQLite2 and you need wxSQLite3.
Previous Comments:
------------------------------------------------------------------------
[2009-09-10 09:58:52] sjo...@php.net
Does it work when you supply the right encryption key as the third
parameter?
SQLite3::__construct ( string $filename [, int $flags [, string
$encryption_key ]] )
------------------------------------------------------------------------
[2009-09-10 08:15:49] wjzhhr at gmail dot com
Description:
------------
can't open encrypted database which created by wxSQLite.
<?php
$db = new SQLite3('x.db',SQLITE3_OPEN_READONLY,"1");
$db->exec("PRAGMA KEY='1'");
$result = $db->query('SELECT * FROM xxx');
var_dump($result->fetchArray());
?>
Warning: SQLite3::query(): Unable to prepare statement: 26, file is
encrypted or is not a database
Reproduce code:
---------------
---
>From manual page: sqlite3.open
---
Expected result:
----------------
my table: CREATE TABLE xxx(iswho text,itimes int);
liming|1
xiaojie|2
two records.
Expected result:
array(4) {
[0]=>
string(6) "liming"
["iswho"]=>
string(6) "liming"
[1]=>
int(1)
["itimes"]=>
int(1)
}
Actual result:
--------------
Warning: SQLite3::query(): Unable to prepare statement: 26, file is
encrypted or is not a database
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=49518&edit=1
