Documentation

Database
in package

Included for historical compatibility only. The DBMS API is out of support and should not be used in new code.

Table of Contents

Properties

$client  : mixed
$name  : mixed

Methods

__construct()  : mixed
addIndex()  : mixed
createDatabase()  : mixed
createTable()  : mixed
databaseExists()  : mixed
delete()  : mixed
deleteDatabase()  : mixed
escape()  : mixed
getColumns()  : mixed
getName()  : mixed
getTable()  : mixed
getTableList()  : mixed
insert()  : mixed
optimize()  : mixed
resetCharset()  : mixed
select()  : mixed
tableExists()  : mixed
tableMove()  : mixed
update()  : mixed

Properties

Methods

__construct()

public __construct(Client $client, mixed $dbName) : mixed
Parameters
$client : Client
$dbName : mixed

addIndex()

public addIndex(mixed $tableName, mixed $index) : mixed
Parameters
$tableName : mixed
$index : mixed

createDatabase()

public createDatabase() : mixed

createTable()

public createTable(mixed $tableName, array<string|int, mixed> $cols, array<string|int, mixed> $keys[, array<string|int, mixed> $options = [] ]) : mixed
Parameters
$tableName : mixed
$cols : array<string|int, mixed>
$keys : array<string|int, mixed>
$options : array<string|int, mixed> = []

databaseExists()

public databaseExists() : mixed

delete()

public delete(mixed $tableName[, mixed $id = false ]) : mixed
Parameters
$tableName : mixed
$id : mixed = false

deleteDatabase()

public deleteDatabase() : mixed

escape()

public escape(mixed $string) : mixed
Parameters
$string : mixed

getColumns()

public getColumns(mixed $tableName) : mixed
Parameters
$tableName : mixed

getTable()

public getTable(mixed $tableName) : mixed
Parameters
$tableName : mixed

getTableList()

public getTableList() : mixed

insert()

public insert(mixed $tableName[, mixed $insertData = [] ][, mixed $onDuplicateData = [] ]) : mixed
Parameters
$tableName : mixed
$insertData : mixed = []
$onDuplicateData : mixed = []

optimize()

public optimize([mixed $tableName = null ]) : mixed
Parameters
$tableName : mixed = null

resetCharset()

public resetCharset() : mixed

select()

public select(mixed $tableName[, mixed $cols = true ][, mixed $sqlString = '' ][, mixed $sqlSuffix = '' ]) : mixed
Parameters
$tableName : mixed
$cols : mixed = true
$sqlString : mixed = ''
$sqlSuffix : mixed = ''

tableExists()

public tableExists(mixed $tableName) : mixed
Parameters
$tableName : mixed

tableMove()

public tableMove(mixed $oldTableName, mixed $newTableName[, mixed $newDbName = null ]) : mixed
Parameters
$oldTableName : mixed
$newTableName : mixed
$newDbName : mixed = null

update()

public update(mixed $tableName[, mixed $arr = [] ][, mixed $id = false ]) : mixed
Parameters
$tableName : mixed
$arr : mixed = []
$id : mixed = false
On this page

Search results