Viewing file: tbl_select.php (2.18 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Handles table search tab * * display table search form, create SQL query from form data * and call PMA_executeQueryAndSendQueryResponse() to execute it * * @package PhpMyAdmin */
/** * Gets some core libraries */ require_once 'libraries/common.inc.php'; require_once 'libraries/mysql_charsets.inc.php'; require_once 'libraries/TableSearch.class.php'; require_once 'libraries/sql.lib.php';
$response = PMA_Response::getInstance(); $header = $response->getHeader(); $scripts = $header->getScripts(); $scripts->addFile('makegrid.js'); $scripts->addFile('sql.js'); $scripts->addFile('tbl_select.js'); $scripts->addFile('tbl_change.js'); $scripts->addFile('jquery/jquery-ui-timepicker-addon.js'); $scripts->addFile('jquery/jquery.uitablefilter.js'); $scripts->addFile('gis_data_editor.js');
$table_search = new PMA_TableSearch($db, $table, "normal");
/** * No selection criteria received -> display the selection form */ if (! isset($_POST['columnsToDisplay']) && ! isset($_POST['displayAllColumns'])) { // Gets some core libraries include_once 'libraries/tbl_common.inc.php'; //$err_url = 'tbl_select.php' . $err_url; $url_query .= '&goto=tbl_select.php&back=tbl_select.php'; /** * Gets table's information */ include_once 'libraries/tbl_info.inc.php';
if (! isset($goto)) { $goto = $GLOBALS['cfg']['DefaultTabTable']; } // Defines the url to return to in case of error in the next sql statement $err_url = $goto . '?' . PMA_URL_getCommon($db, $table); // Displays the table search form $response->addHTML($table_search->getSecondaryTabs()); $response->addHTML($table_search->getSelectionForm($goto));
} else { /** * Selection criteria have been submitted -> do the work */ $sql_query = $table_search->buildSqlQuery();
/** * Parse and analyze the query */ include_once 'libraries/parse_analyze.inc.php';
PMA_executeQueryAndSendQueryResponse( $analyzed_sql_results, false, $db, $table, null, null, null, false, null, null, null, null, $goto, $pmaThemeImage, null, null, null, $sql_query, null, null ); } ?>
|