La classe SQLite3Stmt

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

Introduction

La classe qui représente les commandes préparées pour une base de données SQLite3.

Synopsis de la classe

class SQLite3Stmt {
/* Méthodes */
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 getSQL(bool $expand = false): string|false
public paramCount(): int
public readOnly(): bool
public reset(): bool
}

Sommaire

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

?>
To Top