File Manager

003 File Manager

Current Path: /usr/local/www/sites/shared/phpmyadmin

usr / local / www / sites / shared / phpmyadmin /

📁 ..
📄 .editorconfig(274 B)
📄 .eslintignore(24 B)
📄 .eslintrc.json(1.3 KB)
📄 CODE_OF_CONDUCT.md(3.14 KB)
📄 CONTRIBUTING.md(2.05 KB)
📄 ChangeLog(9.35 KB)
📄 DCO(1.77 KB)
📄 LICENSE(17.67 KB)
📄 README(1.49 KB)
📄 RELEASE-DATE-4.9.0.1(29 B)
📄 admin.php(5.23 KB)
📄 ajax.php(1.52 KB)
📄 browse_foreigners.php(1.71 KB)
📄 changelog.php(3.12 KB)
📄 chk_rel.php(856 B)
📄 composer.json(3.11 KB)
📄 composer.lock(91.76 KB)
📄 config.inc.php(188 B)
📄 config.sample.inc.php(4.41 KB)
📄 db_central_columns.php(5.54 KB)
📄 db_datadict.php(5.74 KB)
📄 db_designer.php(7.37 KB)
📄 db_events.php(271 B)
📄 db_export.php(4.52 KB)
📄 db_import.php(899 B)
📄 db_multi_table_query.php(1.01 KB)
📄 db_operations.php(9.63 KB)
📄 db_qbe.php(4.75 KB)
📄 db_routines.php(365 B)
📄 db_search.php(1.95 KB)
📄 db_sql.php(952 B)
📄 db_sql_autocomplete.php(746 B)
📄 db_sql_format.php(485 B)
📄 db_structure.php(1011 B)
📄 db_tracking.php(4.31 KB)
📄 db_triggers.php(273 B)
📁 doc
📄 error_report.php(4.5 KB)
📁 examples
📄 export.php(15.55 KB)
📄 favicon.ico(21.96 KB)
📄 gis_data_editor.php(15.61 KB)
📄 import.php(23.41 KB)
📄 import_status.php(3.32 KB)
📄 index.php(26.72 KB)
📄 input.php(1.49 KB)
📁 js
📁 libraries
📄 license.php(894 B)
📄 lint.php(1.4 KB)
📁 locale
📄 logout.php(311 B)
📄 navigation.php(2.25 KB)
📄 normalization.php(4.05 KB)
📄 package.json(729 B)
📄 phpcs.xml.dist(467 B)
📄 phpinfo.php(507 B)
📄 phpmyadmin.css.php(740 B)
📄 prefs_forms.php(2.43 KB)
📄 prefs_manage.php(14.02 KB)
📄 prefs_twofactor.php(1.56 KB)
📄 print.css(1.18 KB)
📄 robots.txt(26 B)
📄 schema_export.php(659 B)
📄 server_binlog.php(785 B)
📄 server_collations.php(818 B)
📄 server_databases.php(798 B)
📄 server_engines.php(784 B)
📄 server_export.php(1.06 KB)
📄 server_import.php(634 B)
📄 server_plugins.php(784 B)
📄 server_privileges.php(13.86 KB)
📄 server_replication.php(2.38 KB)
📄 server_sql.php(698 B)
📄 server_status.php(897 B)
📄 server_status_advisor.php(862 B)
📄 server_status_monitor.php(2.89 KB)
📄 server_status_processes.php(1.83 KB)
📄 server_status_queries.php(1.39 KB)
📄 server_status_variables.php(1.53 KB)
📄 server_user_groups.php(1.82 KB)
📄 server_variables.php(798 B)
📁 setup
📄 show_config_errors.php(1.02 KB)
📁 sql
📄 sql.php(5.98 KB)
📄 tbl_addfield.php(3.67 KB)
📄 tbl_change.php(6.2 KB)
📄 tbl_chart.php(972 B)
📄 tbl_create.php(3.29 KB)
📄 tbl_export.php(4.24 KB)
📄 tbl_find_replace.php(999 B)
📄 tbl_get_field.php(1.42 KB)
📄 tbl_gis_visualization.php(1.21 KB)
📄 tbl_import.php(684 B)
📄 tbl_indexes.php(1.37 KB)
📄 tbl_operations.php(14.99 KB)
📄 tbl_recent_favorite.php(452 B)
📄 tbl_relation.php(2.32 KB)
📄 tbl_replace.php(16.57 KB)
📄 tbl_row_action.php(4.89 KB)
📄 tbl_select.php(1.1 KB)
📄 tbl_sql.php(1.15 KB)
📄 tbl_structure.php(1.99 KB)
📄 tbl_tracking.php(5.66 KB)
📄 tbl_triggers.php(141 B)
📄 tbl_zoom_select.php(1.02 KB)
📁 templates
📁 themes
📄 themes.php(956 B)
📁 tmp
📄 transformation_overview.php(1.87 KB)
📄 transformation_wrapper.php(4.51 KB)
📄 url.php(1.27 KB)
📄 user_password.php(1.89 KB)
📁 vendor
📄 version_check.php(1.06 KB)
📄 view_create.php(6.45 KB)
📄 view_operations.php(3.78 KB)
📄 yarn.lock(28.35 KB)

Editing: db_qbe.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * query by example the whole database
 *
 * @package PhpMyAdmin
 */
use PhpMyAdmin\Database\Qbe;
use PhpMyAdmin\Message;
use PhpMyAdmin\Relation;
use PhpMyAdmin\Response;
use PhpMyAdmin\SavedSearches;
use PhpMyAdmin\Sql;
use PhpMyAdmin\Template;
use PhpMyAdmin\Url;
use PhpMyAdmin\Util;

/**
 * requirements
 */
require_once 'libraries/common.inc.php';

$response = Response::getInstance();
$relation = new Relation();

// Gets the relation settings
$cfgRelation = $relation->getRelationsParam();

$savedSearchList = array();
$savedSearch = null;
$currentSearchId = null;
if ($cfgRelation['savedsearcheswork']) {
    $header = $response->getHeader();
    $scripts = $header->getScripts();
    $scripts->addFile('db_qbe.js');

//Get saved search list.
    $savedSearch = new SavedSearches($GLOBALS);
    $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
        ->setDbname($GLOBALS['db']);

if (!empty($_POST['searchId'])) {
        $savedSearch->setId($_POST['searchId']);
    }

//Action field is sent.
    if (isset($_POST['action'])) {
        $savedSearch->setSearchName($_POST['searchName']);
        if ('create' === $_POST['action']) {
            $saveResult = $savedSearch->setId(null)
                ->setCriterias($_POST)
                ->save();
        } elseif ('update' === $_POST['action']) {
            $saveResult = $savedSearch->setCriterias($_POST)
                ->save();
        } elseif ('delete' === $_POST['action']) {
            $deleteResult = $savedSearch->delete();
            //After deletion, reset search.
            $savedSearch = new SavedSearches($GLOBALS);
            $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
                ->setDbname($GLOBALS['db']);
            $_POST = array();
        } elseif ('load' === $_POST['action']) {
            if (empty($_POST['searchId'])) {
                //when not loading a search, reset the object.
                $savedSearch = new SavedSearches($GLOBALS);
                $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
                    ->setDbname($GLOBALS['db']);
                $_POST = array();
            } else {
                $loadResult = $savedSearch->load();
            }
        }
        //Else, it's an "update query"
    }

$savedSearchList = $savedSearch->getList();
    $currentSearchId = $savedSearch->getId();
}

/**
 * A query has been submitted -> (maybe) execute it
 */
$message_to_display = false;
if (isset($_POST['submit_sql']) && ! empty($sql_query)) {
    if (! preg_match('@^SELECT@i', $sql_query)) {
        $message_to_display = true;
    } else {
        $goto = 'db_sql.php';
        $sql = new Sql();
        $sql->executeQueryAndSendQueryResponse(
            null, // analyzed_sql_results
            false, // is_gotofile
            $_POST['db'], // db
            null, // table
            false, // 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
        );
    }
}

$sub_part  = '_qbe';
require 'libraries/db_common.inc.php';
$url_query .= '&amp;goto=db_qbe.php';
$url_params['goto'] = 'db_qbe.php';

list(
    $tables,
    $num_tables,
    $total_num_tables,
    $sub_part,
    $is_show_stats,
    $db_is_system_schema,
    $tooltip_truename,
    $tooltip_aliasname,
    $pos
) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');

if ($message_to_display) {
    Message::error(
        __('You have to choose at least one column to display!')
    )
        ->display();
}
unset($message_to_display);

// create new qbe search instance
$db_qbe = new Qbe($GLOBALS['db'], $savedSearchList, $savedSearch);

$secondaryTabs = [
    'multi' => [
        'link' => 'db_multi_table_query.php',
        'text' => __('Multi-table query'),
    ],
    'qbe' => [
        'link' => 'db_qbe.php',
        'text' => __('Query by example'),
    ],
];
$response->addHTML(
    Template::get('secondary_tabs')->render([
        'url_params' => $url_params,
        'sub_tabs' => $secondaryTabs,
    ])
);

$url = 'db_designer.php' . Url::getCommon(
    array_merge(
        $url_params,
        array('query' => 1)
    )
);
$response->addHTML(
    Message::notice(
        sprintf(
            __('Switch to %svisual builder%s'),
            '<a href="' . $url . '">',
            '</a>'
        )
    )
);

/**
 * Displays the Query by example form
 */
$response->addHTML($db_qbe->getSelectionForm());

003 File Manager

Editing: db_qbe.php

Upload File

Create Folder