Documentation

Client
in package

Table of Contents

Constants

ENV_CONNECTION_PASSWORD  = 'MYSQL_PASSWORD'
ENV_CONNECTION_PASSWORD_FILE  = 'MYSQL_PASSWORD_FILE'
ENV_CONNECTION_SERVER  = 'MYSQL_HOST'
ENV_CONNECTION_USER  = 'MYSQL_USER'

Properties

$connected  : mixed
$dbName  : mixed
$sqli  : mixed

Methods

__construct()  : mixed
addIndex()  : mixed
clearDefaultAuthority()  : void
createDatabase()  : mixed
createTable()  : mixed
databaseExists()  : mixed
delete()  : mixed
deleteDatabase()  : mixed
disconnect()  : mixed
escape()  : mixed
execute()  : mixed
executeFile()  : mixed
getColumns()  : mixed
getDatabaseList()  : mixed
getDefaultAuthority()  : Authority
getTableList()  : mixed
insert()  : mixed
optimize()  : mixed
reconnect()  : mixed
resetCharset()  : mixed
select()  : mixed
setDatabase()  : mixed
setDefaultAuthority()  : mixed
tableExists()  : mixed
tableMove()  : mixed
update()  : mixed
_get_update_data()  : mixed
connect()  : mixed
error()  : mixed
get_handle()  : mixed
get_ids()  : mixed

Constants

ENV_CONNECTION_PASSWORD

public mixed ENV_CONNECTION_PASSWORD = 'MYSQL_PASSWORD'

ENV_CONNECTION_PASSWORD_FILE

public mixed ENV_CONNECTION_PASSWORD_FILE = 'MYSQL_PASSWORD_FILE'

ENV_CONNECTION_SERVER

public mixed ENV_CONNECTION_SERVER = 'MYSQL_HOST'

ENV_CONNECTION_USER

public mixed ENV_CONNECTION_USER = 'MYSQL_USER'

Properties

$connected

protected mixed $connected = false

$dbName

protected mixed $dbName = null

Methods

__construct()

public __construct() : mixed

addIndex()

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

clearDefaultAuthority()

public static clearDefaultAuthority() : void

createDatabase()

public createDatabase(mixed $dbName) : mixed
Parameters
$dbName : mixed

createTable()

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

databaseExists()

public databaseExists(mixed $dbName) : mixed
Parameters
$dbName : mixed

delete()

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

deleteDatabase()

public deleteDatabase(mixed $dbName) : mixed
Parameters
$dbName : mixed

disconnect()

public disconnect() : mixed

escape()

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

execute()

public execute(mixed $sqlString) : mixed
Parameters
$sqlString : mixed

executeFile()

public executeFile(mixed $file) : mixed
Parameters
$file : mixed

getColumns()

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

getDatabaseList()

public getDatabaseList() : mixed

getTableList()

public getTableList(mixed $dbName) : mixed
Parameters
$dbName : mixed

insert()

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

optimize()

public optimize(mixed $dbName, mixed $tableName) : mixed
Parameters
$dbName : mixed
$tableName : mixed

reconnect()

public reconnect() : mixed

resetCharset()

public resetCharset(mixed $dbName[, mixed $tableName = null ]) : mixed
Parameters
$dbName : mixed
$tableName : mixed = null

select()

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

setDatabase()

public setDatabase(mixed $dbName) : mixed
Parameters
$dbName : mixed

tableExists()

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

tableMove()

public tableMove(mixed $oldDbName, mixed $oldTableName, mixed $newDbName, mixed $newTableName) : mixed
Parameters
$oldDbName : mixed
$oldTableName : mixed
$newDbName : mixed
$newTableName : mixed

update()

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

_get_update_data()

protected _get_update_data(array<string|int, mixed> $arr) : mixed
Parameters
$arr : array<string|int, mixed>

connect()

protected connect() : mixed

error()

protected error([mixed $sql = null ]) : mixed
Parameters
$sql : mixed = null

get_handle()

protected get_handle(mixed $dbName[, mixed $tableName = null ]) : mixed
Parameters
$dbName : mixed
$tableName : mixed = null

get_ids()

protected get_ids(mixed $id) : mixed
Parameters
$id : mixed

        
On this page

Search results