PMA\libraries\navigation\nodes\Node::getNavigationHidingData PHP Method

getNavigationHidingData() public method

Gets the count of hidden elements for each database
public getNavigationHidingData ( ) : array
return array array containing the count of hidden elements for each database
    public function getNavigationHidingData()
    {
        $cfgRelation = PMA_getRelationsParam();
        if ($cfgRelation['navwork']) {
            $navTable = Util::backquote($cfgRelation['db']) . "." . Util::backquote($cfgRelation['navigationhiding']);
            $sqlQuery = "SELECT `db_name`, COUNT(*) AS `count` FROM " . $navTable . " WHERE `username`='" . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']) . "'" . " GROUP BY `db_name`";
            $counts = $GLOBALS['dbi']->fetchResult($sqlQuery, 'db_name', 'count', $GLOBALS['controllink']);
            return $counts;
        }
        return null;
    }