/** * Function to store the query as a bookmark * * @param String $db the current database * @param String $bkm_user the bookmarking user * @param String $sql_query_for_bookmark the query to be stored in bookmark * @param String $bkm_label bookmark label * @param boolean $bkm_replace whether to replace existing bookmarks * * @return void */ function PMA_storeTheQueryAsBookmark($db, $bkm_user, $sql_query_for_bookmark, $bkm_label, $bkm_replace) { include_once 'libraries/bookmark.lib.php'; $bfields = array('bkm_database' => $db, 'bkm_user' => $bkm_user, 'bkm_sql_query' => urlencode($sql_query_for_bookmark), 'bkm_label' => $bkm_label); // Should we replace bookmark? if (isset($bkm_replace)) { $bookmarks = PMA_Bookmark_getList($db); foreach ($bookmarks as $key => $val) { if ($val == $bkm_label) { PMA_Bookmark_delete($key); } } } PMA_Bookmark_save($bfields, isset($_POST['bkm_all_users'])); }
/** * Test for PMA_Bookmark_delete * * @return void */ public function testDelete() { $this->assertFalse(PMA_Bookmark_delete('1')); }
// end bookmarks reading // Do no run query if we show PHP code if (isset($GLOBALS['show_as_php'])) { $run_query = FALSE; $go_sql = TRUE; } // Store the query as a bookmark before executing it if bookmarklabel was given if (!empty($bkm_label) && !empty($import_text)) { require_once './libraries/bookmark.lib.php'; $bfields = array('dbase' => $db, 'user' => $cfg['Bookmark']['user'], 'query' => urlencode($import_text), 'label' => $bkm_label); // Should we replace bookmark? if (isset($bkm_replace)) { $bookmarks = PMA_Bookmark_getList($db); foreach ($bookmarks as $key => $val) { if ($val == $bkm_label) { PMA_Bookmark_delete($db, $key); } } } PMA_Bookmark_save($bfields, isset($bkm_all_users)); $bookmark_created = TRUE; } // end store bookmarks // We can not read all at once, otherwise we can run out of memory $memory_limit = trim(@ini_get('memory_limit')); // 2 MB as default if (empty($memory_limit)) { $memory_limit = 2 * 1024 * 1024; } // In case no memory limit we work on 10MB chunks if ($memory_limit == -1) {
if ($GLOBALS['is_ajax_request'] == true) { $message = PMA_Message::success(__('Showing bookmark')); $response = PMA_Response::getInstance(); $response->isSuccess($message->isSuccess()); $response->addJSON('message', $message); $response->addJSON('sql_query', $import_text); $response->addJSON('action_bookmark', $action_bookmark); exit; } else { $run_query = false; } break; case 2: // bookmarked query that have to be deleted $import_text = PMA_Bookmark_get($db, $id_bookmark); PMA_Bookmark_delete($id_bookmark); if ($GLOBALS['is_ajax_request'] == true) { $message = PMA_Message::success(__('The bookmark has been deleted.')); $response = PMA_Response::getInstance(); $response->isSuccess($message->isSuccess()); $response->addJSON('message', $message); $response->addJSON('action_bookmark', $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 } break; }
/** * Test for PMA_Bookmark_delete * * @return void */ public function testPMA_Bookmark_delete() { $this->assertFalse( PMA_Bookmark_delete('phpmyadmin', '1') ); }
/** * Test for PMA_Bookmark_delete */ public function testPMA_Bookmark_delete(){ if (! function_exists('PMA_DBI_try_query')) { function PMA_DBI_try_query() { return false; } } $this->assertFalse( PMA_Bookmark_delete('phpmyadmin', '1') ); }