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

Sql

class Sql (View source)

Set of functions for the SQL executor

Properties

static bool|null $showAsPhp
static Message|null $usingBookmarkMessage

Methods

__construct(DatabaseInterface $dbi, Relation $relation, RelationCleanup $relationCleanup, Transformations $transformations, Template $template, BookmarkRepository $bookmarkRepository, Config $config, ResponseRenderer $responseRenderer)

No description

string
getHtmlForRelationalColumnDropdown(string $db, string $table, string $column, string $currentValue, string $currentValueParam)

Get the HTML for relational column dropdown During grid edit, if we have a relational field, returns the html for the dropdown

string
getFullValuesForSetColumn(string $db, string $table, string $column, string $whereClause)

Get value of a column for a specific row (marked by $whereClause)

array|null
getValuesForColumn(string $db, string $table, string $columnName)

Get all the values for a enum column or set column in a table

static bool
isJustBrowsing(StatementInfo $statementInfo, bool $findRealEnd = false)

Function to check whether this query is for just browsing

bool
hasNoRightsToDropDatabase(StatementInfo $statementInfo)

No description

string
getDefaultSqlQueryForBrowse(string $db, string $table)

Function to get the default sql query for browsing page

void
storeTheQueryAsBookmark(string $db, string $bookmarkUser, string $sqlQueryForBookmark, string $bookmarkLabel, bool $bookmarkReplace, bool $hasBookmarkAllUsers)

Function to store the query as a bookmark

string
executeQueryAndSendQueryResponse(ServerRequest $request, StatementInfo|null $statementInfo, bool $isGotoFile, string $db, string|null $table, string $sqlQueryForBookmark, string $messageToShow, string $goto, string|null $dispQuery, Message|null $dispMessage, string $sqlQuery, string $completeQuery)

Function to execute the query and send the response

string
executeQueryAndGetQueryResponse(ServerRequest $request, StatementInfo $statementInfo, bool $isGotoFile, string $db, string|null $table, string $sqlQueryForBookmark, string $messageToShow, string $goto, string|null $dispQuery, Message|null $dispMessage, string $sqlQuery, string $completeQuery)

Function to execute the query and send the response

Details

at line 63
__construct(DatabaseInterface $dbi, Relation $relation, RelationCleanup $relationCleanup, Transformations $transformations, Template $template, BookmarkRepository $bookmarkRepository, Config $config, ResponseRenderer $responseRenderer)

No description

Parameters

DatabaseInterface $dbi
Relation $relation
RelationCleanup $relationCleanup
Transformations $transformations
Template $template
BookmarkRepository $bookmarkRepository
Config $config
ResponseRenderer $responseRenderer

at line 234
string getHtmlForRelationalColumnDropdown(string $db, string $table, string $column, string $currentValue, string $currentValueParam)

Get the HTML for relational column dropdown During grid edit, if we have a relational field, returns the html for the dropdown

Parameters

string $db

current database
string $table

current table
string $column

current column
string $currentValue

current selected value
string $currentValueParam

Return Value

string

html for the dropdown

at line 315
string getFullValuesForSetColumn(string $db, string $table, string $column, string $whereClause)

Get value of a column for a specific row (marked by $whereClause)

Parameters

string $db
string $table
string $column
string $whereClause

Return Value

string

at line 345
array|null getValuesForColumn(string $db, string $table, string $columnName)

Get all the values for a enum column or set column in a table

Parameters

string $db

current database
string $table

current table
string $columnName

current column

Return Value

array|null

array containing the value list for the column, null on failure

at line 392
static bool isJustBrowsing(StatementInfo $statementInfo, bool $findRealEnd = false)

Function to check whether this query is for just browsing

Parameters

StatementInfo $statementInfo
bool $findRealEnd

Return Value

bool

at line 419
bool hasNoRightsToDropDatabase(StatementInfo $statementInfo)

No description

Parameters

StatementInfo $statementInfo

Return Value

bool

at line 435
string getDefaultSqlQueryForBrowse(string $db, string $table)

Function to get the default sql query for browsing page

Parameters

string $db

the current database
string $table

the current table

Return Value

string

the default $sql_query for browse page

at line 515
void storeTheQueryAsBookmark(string $db, string $bookmarkUser, string $sqlQueryForBookmark, string $bookmarkLabel, bool $bookmarkReplace, bool $hasBookmarkAllUsers)

Function to store the query as a bookmark

Parameters

string $db

the current database
string $bookmarkUser

the bookmarking user
string $sqlQueryForBookmark

the query to be stored in bookmark
string $bookmarkLabel

bookmark label
bool $bookmarkReplace

whether to replace existing bookmarks
bool $hasBookmarkAllUsers

Return Value

void

at line 1451
string executeQueryAndSendQueryResponse(ServerRequest $request, StatementInfo|null $statementInfo, bool $isGotoFile, string $db, string|null $table, string $sqlQueryForBookmark, string $messageToShow, string $goto, string|null $dispQuery, Message|null $dispMessage, string $sqlQuery, string $completeQuery)

Function to execute the query and send the response

Parameters

ServerRequest $request
StatementInfo|null $statementInfo
bool $isGotoFile

whether goto file or not
string $db

current database
string|null $table

current table
string $sqlQueryForBookmark

the sql query to be stored as bookmark
string $messageToShow

message to show
string $goto

goto page url
string|null $dispQuery

display query
Message|null $dispMessage

display message
string $sqlQuery

sql query
string $completeQuery

complete query

Return Value

string

at line 1504
string executeQueryAndGetQueryResponse(ServerRequest $request, StatementInfo $statementInfo, bool $isGotoFile, string $db, string|null $table, string $sqlQueryForBookmark, string $messageToShow, string $goto, string|null $dispQuery, Message|null $dispMessage, string $sqlQuery, string $completeQuery)

Function to execute the query and send the response

Parameters

ServerRequest $request
StatementInfo $statementInfo
bool $isGotoFile

whether goto file or not
string $db

current database
string|null $table

current table
string $sqlQueryForBookmark

the sql query to be stored as bookmark
string $messageToShow

message to show
string $goto

goto page url
string|null $dispQuery

display query
Message|null $dispMessage

display message
string $sqlQuery

sql query
string $completeQuery

complete query

Return Value

string html