For newbies like me: if loadExtension fails with "Not supported in multithreaded Web servers" message (which always happens on IIS and sometimes - on Apache), you need to use non-thread-safe build of PHP, which is not always a bad idea; see https://www.geeksforgeeks.org/what-is-thread-safe-or-non-thread-safe-in-php/
SQLite3::loadExtension
(PHP 5 >= 5.3.0, PHP 7)
SQLite3::loadExtension — Attempts to load an SQLite extension library
설명
public bool SQLite3::loadExtension
( string
$shared_library
)Attempts to load an SQLite extension library.
인수
-
shared_library -
The name of the library to load. The library must be located in the directory specified in the configure option sqlite3.extension_dir.
반환값
Returns TRUE if the extension is successfully loaded, FALSE on failure.
예제
Example #1 SQLite3::loadExtension() example
<?php
$db = new SQLite3('mysqlitedb.db');
$db->loadExtension('libagg.so');
?>
add a note
User Contributed Notes 2 notes
RollingHog ¶
4 years ago
RollingHog ¶
4 years ago
One more addition. If you need to setup non-thread-safe PHP on XAMPP/Apache to use loadextension, look at this article: https://paulshipley.id.au/blog/coding-tips/improve-php-performance-with-fastcgi-on-xampp-for-windows/
Tl;dr - you need to install&configure mod_fcgid module for Apache.
