PMA\libraries\Table::getUiPrefsFromDb PHP Method

getUiPrefsFromDb() protected method

Return UI preferences for this table from phpMyAdmin database.
protected getUiPrefsFromDb ( ) : array
return array
    protected function getUiPrefsFromDb()
    {
        $cfgRelation = PMA_getRelationsParam();
        $pma_table = Util::backquote($cfgRelation['db']) . "." . Util::backquote($cfgRelation['table_uiprefs']);
        // Read from phpMyAdmin database
        $sql_query = " SELECT `prefs` FROM " . $pma_table . " WHERE `username` = '" . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']) . "'" . " AND `db_name` = '" . $GLOBALS['dbi']->escapeString($this->_db_name) . "'" . " AND `table_name` = '" . $GLOBALS['dbi']->escapeString($this->_name) . "'";
        $row = $this->_dbi->fetchArray(PMA_queryAsControlUser($sql_query));
        if (isset($row[0])) {
            return json_decode($row[0], true);
        } else {
            return array();
        }
    }