1. class
  2. PhpMyAdmin
  3. \
  4. Database
  5. \
  6. CentralColumns

CentralColumns

class CentralColumns (View source)

Properties

Template $template

Methods

__construct(DatabaseInterface $dbi)

No description

array|false
getParams()

Returns the configuration storage settings for central columns or false if no storage is available

array
getColumnsList(string $db, int $from = 0, int $num = 25)

get $num columns of given database from central columns list starting at offset $from

int
getCount(string $db)

Get the number of columns present in central list for given db

array
findExistingColNames(string $db, array $cols)

return the existing columns in central list among the given list of columns

Message
syncUniqueColumns(DatabaseName $databaseName, array $fieldSelect, bool $isTable = true, string $containingTable = '')

If $isTable is true then unique columns from given tables as $field_select are added to central list otherwise the $field_select is considered as list of columns and these columns are added to central list if not already added

Message
deleteColumnsFromList(string $database, array $fieldSelect, bool $isTable = true)

if $isTable is true it removes all columns of given tables as $field_select from central columns list otherwise $field_select is columns list and it removes given columns if present in central list

Message
makeConsistentWithList(string $db, array $selectedTables)

Make the columns of given tables consistent with central list of columns.

Message
updateOneColumn(string $db, string $origColName, string $colName, string $colType, string $colAttribute, string $colLength, bool $colIsNull, string $collation, string $colExtra, string $colDefault)

update a column in central columns list if a edit is requested

Message
updateMultipleColumn(array $params)

Update Multiple column in central columns list if a change is requested

array
getListRaw(string $db, string $table)

get the list of columns in given database excluding the columns present in current table

string
getHtmlForEditingPage(array $selectedFld, string $selectedDb)

Get HTML for editing page central columns

int
getColumnsCount(string $db, int $from = 0, int $num = 25)

get number of columns of given database from central columns list starting at offset $from

array
getColumnsNotInCentralList(string $db, string $table)

No description

array
getTemplateVariablesForMain(string $db, int $totalRows, int $pos)

Adding a new user defined column to central list

Details

at line 64
__construct(DatabaseInterface $dbi)

No description

Parameters

DatabaseInterface $dbi

at line 81
array|false getParams()

Returns the configuration storage settings for central columns or false if no storage is available

Return Value

array|false

at line 106
array getColumnsList(string $db, int $from = 0, int $num = 25)

get $num columns of given database from central columns list starting at offset $from

Parameters

string $db

selected database
int $from

starting offset of first result
int $num

maximum number of results to return

Return Value

array

list of $num columns present in central columns list starting at offset $from for the given database

at line 138
int getCount(string $db)

Get the number of columns present in central list for given db

Parameters

string $db

current database

Return Value

int

number of columns in central list of columns for $db

at line 166
array findExistingColNames(string $db, array $cols)

return the existing columns in central list among the given list of columns

Parameters

string $db

the selected database
array $cols

list of given columns

Return Value

array

list of columns in central columns among given set of columns

at line 264
Message syncUniqueColumns(DatabaseName $databaseName, array $fieldSelect, bool $isTable = true, string $containingTable = '')

If $isTable is true then unique columns from given tables as $field_select are added to central list otherwise the $field_select is considered as list of columns and these columns are added to central list if not already added

Parameters

DatabaseName $databaseName
array $fieldSelect

if $isTable is true selected tables list otherwise selected columns list
bool $isTable

if passed array is of tables or columns
string $containingTable

if $isTable is false, then table name to which columns belong

Return Value

Message

at line 362
Message deleteColumnsFromList(string $database, array $fieldSelect, bool $isTable = true)

if $isTable is true it removes all columns of given tables as $field_select from central columns list otherwise $field_select is columns list and it removes given columns if present in central list

Parameters

string $database

Database name
array $fieldSelect

if $isTable selected list of tables otherwise selected list of columns to remove from central list
bool $isTable

if passed array is of tables or columns

Return Value

Message

at line 441
Message makeConsistentWithList(string $db, array $selectedTables)

Make the columns of given tables consistent with central list of columns.

Updates only those columns which are not being referenced.

Parameters

string $db

current database
array $selectedTables

list of selected tables.

Return Value

Message

at line 517
Message updateOneColumn(string $db, string $origColName, string $colName, string $colType, string $colAttribute, string $colLength, bool $colIsNull, string $collation, string $colExtra, string $colDefault)

update a column in central columns list if a edit is requested

Parameters

string $db

current database
string $origColName

original column name before edit
string $colName

new column name
string $colType

new column type
string $colAttribute

new column attribute
string $colLength

new column length
bool $colIsNull

value 1 if new column isNull is true, 0 otherwise
string $collation

new column collation
string $colExtra

new column extra property
string $colDefault

new column default value

Return Value

Message

at line 575
Message updateMultipleColumn(array $params)

Update Multiple column in central columns list if a change is requested

Parameters

array $params

Request parameters

Return Value

Message

at line 672
array getListRaw(string $db, string $table)

get the list of columns in given database excluding the columns present in current table

Parameters

string $db

selected database
string $table

current table name

Return Value

array

encoded list of columns present in central list for the given database

at line 736
string getHtmlForEditingPage(array $selectedFld, string $selectedDb)

Get HTML for editing page central columns

Parameters

array $selectedFld

Array containing the selected fields
string $selectedDb

String containing the name of database

Return Value

string

HTML for complete editing page for central columns

at line 761
int getColumnsCount(string $db, int $from = 0, int $num = 25)

get number of columns of given database from central columns list starting at offset $from

Parameters

string $db

selected database
int $from

starting offset of first result
int $num

maximum number of results to return

Return Value

int

count of $num columns present in central columns list starting at offset $from for the given database

at line 784
array getColumnsNotInCentralList(string $db, string $table)

No description

Parameters

string $db
string $table

Return Value

array

at line 802
array getTemplateVariablesForMain(string $db, int $totalRows, int $pos)

Adding a new user defined column to central list

Parameters

string $db

current database
int $totalRows

number of rows in central columns
int $pos

offset of first result with complete result set

Return Value

array