文字
SQLite3Stmt 类
(PHP 5 >= 5.3.0)
简介
处理 SQLite 3 扩展语句模板的类。
类摘要
SQLite3Stmt
{
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
- SQLite3Stmt::bindParam — Binds a parameter to a statement variable
- SQLite3Stmt::bindValue — Binds the value of a parameter to a statement variable
- SQLite3Stmt::clear — Clears all current bound parameters
- SQLite3Stmt::close — Closes the prepared statement
- SQLite3Stmt::execute — Executes a prepared statement and returns a result set object
- SQLite3Stmt::paramCount — Returns the number of parameters within the prepared statement
- SQLite3Stmt::reset — Resets the prepared statement
用户评论:
[#1] bohwaz [2013-09-05 03:42:44]
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
?>