array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'en', ), 'this' => array ( 0 => 'sqlite3.configuration.php', 1 => 'Runtime Configuration', 2 => 'Runtime Configuration', ), 'up' => array ( 0 => 'sqlite3.setup.php', 1 => 'Installing/Configuring', ), 'prev' => array ( 0 => 'sqlite3.installation.php', 1 => 'Installation', ), 'next' => array ( 0 => 'sqlite3.constants.php', 1 => 'Predefined Constants', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/sqlite3/ini.xml', ), 'history' => array ( ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); contributors($setup); ?>

Runtime Configuration

The behaviour of these functions is affected by settings in php.ini.

SQLite3 Configure Options
Name Default Changeable Changelog
sqlite3.extension_dir "" INI_SYSTEM  
sqlite3.defensive 1 INI_USER Available as of PHP 7.2.17 and 7.3.4 for libsqlite ≥ 3.26.0. Prior to PHP 8.2.0 this setting was changeable only as INI_SYSTEM.

Here's a short explanation of the configuration directives.

sqlite3.extension_dir string

Path to the directory where the loadable extensions for SQLite reside.

sqlite3.defensive bool

When the defensive flag is enabled, language features that allow ordinary SQL to deliberately corrupt the database file are disabled. This forbids writing directly to the schema, shadow tables (eg. FTS data tables), or the sqlite_dbpage virtual table. This php.ini setting is only effective for libsqlite ≥ 3.26.0.