| Server IP : 74.208.127.88 / Your IP : 3.134.110.4 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/share/phpmyadmin/ |
Upload File : |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* handle row specific actions like edit, delete, export
*
* @package PhpMyAdmin
*/
use PhpMyAdmin\Response;
use PhpMyAdmin\Sql;
use PhpMyAdmin\Url;
/**
*
*/
require_once '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 = array();
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 '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 = array();
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 '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 '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
);
}
}