• Home
• PMA
• libraries
• controllers
• table
• TableSearchController

PHP Class PMA\libraries\controllers\table\TableSearchController

Show file Open project: phpmyadmin/phpmyadmin Class Usage Examples

Protected Properties

Property	Type	Description
$url_query

Public Methods

Method	Description
__construct ( string $searchType, string $url_query )	Constructor
changeTableInfoAction ( ) : void	Change table info action
displaySelectionFormAction ( $datalabel = null ) : void	Display selection form action
doSelectionAction ( ) : void	Do selection action
findAction ( ) : void	Find action
getColumnMinMax ( string $column ) : array	Finds minimum and maximum value of a given column.
getColumnProperties ( integer $search_index, integer $column_index ) : array	Provides a column's type, collation, operators list, and criteria value to display in table search form
getDataRowAction ( ) : void	Get data row action
getReplacePreview ( integer $columnIndex, string $find, string $replaceWith, boolean $useRegex, string $charSet ) : string	Returns HTML for previewing strings found and their replacements
indexAction ( ) : void	Index action
rangeSearchAction ( ) : void	Range search action
replace ( integer $columnIndex, string $find, string $replaceWith, boolean $useRegex, string $charSet ) : void	Replaces a given string in a column with a give replacement
replaceAction ( ) : void	Replace action
zoomSubmitAction ( string $dataLabel, string $goto ) : void	Zoom submit action

Private Methods

Method	Description
_buildSqlQuery ( ) : string	Builds the sql search query from the post parameters
_generateWhereClause ( ) : string	Generates the where clause for the SQL search query to be executed
_getEnumWhereClause ( mixed $criteriaValues, string $func_type ) : string	Return the where clause in case column's type is ENUM.
_getGeomWhereClause ( mixed $criteriaValues, string $names, string $func_type, string $types, boolean $geom_func = null ) : string	Return the where clause for a geometrical column.
_getRegexReplaceRows ( integer $columnIndex, string $find, string $replaceWith, string $charSet ) : array	Finds and returns Regex pattern and their replacements
_getSubTabs ( ) : array	Returns an array with necessary configurations to create sub-tabs in the table_select page.
_getWhereClause ( mixed $criteriaValues, string $names, string $types, string $func_type, boolean $unaryFlag, boolean $geom_func = null ) : string	Return the where clause for query generation based on the inputs provided.
_loadTableInfo ( ) : void	Gets all the columns of a table along with their types, collations and whether null or not.

Method Details

Property Details