1. class
  2. PhpMyAdmin
  3. \
  4. InsertEdit

InsertEdit

class InsertEdit (View source)

Constants

private FUNC_OPTIONAL_PARAM

private FUNC_NO_PARAM

Methods

__construct(DatabaseInterface $dbi, Relation $relation, Transformations $transformations, FileListing $fileListing, Template $template, Config $config)

No description

array
getFormParametersForInsertForm(string $db, string $table, array|null $whereClauses, array $whereClauseArray, string $errorUrl)

Retrieve form parameters for insert/edit form

string
showTypeOrFunction(string $which, array $urlParams, bool $isShow)

Show type information or function selectors in Insert/Edit

bool
isColumn(string $columnType, array $types)

check whether the column is of a certain type the goal is to ensure that types such as "enum('one','two','binary',..)" or "enum('one','two','varbinary',..)" are not categorized as binary

string
getContinueInsertionForm(string $table, string $db, array $whereClauseArray, string $errorUrl)

get html for continue insertion form

static bool
isWhereClauseNumeric(array|string|null $whereClause)

No description

void
setSessionForEditNext(string $oneWhereClause)

set $_SESSION for edit_next

string
getGotoInclude(string|false $gotoInclude)

set $goto_include variable for different cases and retrieve like, if UrlParams::$goto empty, if $goto_include previously not defined and new_insert, same_insert, edit_next

string
getErrorUrl(array $urlParams)

Defines the url to return in case of failure of the query

array
executeSqlQuery(array $query)

Executes the sql query and get the result, then move back to the calling page

string
getDisplayValueForForeignTableColumn(string $whereComparison, array $foreigners, string $relationField)

Column to display from the foreign table?

string
getLinkForRelationalDisplayField(array $foreigners, string $relationField, string $whereComparison, string $dispval, string $relationFieldValue)

Display option in the cell according to user choices

array
transformEditedValues(string $db, string $table, array $transformation, array $editedValues, string $file, string $columnName, array $extraData, string $type)

Transform edited values

string
getQueryValueForInsert(EditField $editField, bool $usingKey, string|int $whereClause)

Get query values array and query fields array for insert and update in multi edit

string
getQueryValueForUpdate(EditField $editField)

Get field-value pairs for update SQL.

void
verifyWhetherValueCanBeTruncatedAndAppendExtraData(string $db, string $table, string $columnName, array $extraData)

Check whether inline edited value can be truncated or not, and add additional parameters for extra_data array if needed

array
getTableColumns(string $db, string $table)

Function to get the columns of a table

array
determineInsertOrEdit(array|string|null $whereClause, string $db, string $table)

Function to determine Insert/Edit rows

array
getCommentsMap(string $db, string $table)

Function to get comments for the table columns

string
getHtmlForIgnoreOption(int $rowId, bool $checked = true)

Function to get html for the ignore option in insert mode

string
getHtmlForInsertEditFormHeader(bool $hasBlobField, bool $isUpload)

Function to get html for the insert edit form header

string
getHtmlForInsertEditRow(array $urlParams, array $tableColumns, array $commentsMap, ResultInterface $currentResult, bool $insertMode, array $currentRow, bool $isUpload, array $foreigners, string $table, string $db, int $rowId, array $repopulate, array $whereClauseArray)

Function to get html for each insert/edit row

array
getColumnDefaultValues(string $database, string $table)

No description

Details

at line 78
__construct(DatabaseInterface $dbi, Relation $relation, Transformations $transformations, FileListing $fileListing, Template $template, Config $config)

No description

Parameters

DatabaseInterface $dbi
Relation $relation
Transformations $transformations
FileListing $fileListing
Template $template
Config $config

at line 97
array getFormParametersForInsertForm(string $db, string $table, array|null $whereClauses, array $whereClauseArray, string $errorUrl)

Retrieve form parameters for insert/edit form

Parameters

string $db

name of the database
string $table

name of the table
array|null $whereClauses
array $whereClauseArray
string $errorUrl

Return Value

array

array of insert/edit form parameters

at line 245
string showTypeOrFunction(string $which, array $urlParams, bool $isShow)

Show type information or function selectors in Insert/Edit

Parameters

string $which function|type
array $urlParams

containing url parameters
bool $isShow

whether to show the element in $which

Return Value

string

an HTML snippet

at line 320
bool isColumn(string $columnType, array $types)

check whether the column is of a certain type the goal is to ensure that types such as "enum('one','two','binary',..)" or "enum('one','two','varbinary',..)" are not categorized as binary

Parameters

string $columnType

column type as specified in the column definition
array $types

the types to verify

Return Value

bool

at line 637
string getContinueInsertionForm(string $table, string $db, array $whereClauseArray, string $errorUrl)

get html for continue insertion form

Parameters

string $table

name of the table
string $db

name of the database
array $whereClauseArray
string $errorUrl

Return Value

string

an html snippet

at line 660
static bool isWhereClauseNumeric(array|string|null $whereClause)

No description

Parameters

array|string|null $whereClause

Return Value

bool

at line 836
void setSessionForEditNext(string $oneWhereClause)

set $_SESSION for edit_next

Parameters

string $oneWhereClause

one where clause from where clauses array

Return Value

void

at line 863
string getGotoInclude(string|false $gotoInclude)

set $goto_include variable for different cases and retrieve like, if UrlParams::$goto empty, if $goto_include previously not defined and new_insert, same_insert, edit_next

Parameters

string|false $gotoInclude

store some script for include, otherwise it is boolean false

Return Value

string

at line 898
string getErrorUrl(array $urlParams)

Defines the url to return in case of failure of the query

Parameters

array $urlParams

url parameters

Return Value

string

error url for query failure

at line 910
array executeSqlQuery(array $query)

Executes the sql query and get the result, then move back to the calling page

Parameters

array $query

built query from buildSqlQuery()

Return Value

array

at line 985
string getDisplayValueForForeignTableColumn(string $whereComparison, array $foreigners, string $relationField)

Column to display from the foreign table?

Parameters

string $whereComparison

string that contain relation field value
array $foreigners

all Relations to foreign tables for a given table or optionally a given column in a table
string $relationField

relation field

Return Value

string

display value from the foreign table

at line 1025
string getLinkForRelationalDisplayField(array $foreigners, string $relationField, string $whereComparison, string $dispval, string $relationFieldValue)

Display option in the cell according to user choices

Parameters

array $foreigners

all Relations to foreign tables for a given table or optionally a given column in a table
string $relationField

relation field
string $whereComparison

string that contain relation field value
string $dispval

display value from the foreign table
string $relationFieldValue

relation field value

Return Value

string

HTML tag

at line 1091
array transformEditedValues(string $db, string $table, array $transformation, array $editedValues, string $file, string $columnName, array $extraData, string $type)

Transform edited values

Parameters

string $db

db name
string $table

table name
array $transformation

mimetypes for all columns of a table [field_name][field_key]
array $editedValues

transform columns list and new values
string $file

file containing the transformation plugin
string $columnName

column name
array $extraData

extra data array
string $type

the type of transformation

Return Value

array

at line 1211
string getQueryValueForInsert(EditField $editField, bool $usingKey, string|int $whereClause)

Get query values array and query fields array for insert and update in multi edit

Parameters

EditField $editField
bool $usingKey
string|int $whereClause

Either a positional index or string representing selected row

Return Value

string

at line 1234
string getQueryValueForUpdate(EditField $editField)

Get field-value pairs for update SQL.

During update, we build the SQL only with the fields that should be updated.

Parameters

EditField $editField

Return Value

string

at line 1350
void verifyWhetherValueCanBeTruncatedAndAppendExtraData(string $db, string $table, string $columnName, array $extraData)

Check whether inline edited value can be truncated or not, and add additional parameters for extra_data array if needed

Parameters

string $db

Database name
string $table

Table name
string $columnName

Column name
array $extraData

Extra data for ajax response

Return Value

void

at line 1398
array getTableColumns(string $db, string $table)

Function to get the columns of a table

Parameters

string $db

current db
string $table

current table

Return Value

array

at line 1423
array determineInsertOrEdit(array|string|null $whereClause, string $db, string $table)

Function to determine Insert/Edit rows

Parameters

array|string|null $whereClause

where clause
string $db

current database
string $table

current table

Return Value

array

at line 1494
array getCommentsMap(string $db, string $table)

Function to get comments for the table columns

Parameters

string $db

current database
string $table

current table

Return Value

array

comments for columns

at line 1509
string getHtmlForIgnoreOption(int $rowId, bool $checked = true)

Function to get html for the ignore option in insert mode

Parameters

int $rowId

row id
bool $checked

ignore option is checked or not

Return Value

string

at line 1526
string getHtmlForInsertEditFormHeader(bool $hasBlobField, bool $isUpload)

Function to get html for the insert edit form header

Parameters

bool $hasBlobField

whether has blob field
bool $isUpload

whether is upload

Return Value

string

at line 1875
string getHtmlForInsertEditRow(array $urlParams, array $tableColumns, array $commentsMap, ResultInterface $currentResult, bool $insertMode, array $currentRow, bool $isUpload, array $foreigners, string $table, string $db, int $rowId, array $repopulate, array $whereClauseArray)

Function to get html for each insert/edit row

Parameters

array $urlParams

url parameters
array $tableColumns

table columns
array $commentsMap

comments map
ResultInterface $currentResult

current result
bool $insertMode

whether insert mode
array $currentRow

current row
bool $isUpload

whether upload
array $foreigners foreigners
string $table table
string $db database
int $rowId

row id
array $repopulate

the data to be repopulated
array $whereClauseArray

the array of where clauses

Return Value

string

at line 1936
array getColumnDefaultValues(string $database, string $table)

No description

Parameters

string $database
string $table

Return Value

array