PHP Article::FetchCountOf Examples

Example #1

File: public_user.php Project: Gerold103/lgmis

} else {
    $user = User::FetchBy(['eq_conds' => ['id' => $_REQUEST['id']], 'is_unique' => true]);
    $header = '';
    $content = '';
    $footer = '';
    $header_type = 'h3';
    $title = Language::Translit($user->GetSurname() . ' ' . $user->GetName() . ' ' . $user->GetFathername());
    $header = htmlspecialchars(Language::Translit($user->GetSurname() . ' ' . $user->GetName() . ' ' . $user->GetFathername()));
    $content .= '<div class="row" align="center">';
    $content .= '<div class="' . ColAllTypes(4) . '"><img src="' . Link::Get($user->GetPathToPhoto()) . '" class="img-avatar"></div>';
    $content .= '<div class="' . ColAllTypes(8) . '">';
    $content .= '<br><div class="row" align="center">';
    $content .= '<div class="' . ColAllTypes(6) . '" align="right"><font color="grey">' . Language::Word('position') . ':</font></div>';
    $content .= '<div class="' . ColAllTypes(6) . '" align="left">' . $user->GetPosition() . '</div>';
    $content .= '</div>';
    $articles = Article::FetchCountOf(['where' => 'author_id = ' . $user->GetID()]);
    $content .= '<div class="row" align="center">';
    $content .= '<div class="' . ColAllTypes(6) . '" align="right"><font color="grey">' . Language::Word('news published') . ':</font></div>';
    $content .= '<div class="' . ColAllTypes(6) . '" align="left">' . $articles . '</div>';
    $content .= '</div>';
    $content .= '<hr>';
    $content .= ToPageHeader(Language::PublicMenu('contacts'), 'h4', 'grey');
    $content .= '<div class="row" align="center">';
    $content .= '<div class="' . ColAllTypes(6) . '" align="right"><font color="grey">' . Language::Word('mail') . ':</font></div>';
    $content .= '<div class="' . ColAllTypes(6) . '" align="left"><a href="mailto:' . $user->GetEmail() . '">' . $user->GetEmail() . '</a></div>';
    $content .= '</div>';
    $content .= '</div>';
    $content .= '</div>';
    $content .= '<hr>';
    $blocks = UserBlock::FetchAllByAuthorID($user->GetID());
    $size = count($blocks);

Example #2

File: index.php Project: Gerold103/lgmis

require_once 'utility_lgmis_lib.php';
require_once $link_to_utility_authorization;
$header = '';
$content = '';
$footer = '';
$size = 0;
$from = -1;
$to = -1;
$pages = -1;
$cur_page = -1;
$need_pagination = true;
$head_addition = '';
//----D I S P L A Y----
//----A R T I C L E S----
if (!isset($_GET['content_type']) || $_GET['content_type'] == $content_types_short['articles']) {
    $size = Article::FetchCountOf();
    if ($size) {
        $head_addition = MakeScript('window_bottom_callbacks.push(Article.WindowBottomCallback);');
        $need_pagination = false;
        require $link_to_pagination_init_template;
        $limit = $to - $from + 1;
        $articles = Article::FetchBy(['limit' => $limit, 'offset' => $from, 'order_by' => 'id DESC']);
        $content .= '<div onscroll="scrolled(this);" id="articles_list">';
        for ($i = 0; $i < $limit; ++$i) {
            $atricle = $articles[$i];
            $content .= '<div class="pbl_article">' . $atricle->ToHTMLAutoShortForTable(GetUserPrivileges()) . '</div>';
            if ($i != $to) {
                $content .= '<hr><div style="background-color: #eeeeee;"><br></div><hr>';
            }
        }
        $content .= '</div>';