SQLite3::loadExtension

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

    SQLite3::loadExtension — Attempts to load an SQLite extension library

    Description

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

    Attempts to load an SQLite extension library.

    Parameters

    name

    The name of the library to load. The library must be located in the directory specified in the configure option sqlite3.extension_dir.

    Return Values

    Returns true if the extension is successfully loaded, false on failure.

    Examples

    Example #1 SQLite3::loadExtension() example

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

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes 2 notes

    up
    3
    RollingHog
    5 years ago
    One more addition. If you need to setup non-thread-safe PHP on XAMPP/Apache to use loadextension, look at this article:
    2
    RollingHog
    5 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/
    ＋add a note
    To Top

    Follow Lee on X/Twitter - Father, Husband, Serial builder creating AI, crypto, games & web tools. We are friends :) AI Will Come To Life!

    Check out: eBank.nz (Art Generator) | Netwrck.com (AI Tools) | Text-Generator.io (AI API) | BitBank.nz (Crypto AI) | ReadingTime (Kids Reading) | RewordGame | BigMultiplayerChess | WebFiddle | How.nz | Helix AI Assistant