PHP PMA_Bookmark_delete函數代碼示例

/**
 * 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')
     );
 }