Index Documentation

SQLiteStatement
in package
implements IDbStatement

Represents a prepared SQLite SQL statement.

Table of Contents

Interfaces

IDbStatement
Represents a prepared database statement.

Methods

__construct()  : SQLiteStatement
Creates a new SQLiteStatement instance.
addParameter()  : void
Assigns a value to a parameter.
close()  : void
execute()  : void
Executes this statement.
getLastInsertId()  : int|string
Returns the ID of the last inserted row.
getParameterCount()  : int
Returns how many parameters there are.
getResult()  : IDbResult
Gets the result after execution.
reset()  : void
Resets this statement for reuse.

Methods

addParameter()

Assigns a value to a parameter.

public addParameter(int $ordinal, mixed $value[, int $type = DbType::AUTO ]) : void
Parameters
$ordinal : int

Index of the target parameter.

$value : mixed

Value to assign to the parameter.

$type : int = DbType::AUTO

Type of the value, if left to DbType::AUTO DbTools::detectType will be used on $value.

getLastInsertId()

Returns the ID of the last inserted row.

public getLastInsertId() : int|string
Return values
int|string

Last inserted ID.

getParameterCount()

Returns how many parameters there are.

public getParameterCount() : int
Return values
int

Number of parameters.


        
On this page

Search results