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)

No description

mixed|null
__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(int $unlim_num_rows, stdClass $fields_meta, bool $is_count, int $is_export, bool $is_func, int $is_analyse, int $num_rows, int $fields_cnt, double $querytime, string $pmaThemeImage, string $text_dir, bool $is_maint, bool $is_explain, bool $is_show, array $showtable, string $printview, string $url_query, bool $editable, bool $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(int $dt_result, array $displayParts, array $analyzed_sql_results, bool $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 250
__construct(string $db, string $table, int $server, string $goto, string $sql_query)

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 273
mixed|null __get(string $property)

Get any property of this class

Parameters

string $property name of the property

Return Value

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

at line 286
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 450
void setProperties(int $unlim_num_rows, stdClass $fields_meta, bool $is_count, int $is_export, bool $is_func, int $is_analyse, int $num_rows, int $fields_cnt, double $querytime, string $pmaThemeImage, string $text_dir, bool $is_maint, bool $is_explain, bool $is_show, array $showtable, string $printview, string $url_query, bool $editable, bool $is_browse_dist)

Set properties which were not initialized at the constructor

Parameters

int $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
bool $is_count statement is SELECT COUNT
int $is_export statement contains INTO OUTFILE
bool $is_func statement contains a function like SUM()
int $is_analyse statement contains PROCEDURE ANALYSE
int $num_rows total no. of rows returned by SQL query
int $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
bool $is_maint statement contains a maintenance command
bool $is_explain statement contains EXPLAIN
bool $is_show statement contains SHOW
array $showtable table definitions
string $printview print view was requested
string $url_query URL query
bool $editable whether the results set is editable
bool $is_browse_dist whether browsing distinct values

Return Value

void

at line 3953
void setConfigParamsForDisplayTable()

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

Return Value

void

at line 4110
string getTable(int $dt_result, array $displayParts, array $analyzed_sql_results, bool $is_limited_display = false)

Prepare a table of results returned by a SQL query.

Parameters

int $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
bool $is_limited_display With limited operations or not

Return Value

string Generated HTML content for resulted table

at line 4803
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