diff options
Diffstat (limited to 'srcs/phpmyadmin/tbl_row_action.php')
| -rw-r--r-- | srcs/phpmyadmin/tbl_row_action.php | 180 |
1 files changed, 180 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/tbl_row_action.php b/srcs/phpmyadmin/tbl_row_action.php new file mode 100644 index 0000000..b26f1ec --- /dev/null +++ b/srcs/phpmyadmin/tbl_row_action.php @@ -0,0 +1,180 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * handle row specific actions like edit, delete, export + * + * @package PhpMyAdmin + */ +declare(strict_types=1); + +use PhpMyAdmin\Response; +use PhpMyAdmin\Sql; +use PhpMyAdmin\Url; + +if (! defined('ROOT_PATH')) { + define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR); +} + +global $db, $pmaThemeImage, $sql_query, $table; + +require_once ROOT_PATH . 'libraries/common.inc.php'; + +if (isset($_POST['submit_mult'])) { + $submit_mult = $_POST['submit_mult']; + // workaround for IE problem: +} elseif (isset($_POST['submit_mult_delete_x'])) { + $submit_mult = 'row_delete'; +} elseif (isset($_POST['submit_mult_change_x'])) { + $submit_mult = 'row_edit'; +} elseif (isset($_POST['submit_mult_export_x'])) { + $submit_mult = 'row_export'; +} + +// If the 'Ask for confirmation' button was pressed, this can only come +// from 'delete' mode, so we set it straight away. +if (isset($_POST['mult_btn'])) { + $submit_mult = 'row_delete'; +} + +if (! isset($submit_mult)) { + $submit_mult = 'row_edit'; +} + +switch ($submit_mult) { + case 'row_delete': + case 'row_edit': + case 'row_copy': + case 'row_export': + // leave as is + break; + + case 'export': + $submit_mult = 'row_export'; + break; + + case 'delete': + $submit_mult = 'row_delete'; + break; + + case 'copy': + $submit_mult = 'row_copy'; + break; + + case 'edit': + default: + $submit_mult = 'row_edit'; + break; +} + +if (! empty($submit_mult)) { + if (isset($_POST['goto']) + && (! isset($_POST['rows_to_delete']) + || ! is_array($_POST['rows_to_delete'])) + ) { + $response = Response::getInstance(); + $response->setRequestStatus(false); + $response->addJSON('message', __('No row selected.')); + } + + switch ($submit_mult) { + /** @noinspection PhpMissingBreakStatementInspection */ + case 'row_copy': + $_POST['default_action'] = 'insert'; + // no break to allow for fallthough + case 'row_edit': + // As we got the rows to be edited from the + // 'rows_to_delete' checkbox, we use the index of it as the + // indicating WHERE clause. Then we build the array which is used + // for the tbl_change.php script. + $where_clause = []; + if (isset($_POST['rows_to_delete']) + && is_array($_POST['rows_to_delete']) + ) { + foreach ($_POST['rows_to_delete'] as $i => $i_where_clause) { + $where_clause[] = $i_where_clause; + } + } + $active_page = 'tbl_change.php'; + include ROOT_PATH . 'tbl_change.php'; + break; + + case 'row_export': + // Needed to allow SQL export + $single_table = true; + + // As we got the rows to be exported from the + // 'rows_to_delete' checkbox, we use the index of it as the + // indicating WHERE clause. Then we build the array which is used + // for the tbl_change.php script. + $where_clause = []; + if (isset($_POST['rows_to_delete']) + && is_array($_POST['rows_to_delete']) + ) { + foreach ($_POST['rows_to_delete'] as $i => $i_where_clause) { + $where_clause[] = $i_where_clause; + } + } + $active_page = 'tbl_export.php'; + include ROOT_PATH . 'tbl_export.php'; + break; + + case 'row_delete': + default: + $action = 'tbl_row_action.php'; + $err_url = 'tbl_row_action.php' + . Url::getCommon($GLOBALS['url_params']); + if (! isset($_POST['mult_btn'])) { + $original_sql_query = $sql_query; + if (! empty($url_query)) { + $original_url_query = $url_query; + } + } + include ROOT_PATH . 'libraries/mult_submits.inc.php'; + $_url_params = $GLOBALS['url_params']; + $_url_params['goto'] = 'tbl_sql.php'; + $url_query = Url::getCommon($_url_params); + + + /** + * Show result of multi submit operation + */ + // sql_query is not set when user does not confirm multi-delete + if ((! empty($submit_mult) || isset($_POST['mult_btn'])) + && ! empty($sql_query) + ) { + $disp_message = __('Your SQL query has been executed successfully.'); + $disp_query = $sql_query; + } + + if (isset($original_sql_query)) { + $sql_query = $original_sql_query; + } + + if (isset($original_url_query)) { + $url_query = $original_url_query; + } + + $active_page = 'sql.php'; + $sql = new Sql(); + $sql->executeQueryAndSendQueryResponse( + null, // analyzed_sql_results + false, // is_gotofile + $db, // db + $table, // table + null, // find_real_end + null, // sql_query_for_bookmark + null, // extra_data + null, // message_to_show + null, // message + null, // sql_data + $goto, // goto + $pmaThemeImage, // pmaThemeImage + null, // disp_query + null, // disp_message + null, // query_type + $sql_query, // sql_query + null, // selectedTables + null // complete_query + ); + } +} |