Client
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
Constants
- ENV_CONNECTION_PASSWORD : mixed = 'MYSQL_PASSWORD'
- ENV_CONNECTION_PASSWORD_FILE : mixed = 'MYSQL_PASSWORD_FILE'
- ENV_CONNECTION_SERVER : mixed = 'MYSQL_HOST'
- ENV_CONNECTION_USER : mixed = '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
$sqli
protected
mixed
$sqli
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
getDefaultAuthority()
public
static getDefaultAuthority() : Authority
Return values
AuthoritygetTableList()
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
setDefaultAuthority()
public
static setDefaultAuthority(Authority $authority) : mixed
Parameters
- $authority : Authority
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