SQLite3Stmt::bindValue

(PHP 5 >= 5.3.0, PHP 7)

SQLite3Stmt::bindValue — Binds the value of a parameter to a statement variable

说明

public SQLite3Stmt::bindValue ( mixed $sql_param , mixed $value [, int $type ] ) : bool

Binds the value of a parameter to a statement variable.

Caution

Before PHP 7.2.14 and 7.3.0, respectively, once the statement has been executed, SQLite3Stmt::reset() needs to be called to be able to change the value of bound parameters.

参数

sql_param

Either a string (for named parameters) or an int (for positional parameters) identifying the statement variable to which the value should be bound. If a named parameter does not start with a colon (:) or an at sign (@), a colon (:) is automatically preprended. Positional parameters start with 1.

value

The value to bind to a statement variable.

type

The data type of the value to bind.

  • SQLITE3_INTEGER: The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.

  • SQLITE3_FLOAT: The value is a floating point value, stored as an 8-byte IEEE floating point number.

  • SQLITE3_TEXT: The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16-LE).

  • SQLITE3_BLOB: The value is a blob of data, stored exactly as it was input.

  • SQLITE3_NULL: The value is a NULL value.

As of PHP 7.0.7, if type is omitted, it is automatically detected from the type of the value: boolean and integer are treated as SQLITE3_INTEGER, float as SQLITE3_FLOAT, null as SQLITE3_NULL and all others as SQLITE3_TEXT. Formerly, if type has been omitted, it has defaulted to SQLITE3_TEXT.

Note:

If value is NULL, it is always treated as SQLITE3_NULL, regardless of the given type.

返回值

Returns TRUE if the value is bound to the statement variable, FALSE on failure.

更新日志

版本 说明
7.4.0 sql_param now also supports the @param notation.

范例

Example #1 SQLite3Stmt::bindValue() example

<?php
$db = new SQLite3(':memory:');

$db->exec('CREATE TABLE foo (id INTEGER, bar STRING)');
$db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')");

$stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id');
$stmt->bindValue(':id', 1, SQLITE3_INTEGER);

$result = $stmt->execute();
var_dump($result->fetchArray(SQLITE3_ASSOC));
?>

以上例程会输出：

array(1) {
  ["bar"]=>
  string(14) "This is a test"
}

参见

相关文章
php ibm db2 函数 binds a php variable to an sql statement parameterphp variable handling 函数 dumps a string representation of an internal zend value to outputphp sqlite 函数 escapes a string for use as a query parameterphp mysqli stmt used to get the current value of a statement attributephp mysqli stmt binds variables to a prepared statement as parametersphp mysqli stmt binds variables to a prepared statement for result storagephp mysqli stmt seeks to an arbitrary row in statement result setphp mysqli stmt returns the error code for the most recent statement callphp mysqli stmt returns the number of parameter for the given statementphp mysqli stmt resets a prepared statementphp mysqli stmt returns result set metadata from a prepared statementphp reflectionparameter gets default parameter valuephp sqlite3stmt binds a parameter to a statement variablephp sqlite3stmt binds the value of a parameter to a statement variablephp sqlite3stmt closes the prepared statementphp sqlite3stmt executes a prepared statement and returns a result set objectphp sqlite3stmt get the sql of the statementphp sqlite3stmt returns the number of parameters within the prepared statementphp sqlite3stmt returns whether a statement is definitely read onlyphp sqlite3stmt resets the prepared statement
关注编程学问公众号