libraries/bookmark.lib.php3

   1 <?php
   2 /* $Id$ */
   3
   4
   5 /**
   6  * Set of functions used with the bookmark feature
   7  */
   8
   9
  10
  11 if (!defined('PMA_BOOKMARK_LIB_INCLUDED')){
  12     define('PMA_BOOKMARK_LIB_INCLUDED', 1);
  13
  14     /**
  15      * Defines the bookmark parameters for the current user
  16      *
  17      * @return  array    the bookmark parameters for the current user
  18      *
  19      * @global  integer  the id of the current server
  20      *
  21      * @access  public
  22      */
  23     function PMA_getBookmarksParam()
  24     {
  25         global $server;
  26
  27         $cfgBookmark = '';
  28
  29         // No server selected -> no bookmark table
  30         if ($server == 0) {
  31             return '';
  32         }
  33
  34         $cfgBookmark['user']  = $GLOBALS['cfg']['Server']['user'];
  35         $cfgBookmark['db']    = $GLOBALS['cfg']['Server']['pmadb'];
  36         $cfgBookmark['table'] = $GLOBALS['cfg']['Server']['bookmarktable'];
  37
  38         return $cfgBookmark;
  39     } // end of the 'PMA_getBookmarksParam()' function
  40
  41
  42     /**
  43      * Gets the list of bookmarks defined for the current database
  44      *
  45      * @param   string   the current database name
  46      * @param   array    the bookmark parameters for the current user
  47      *
  48      * @return  mixed    the bookmarks list if defined, false else
  49      *
  50      * @access  public
  51      */
  52     function PMA_listBookmarks($db, $cfgBookmark)
  53     {
  54         $query  = 'SELECT label, id FROM '. PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
  55                 . ' WHERE dbase = \'' . PMA_sqlAddslashes($db) . '\''
  56                 . ' AND user = \'' . PMA_sqlAddslashes($cfgBookmark['user']) . '\'';
  57         if (isset($GLOBALS['dbh'])) {
  58             $result = PMA_mysql_query($query, $GLOBALS['dbh']);
  59         } else {
  60             $result = PMA_mysql_query($query);
  61         }
  62
  63         // There is some bookmarks -> store them
  64         if ($result > 0 && mysql_num_rows($result) > 0) {
  65             $flag = 1;
  66             while ($row = PMA_mysql_fetch_row($result)) {
  67                 $bookmark_list[$flag . ' - ' . $row[0]] = $row[1];
  68                 $flag++;
  69             } // end while
  70             return $bookmark_list;
  71         }
  72         // No bookmarks for the current database
  73         else {
  74             return FALSE;
  75         }
  76     } // end of the 'PMA_listBookmarks()' function
  77
  78
  79     /**
  80      * Gets the sql command from a bookmark
  81      *
  82      * @param   string   the current database name
  83      * @param   array    the bookmark parameters for the current user
  84      * @param   integer  the id of the bookmark to get
  85      *
  86      * @return  string   the sql query
  87      *
  88      * @access  public
  89      */
  90     function PMA_queryBookmarks($db, $cfgBookmark, $id)
  91     {
  92         $query          = 'SELECT query FROM ' . PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
  93                         . ' WHERE dbase = \'' . PMA_sqlAddslashes($db) . '\''
  94                         . ' AND user = \'' . PMA_sqlAddslashes($cfgBookmark['user']) . '\''
  95                         . ' AND id = ' . $id;
  96         if (isset($GLOBALS['dbh'])) {
  97             $result = PMA_mysql_query($query, $GLOBALS['dbh']);
  98         } else {
  99             $result = PMA_mysql_query($query);
 100         }
 101         $bookmark_query = PMA_mysql_result($result, 0, 'query');
 102
 103         return $bookmark_query;
 104     } // end of the 'PMA_queryBookmarks()' function
 105
 106
 107     /**
 108      * Adds a bookmark
 109      *
 110      * @param   array    the properties of the bookmark to add
 111      * @param   array    the bookmark parameters for the current user
 112      *
 113      * @access  public
 114      */
 115     function PMA_addBookmarks($fields, $cfgBookmark)
 116     {
 117         $query = 'INSERT INTO ' . PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
 118                . ' (id, dbase, user, query, label) VALUES (\'\', \'' . PMA_sqlAddslashes($fields['dbase']) . '\', \'' . PMA_sqlAddslashes($fields['user']) . '\', \'' . PMA_sqlAddslashes(urldecode($fields['query'])) . '\', \'' . PMA_sqlAddslashes($fields['label']) . '\')';
 119         if (isset($GLOBALS['dbh'])) {
 120             $result = PMA_mysql_query($query, $GLOBALS['dbh']);
 121         } else {
 122             $result = PMA_mysql_query($query);
 123         }
 124     } // end of the 'PMA_addBookmarks()' function
 125
 126
 127     /**
 128      * Deletes a bookmark
 129      *
 130      * @param   string   the current database name
 131      * @param   array    the bookmark parameters for the current user
 132      * @param   integer  the id of the bookmark to get
 133      *
 134      * @access  public
 135      */
 136     function PMA_deleteBookmarks($db, $cfgBookmark, $id)
 137     {
 138         $query  = 'DELETE FROM ' . PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
 139                 . ' WHERE user = \'' . PMA_sqlAddslashes($cfgBookmark['user']) . '\''
 140                 . ' AND id = ' . $id;
 141         if (isset($GLOBALS['dbh'])) {
 142             $result = PMA_mysql_query($query, $GLOBALS['dbh']);
 143         } else {
 144             $result = PMA_mysql_query($query);
 145         }
 146     } // end of the 'PMA_deleteBookmarks()' function
 147
 148
 149     /**
 150      * Bookmark Support
 151      */
 152     $cfg['Bookmark'] = PMA_getBookmarksParam();
 153
 154
 155 } // $__PMA_BOOKMARK_LIB__
 156 ?>