PHP PMA_Bookmark_applyVariables Examples

Example #1

File: import.php Project: rclakmal/phpmyadmin

$go_sql = false;
$executed_queries = 0;
$run_query = true;
$charset_conversion = false;
$reset_charset = false;
$bookmark_created = false;
// Bookmark Support: get a query back from bookmark if required
if (!empty($_REQUEST['id_bookmark'])) {
    $id_bookmark = (int) $_REQUEST['id_bookmark'];
    include_once 'libraries/bookmark.lib.php';
    switch ($_REQUEST['action_bookmark']) {
        case 0:
            // bookmarked query that have to be run
            $import_text = PMA_Bookmark_get($db, $id_bookmark, 'id', isset($_REQUEST['action_bookmark_all']));
            if (!empty($_REQUEST['bookmark_variable'])) {
                $import_text = PMA_Bookmark_applyVariables($import_text);
            }
            // refresh navigation and main panels
            if (preg_match('/^(DROP)\\s+(VIEW|TABLE|DATABASE|SCHEMA)\\s+/i', $import_text)) {
                $GLOBALS['reload'] = true;
                $ajax_reload['reload'] = true;
            }
            // refresh navigation panel only
            if (preg_match('/^(CREATE|ALTER)\\s+(VIEW|TABLE|DATABASE|SCHEMA)\\s+/i', $import_text)) {
                $ajax_reload['reload'] = true;
            }
            break;
        case 1:
            // bookmarked query that have to be displayed
            $import_text = PMA_Bookmark_get($db, $id_bookmark);
            if ($GLOBALS['is_ajax_request'] == true) {

Example #2

File: import.php Project: xtreme-jamil-shamy/phpmyadmin-cf

$go_sql = false;
$executed_queries = 0;
$run_query = true;
$charset_conversion = false;
$reset_charset = false;
$bookmark_created = false;
// Bookmark Support: get a query back from bookmark if required
if (!empty($_REQUEST['id_bookmark'])) {
    $id_bookmark = (int) $_REQUEST['id_bookmark'];
    include_once 'libraries/bookmark.lib.php';
    switch ($_REQUEST['action_bookmark']) {
        case 0:
            // bookmarked query that have to be run
            $import_text = PMA_Bookmark_get($db, $id_bookmark, 'id', isset($_REQUEST['action_bookmark_all']));
            if (!empty($_REQUEST['bookmark_variable'])) {
                $import_text = PMA_Bookmark_applyVariables($import_text, $_REQUEST['bookmark_variable']);
            }
            // refresh navigation and main panels
            if (preg_match('/^(DROP)\\s+(VIEW|TABLE|DATABASE|SCHEMA)\\s+/i', $import_text)) {
                $GLOBALS['reload'] = true;
            }
            // refresh navigation panel only
            if (preg_match('/^(CREATE|ALTER)\\s+(VIEW|TABLE|DATABASE|SCHEMA)\\s+/i', $import_text)) {
                if (!isset($ajax_reload)) {
                    $ajax_reload = array();
                }
                $ajax_reload['reload'] = true;
            }
            break;
        case 1:
            // bookmarked query that have to be displayed