sqlite3 PDO错误

Question

I am trying to open an encrypted sqlite3 database using PDO (PHP 7.1.1).

$db = new PDO('sqlite:mydb.sqlite','','password');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$results = $db->query('SELECT * from Table');

The above code throws following exception:

Uncaught PDOException: SQLSTATE[HY000]: General error: 26 file is encrypted or is not a database

Is my connection string correct? Is it possible to open an encrypted sqlite3 database using PDO?

Answer 1

The documentation for the PDO SQLite interface makes no mention of encryption, nor does the documentation for the PDO class. The only thing I'm aware of is the SQLite3 class which has a parameter for an encryption key in the constructor.

Per the documentation:

encryption_key - An optional encryption key used when encrypting and decrypting an SQLite database. If the SQLite encryption module is not installed, this parameter will have no effect.

As mentioned in the comments on your question, there are other answers which address installing and getting a sqlite encryption module working with PHP.