PHP 7.0.6 Released

The SQLite3Stmt class

(PHP 5 >= 5.3.0, PHP 7)

Introduction

A class that handles prepared statements for the SQLite 3 extension.

Class synopsis

SQLite3Stmt {
/* Methods */
public bool bindParam ( string $sql_param , mixed &$param [, int $type ] )
public bool bindValue ( string $sql_param , mixed $value [, int $type ] )
public bool clear ( void )
public bool close ( void )
public SQLite3Result execute ( void )
public int paramCount ( void )
public bool reset ( void )
}

Table of Contents

User Contributed Notes

bohwaz
2 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