PHP Conference Nagoya 2025

SQLite3::loadExtension

(PHP 5 >= 5.3.0, PHP 7, PHP 8)

SQLite3::loadExtensionAttempts to load an SQLite extension library

说明

public SQLite3::loadExtension(string $name): bool

Attempts to load an SQLite extension library.

参数

name

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.

示例

示例 #1 SQLite3::loadExtension() example

<?php
$db
= new SQLite3('mysqlitedb.db');
$db->loadExtension('libagg.so');
?>

添加备注

用户贡献的备注 2 notes

up
1
RollingHog
4 years ago
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/
up
1
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.
To Top