note 113459 added to pdo.query

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 .... ?> ---- Server IP: 69.147.83.199 Probable Submitter: 88.149.253.68 ---- Manual Page -- http://php.net/manual/en/pdo.query.php Edit -- https://master.php.net/note/edit/113459 Del: integrated -- https://master.php.net/note/delete/113459/integrated Del: useless -- https://master.php.net/note/delete/113459/useless Del: bad code -- https://master.php.net/note/delete/113459/bad+code Del: spam -- https://master.php.net/note/delete/113459/spam Del: non-english -- https://master.php.net/note/delete/113459/non-english Del: in docs -- https://master.php.net/note/delete/113459/in+docs Del: other reasons-- https://master.php.net/note/delete/113459 Reject -- https://master.php.net/note/reject/113459 Search -- https://master.php.net/manage/user-notes.php