class Results

Handle all the functionalities related to displaying results of sql queries, stored procedure, browsing sql processes or displaying binary log.

Constants

NO_EDIT_OR_DELETE

UPDATE_ROW

DELETE_ROW

KILL_PROCESS

POSITION_LEFT

POSITION_RIGHT

POSITION_BOTH

POSITION_NONE

DISPLAY_FULL_TEXT

DISPLAY_PARTIAL_TEXT

HEADER_FLIP_TYPE_AUTO

HEADER_FLIP_TYPE_CSS

HEADER_FLIP_TYPE_FAKE

DATE_FIELD

DATETIME_FIELD

TIMESTAMP_FIELD

TIME_FIELD

STRING_FIELD

GEOMETRY_FIELD

BLOB_FIELD

BINARY_FIELD

RELATIONAL_KEY

RELATIONAL_DISPLAY_COLUMN

GEOMETRY_DISP_GEOM

GEOMETRY_DISP_WKT

GEOMETRY_DISP_WKB

SMART_SORT_ORDER

ASCENDING_SORT_DIR

DESCENDING_SORT_DIR

TABLE_TYPE_INNO_DB

ALL_ROWS

QUERY_TYPE_SELECT

ROUTINE_PROCEDURE

ROUTINE_FUNCTION

ACTION_LINK_CONTENT_ICONS

ACTION_LINK_CONTENT_TEXT

Properties

$transformation_info This variable contains the column transformation information for some of the system databases.
Template $template

Methods

__construct(string $db, string $table, int $server, string $goto, string $sql_query)

Constructor for PhpMyAdmin\Display\Results class

mixed|void
__get(string $property)

Get any property of this class

void
__set(string $property, mixed $value)

Set values for any property of this class

void
setProperties(integer $unlim_num_rows, stdClass $fields_meta, boolean $is_count, integer $is_export, boolean $is_func, integer $is_analyse, integer $num_rows, integer $fields_cnt, double $querytime, string $pmaThemeImage, string $text_dir, boolean $is_maint, boolean $is_explain, boolean $is_show, array $showtable, string $printview, string $url_query, boolean $editable, boolean $is_browse_dist)

Set properties which were not initialized at the constructor

void
setConfigParamsForDisplayTable()

Checks the posted options for viewing query results and sets appropriate values in the session.

string
getTable(integer $dt_result, array $displayParts, array $analyzed_sql_results, boolean $is_limited_display = false)

Prepare a table of results returned by a SQL query.

string
getCreateViewQueryResultOp(array $analyzed_sql_results)

Calls the _getResultsOperations with $only_view as true

Details

at line 221
__construct(string $db, string $table, int $server, string $goto, string $sql_query)

Constructor for PhpMyAdmin\Display\Results class

Parameters

string $db the database name
string $table the table name
int $server the server id
string $goto the URL to go back in case of errors
string $sql_query the SQL query

at line 244
mixed|void __get(string $property)

Get any property of this class

Parameters

string $property name of the property

Return Value

mixed|void if property exist, value of the relevant property

at line 257
void __set(string $property, mixed $value)

Set values for any property of this class

Parameters

string $property name of the property
mixed $value value to set

Return Value

void

at line 421
void setProperties(integer $unlim_num_rows, stdClass $fields_meta, boolean $is_count, integer $is_export, boolean $is_func, integer $is_analyse, integer $num_rows, integer $fields_cnt, double $querytime, string $pmaThemeImage, string $text_dir, boolean $is_maint, boolean $is_explain, boolean $is_show, array $showtable, string $printview, string $url_query, boolean $editable, boolean $is_browse_dist)

Set properties which were not initialized at the constructor

Parameters

integer $unlim_num_rows the total number of rows returned by the SQL query without any appended "LIMIT" clause programmatically
stdClass $fields_meta meta information about fields
boolean $is_count statement is SELECT COUNT
integer $is_export statement contains INTO OUTFILE
boolean $is_func statement contains a function like SUM()
integer $is_analyse statement contains PROCEDURE ANALYSE
integer $num_rows total no. of rows returned by SQL query
integer $fields_cnt total no.of fields returned by SQL query
double $querytime time taken for execute the SQL query
string $pmaThemeImage path for theme images directory
string $text_dir text direction
boolean $is_maint statement contains a maintenance command
boolean $is_explain statement contains EXPLAIN
boolean $is_show statement contains SHOW
array $showtable table definitions
string $printview print view was requested
string $url_query URL query
boolean $editable whether the results set is editable
boolean $is_browse_dist whether browsing distinct values

Return Value

void

at line 3947
void setConfigParamsForDisplayTable()

Checks the posted options for viewing query results and sets appropriate values in the session.

Return Value

void

at line 4105
string getTable(integer $dt_result, array $displayParts, array $analyzed_sql_results, boolean $is_limited_display = false)

Prepare a table of results returned by a SQL query.

Parameters

integer $dt_result the link id associated to the query which results have to be displayed
array $displayParts the parts to display
array $analyzed_sql_results analyzed sql results
boolean $is_limited_display With limited operations or not

Return Value

string Generated HTML content for resulted table

at line 4809
string getCreateViewQueryResultOp(array $analyzed_sql_results)

Calls the _getResultsOperations with $only_view as true

Parameters

array $analyzed_sql_results analyzed sql results

Return Value

string