Retrieve a specific bookmark
public static get ( string $db, mixed $id, string $id_field = 'id', boolean $action_bookmark_all = false, boolean $exact_user_match = false ) : |
||
$db | string | the current database name |
$id | mixed | an identifier of the bookmark to get |
$id_field | string | which field to look up the identifier |
$action_bookmark_all | boolean | true: get all bookmarks regardless of the owning user |
$exact_user_match | boolean | whether to ignore bookmarks with no user |
리턴 | the bookmark |
/** * Tests for Bookmark::get() * * @return void */ public function testGet() { $this->assertNull(Bookmark::get('phpmyadmin', '1')); }
$import_text = $bookmark->getQuery(); if ($GLOBALS['is_ajax_request'] == true) { $message = PMA\libraries\Message::success(__('Showing bookmark')); $response = PMA\libraries\Response::getInstance(); $response->setRequestStatus($message->isSuccess()); $response->addJSON('message', $message); $response->addJSON('sql_query', $import_text); $response->addJSON('action_bookmark', $_REQUEST['action_bookmark']); exit; } else { $run_query = false; } break; case 2: // bookmarked query that have to be deleted $bookmark = Bookmark::get($db, $id_bookmark); if (!empty($bookmark)) { $bookmark->delete(); if ($GLOBALS['is_ajax_request'] == true) { $message = PMA\libraries\Message::success(__('The bookmark has been deleted.')); $response = PMA\libraries\Response::getInstance(); $response->setRequestStatus($message->isSuccess()); $response->addJSON('message', $message); $response->addJSON('action_bookmark', $_REQUEST['action_bookmark']); $response->addJSON('id_bookmark', $id_bookmark); exit; } else { $run_query = false; $error = true; // this is kind of hack to skip processing the query }
/** * Function to get the default sql query for browsing page * * @param String $db the current database * @param String $table the current table * * @return String $sql_query the default $sql_query for browse page */ function PMA_getDefaultSqlQueryForBrowse($db, $table) { $bookmark = Bookmark::get($db, $table, 'label', false, true); if (!empty($bookmark) && !empty($bookmark->getQuery())) { $GLOBALS['using_bookmark_message'] = Message::notice(__('Using bookmark "%s" as default browse query.')); $GLOBALS['using_bookmark_message']->addParam($table); $GLOBALS['using_bookmark_message']->addMessage(PMA\libraries\Util::showDocu('faq', 'faq6-22')); $sql_query = $bookmark->getQuery(); } else { $defaultOrderByClause = ''; if (isset($GLOBALS['cfg']['TablePrimaryKeyOrder']) && $GLOBALS['cfg']['TablePrimaryKeyOrder'] !== 'NONE') { $primaryKey = null; $primary = PMA\libraries\Index::getPrimary($table, $db); if ($primary !== false) { $primarycols = $primary->getColumns(); foreach ($primarycols as $col) { $primaryKey = $col->getName(); break; } if ($primaryKey != null) { $defaultOrderByClause = ' ORDER BY ' . PMA\libraries\Util::backquote($table) . '.' . PMA\libraries\Util::backquote($primaryKey) . ' ' . $GLOBALS['cfg']['TablePrimaryKeyOrder']; } } } $sql_query = 'SELECT * FROM ' . PMA\libraries\Util::backquote($table) . $defaultOrderByClause; } return $sql_query; }