Interface for LudoDB database connection adapters

package LudoDB

 Methods

Connect to database

connect() : mixed

Returns

mixed

Return number of rows for given SQL with given params (for prepared statements).

countRows($sql, array $params) : mixed

Example

$count = LudoDB::getInstance()->countRows("select * from city where country=?", array("Norway"));

Parameters

$sql

$params

array

Returns

mixed

Escape string to be inserted into the database

escapeString($string) : mixed

Parameters

$string

Returns

mixed

Return id of last inserted record

getInsertId() : string

Returns

string

Return table definition, column names and column types for a table.

getTableDefinition(String $tableName) : array

Parameters

$tableName

String

Returns

array

Return value of first column in first row of query.

getValue($sql, array $params) : mixed

Parameters

$sql

$params

array

Returns

mixed

Return next row in result set.

nextRow($result) : array

Parameters

$result

Returns

array

Execute query and return first row.

one($sql, array $params) : mixed

Parameters

$sql

$params

array

Returns

mixed

Execute a query and return resource

query($sql, array $params) : mixed

Parameters

$sql

$params

array

Returns

mixed