note 113459 deleted from pdo.query by cmb
| From: | cmb@php.net | Date: | Sun, 05 Jan 2020 08:58:33 +0000 |
| Subject: | note 113459 deleted from pdo.query by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-213794@lists.php.net to get a copy of this message | ||
Note Submitter: paolo at dellunto dot net
----
If you are using PDO to create an SQLite dbfile that will be used by an Android application, you can
set common values via the $dbh->query("PRAGMA ...") statement;
a tipical example would be the user_version of the database or the page_size
<?php
...
$dbh = new PDO($PDO_DSN, null, null, null);
$dbh->query("PRAGMA page_size = 4096"); //Android match page size
$dbh->query("PRAGMA user_version = 2"); //This match super(context, DB_NAME, null,
DB_VERSION) of the DatabaseOpenHelper
....
?>