SQLite3Stmt::bindValue()

(PHP 5 >= 5.3.0, PHP 7)

Binds the value of a parameter to a statement variable

说明

Binds the value of a parameter to a statement variable.

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.

参数

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 with1.

The value to bind to a statement variable.

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$typeis omitted, it is automatically detected from the type of the$value:boolean and integer are treated asSQLITE3_INTEGER,float asSQLITE3_FLOAT,null asSQLITE3_NULLand all others asSQLITE3_TEXT. Formerly, if$typehas been omitted, it has defaulted toSQLITE3_TEXT.

If$valueisNULL, it is always treated asSQLITE3_NULL, regardless of the given$type.

返回值

ReturnsTRUEif the value is bound to the statement variable,或者在失败时返回FALSE.

更新日志

范例

SQLite3Stmt::bindValue()example