LudoDB class

package LudoDB
author Alf Magne Kalleland

 Methods

Constructor

__construct() 

Create database with given name

createDatabase($name) 
Static

Parameters

$name

Returns true if database with given name exists.

databaseExists($name) : bool

Example:


$instance =
if(!LudoDB::getInstance()->databaseExists('nameOfDatabase')){
     LudoDB::getInstance()->createDatabase('nameOfDatabase');
}

Parameters

$name

Returns

bool

Used to enable logging details(elapsed time and number of SQL queries) in JSON response from LudoDBRequestHandler

enableLogging() 
Static

Logs all sql queries to sql.txt

enableSqlLogging() 
Static

Return name of database for database connection.

getDb() : String
Static

Returns

String

Return elapsed time for LudoDB operations.

getElapsed() : mixed
Static

Returns

mixed

Return new LudoDB object with connection to the database.

getInstance() : \LudoDB | \LudoDBMySql | \LudoDBMySqlI | \LudoDBPDO
Static

Returns

Return number of executed SQL queries.

getQueryCount() : int
Static

Returns

int

Returns true if we have a database connection.

hasConnection() : bool
Static

Example:


LudoDB::hasConnection()

Returns

bool

Returns true if connection type is PDO

hasPDO() : bool
Static

Returns

bool

Returns true if logging of SQL queries and elapsed time in LudoDBRequestHandler

isLoggingEnabled() : bool
Static

Returns

bool

Log SQL - this method is mostly used internally.

log($sql, array $arguments) 

Parameters

$sql

$arguments

array

Set connection type, PDO|MySqlI|MySql

setConnectionType($type) 
Static

Parameters

$type

Set name of database used in database connection.

setDb($dbName) 
Static

Parameters

$dbName

Set host for database connection.

setHost($host) 
Static

Parameters

$host

Set password for database connection.

setPassword($pwd) 
Static

Parameters

$pwd

Set user name for database connection

setUser($user) 
Static

Parameters

$user

Returns true if given database table exists.

tableExists($tableName) : String

Parameters

$tableName

Returns

String

Use this databsae.

useDatabase($name) 

Parameters

$name

countRows is implemented in sub classes.

countRows() : int

Returns

int

Return specified host for database connection.

getHost() : String
Static

Returns

String

Return password for database connection.

getPassword() : String
Static

Returns

String

Return username for database connection.

getUser() : String
Static

Returns

String

Return microtime

getTime() : mixed
Static

Returns

mixed

 Properties

 

$conn : \PDO
 

$logSQLs : bool
 

$loggingEnabled : bool
 

$queryCounter : int
 

$startTime : float
 

$connectionType : string
 

$instance : \LudoDB

 Constants

 

ADAPTER_MYSQL

ADAPTER_MYSQL 
 

ADAPTER_MYSQLI

ADAPTER_MYSQLI 
 

ADAPTER_PDO

ADAPTER_PDO 
 

ADAPTER_PDO_ORACLE

ADAPTER_PDO_ORACLE