PHP HTML_banners::showBanners Examples

Example #1

File: admin.banners.php Project: cwcw/cms

function viewBanners($option)
{
    global $database, $mainframe, $mosConfig_list_limit;
    $limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
    $limitstart = $mainframe->getUserStateFromRequest("viewban{$option}limitstart", 'limitstart', 0);
    // get the total number of records
    $database->setQuery("SELECT count(*) FROM #__banner");
    $total = $database->loadResult();
    require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php';
    $pageNav = new mosPageNav($total, $limitstart, $limit);
    $query = "SELECT b.*, u.name as editor FROM #__banner as b " . "\n LEFT JOIN #__users AS u ON u.id = b.checked_out" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit}";
    $database->setQuery($query);
    if (!($result = $database->query())) {
        echo $database->stderr();
        return false;
    }
    $rows = $database->loadObjectList();
    HTML_banners::showBanners($rows, $pageNav, $option);
}

Example #2

File: admin.banners.php Project: patricmutwiri/joomlaclube

function viewBanners($option)
{
    global $database, $mainframe, $mosConfig_list_limit;
    $limit = intval($mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit));
    $limitstart = intval($mainframe->getUserStateFromRequest("viewban{$option}limitstart", 'limitstart', 0));
    // get the total number of records
    $query = "SELECT COUNT(*)" . "\n FROM #__banner";
    $database->setQuery($query);
    $total = $database->loadResult();
    require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php';
    $pageNav = new mosPageNav($total, $limitstart, $limit);
    $query = "SELECT b.*, u.name AS editor" . "\n FROM #__banner AS b " . "\n LEFT JOIN #__users AS u ON u.id = b.checked_out";
    $database->setQuery($query, $pageNav->limitstart, $pageNav->limit);
    $rows = $database->loadObjectList();
    HTML_banners::showBanners($rows, $pageNav, $option);
}