Edit Report a Bug

    SQLite3Stmt 类

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

    简介

    处理 SQLite 3 扩展语句模板的类。

    类摘要

    class SQLite3Stmt {
    /* 方法 */
    private __construct(SQLite3 $sqlite3, string $query)
    public bindParam(string|int $param, mixed &$var, int $type = SQLITE3_TEXT): bool
    public bindValue(string|int $param, mixed $value, int $type = SQLITE3_TEXT): bool
    public clear(): bool
    public close(): bool
    public execute(): SQLite3Result|false
    public getSQL(bool $expand = false): string|false
    public paramCount(): int
    public readOnly(): bool
    public reset(): bool
    }

    目录

    add a note add a note

    User Contributed Notes 1 note

    up
    3
    bohwaz
    11 years ago
    There is an undocumented method "readOnly" in this class, as reported on https://bugs.php.net/bug.php?id=65216

    This method can be used like this :

    <?php

    $db     = new SQLite3(':memory:');
    $db->exec('CREATE TABLE test (column);');

    $stmt  = $db->prepare('SELECT column FROM test;');
    var_dump($stmt->readOnly()); // -> true

    $stmt  = $db->prepare('INSERT INTO test (42);');
    var_dump($stmt->readOnly()); // -> false

    ?>
    add a note add a note
    To Top