PMA\libraries\SavedSearches::delete PHP Method

delete() public method

Delete the search
public delete ( ) : boolean
return boolean
    public function delete()
    {
        if (null == $this->getId()) {
            $message = Message::error(__('Missing information to delete the search.'));
            $response = Response::getInstance();
            $response->setRequestStatus($message->isSuccess());
            $response->addJSON('fieldWithError', 'searchId');
            $response->addJSON('message', $message);
            exit;
        }
        $savedSearchesTbl = Util::backquote($this->_config['cfgRelation']['db']) . "." . Util::backquote($this->_config['cfgRelation']['savedsearches']);
        $sqlQuery = "DELETE FROM " . $savedSearchesTbl . "WHERE id = '" . $GLOBALS['dbi']->escapeString($this->getId()) . "'";
        return (bool) PMA_queryAsControlUser($sqlQuery);
    }

Usage Example

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