class MysqlDatabase extends AbstractDatabase (View source)

Class MysqlDatabase

Methods

__construct(string $name, AbstractDatabaseDriver $db)

Constructor.

create(bool $ifNotExists = false, string $charset = 'utf8', string $collate = 'utf8_unicode_ci')

createDatabase

drop(bool $ifExists = false)

dropDatabase

boolean
exists()

exists

rename(string $newName, boolean $returnNew = true)

renameDatabase

getTable(string $name, bool $new = false)

getTable

array
getTables(bool $refresh = false)

Method to get an array of all tables in the database.

getTableDetails(boolean $refresh = false)

getTableDetails

mixed
getTableDetail(bool $table)

getTableDetail

boolean
tableExists(string $table)

tableExists

string
getName()

Method to get property Table

setName(string $name)

Method to set property table

getDriver()

Method to get property Db

setDriver(AbstractDatabaseDriver $db)

Method to set property db

Details

__construct(string $name, AbstractDatabaseDriver $db)

Constructor.

Parameters

string $name
AbstractDatabaseDriver $db

at line line 26
AbstractDatabase select()

select

Return Value

AbstractDatabase

at line line 42
AbstractDatabase create(bool $ifNotExists = false, string $charset = 'utf8', string $collate = 'utf8_unicode_ci')

createDatabase

Parameters

bool $ifNotExists
string $charset
string $collate

Return Value

AbstractDatabase

at line line 58
AbstractDatabase drop(bool $ifExists = false)

dropDatabase

Parameters

bool $ifExists

Return Value

AbstractDatabase

boolean exists()

exists

Return Value

boolean

at line line 75
AbstractDatabase rename(string $newName, boolean $returnNew = true)

renameDatabase

Parameters

string $newName
boolean $returnNew

Return Value

AbstractDatabase

AbstractTable getTable(string $name, bool $new = false)

getTable

Parameters

string $name
bool $new

Return Value

AbstractTable

array getTables(bool $refresh = false)

Method to get an array of all tables in the database.

Parameters

bool $refresh

Return Value

array An array of all the tables in the database.

stdClass[] getTableDetails(boolean $refresh = false)

getTableDetails

Parameters

boolean $refresh

Return Value

stdClass[]

mixed getTableDetail(bool $table)

getTableDetail

Parameters

bool $table

Return Value

mixed

boolean tableExists(string $table)

tableExists

Parameters

string $table

Return Value

boolean

string getName()

Method to get property Table

Return Value

string

AbstractDatabase setName(string $name)

Method to set property table

Parameters

string $name

Return Value

AbstractDatabase Return self to support chaining.

AbstractDatabaseDriver getDriver()

Method to get property Db

Return Value

AbstractDatabaseDriver

AbstractDatabase setDriver(AbstractDatabaseDriver $db)

Method to set property db

Parameters

AbstractDatabaseDriver $db

Return Value

AbstractDatabase Return self to support chaining.

AbstractDatabase reset()

resetCache

Return Value

AbstractDatabase