SQLite3 类

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

    简介

    与 SQLite 3 数据库交互的类。

    类概要

    class SQLite3 {
    /* 常量 */
    public const int OK;
    public const int DENY;
    public const int IGNORE;
    public const int CREATE_INDEX;
    public const int CREATE_TABLE;
    public const int CREATE_TEMP_INDEX;
    public const int CREATE_TEMP_TABLE;
    public const int CREATE_TEMP_TRIGGER;
    public const int CREATE_TEMP_VIEW;
    public const int CREATE_TRIGGER;
    public const int CREATE_VIEW;
    public const int DELETE;
    public const int DROP_INDEX;
    public const int DROP_TABLE;
    public const int DROP_TEMP_INDEX;
    public const int DROP_TEMP_TABLE;
    public const int DROP_TEMP_TRIGGER;
    public const int DROP_TEMP_VIEW;
    public const int DROP_TRIGGER;
    public const int DROP_VIEW;
    public const int INSERT;
    public const int PRAGMA;
    public const int READ;
    public const int SELECT;
    public const int TRANSACTION;
    public const int UPDATE;
    public const int ATTACH;
    public const int DETACH;
    public const int ALTER_TABLE;
    public const int REINDEX;
    public const int ANALYZE;
    public const int CREATE_VTABLE;
    public const int DROP_VTABLE;
    public const int FUNCTION;
    public const int SAVEPOINT;
    public const int COPY;
    public const int RECURSIVE;
    /* 方法 */
    public __construct(string $filename, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE, string $encryptionKey = "")
    public backup(SQLite3 $destination, string $sourceDatabase = "main", string $destinationDatabase = "main"): bool
    public busyTimeout(int $milliseconds): bool
    public changes(): int
    public close(): bool
    public createAggregate(
        string $name,
        callable $stepCallback,
        callable $finalCallback,
        int $argCount = -1
    ): 布尔值
    public createCollation(字符串 $name, 可调用 $callback): 布尔值
    public createFunction(
        string $name,
        可调用 $callback,
        int $argCount = -1,
        整数 $flags = 0
    ): 布尔值
    public enableExceptions(布尔值 $enable = false): 布尔值
    public static escapeString(字符串 $string): 字符串
    public exec(字符串 $query): 布尔值
    public lastErrorCode(): 整数
    public lastErrorMsg(): 字符串
    public lastInsertRowID(): 整数
    public loadExtension(字符串 $name): 布尔值
    public open(字符串 $filename, 整数 $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE, 字符串 $encryptionKey = ""): 空
    public openBlob(
        字符串 $table,
        字符串 $column,
        整数 $rowid,
        字符串 $database = "main",
        整数 $flags = SQLITE3_OPEN_READONLY
    ): 资源|false
    public prepare(字符串 $query): SQLite3Stmt|false
    public query(字符串 $query): SQLite3Result|false
    public querySingle(字符串 $query, 布尔值 $entireRow = false): 混合
    public setAuthorizer(?可调用 $callback): 布尔值
    public static version(): 数组
    }

    目录

    改进此页面

    了解如何改进此页面 • 提交拉取请求 • 报告错误
    ＋添加注释

    用户贡献的注释 1 个注释

    -7
    dannsbass at gmail dot com
    2 年前
    # 获取目录中的所有 .dbi 文件
    $databases_list = glob("directory/*.dbi");

    # 循环它
    foreach ($databases_list as $db_name){

    # 清理文件名
    $db_name = str_replace('directory/','',str_replace('.dbi','',$db_name));

    # 数据库连接
    $db = new SQLite3($db_name);

    $result = $db->query("SELECT * FROM your_table_name");

    while($data = $result->fetchArray()){

    echo $data['column']."<hr>";

    }

    }
    ＋添加注释
    To Top