public static function GetArticlesByAuthor($p_authorId) { global $g_ado_db; $queryStr = 'SELECT fk_article_number, fk_language_id, fk_type_id FROM ' . self::TABLE . ' WHERE fk_author_id = ' . (int) $p_authorId; $rows = $g_ado_db->GetAll($queryStr); $returnArray = array(); foreach ((array) $rows as $row) { $article = new Article((int) $row['fk_language_id'], (int) $row['fk_article_number']); $type = new AuthorType((int) $row['fk_type_id']); $returnArray[] = array('article' => $article, 'type' => $type); } return $returnArray; }
<div class="textHolder omega"> <textarea name="txt_biography" id="txt_biography" rows="30" class="tinymce input_text_area"><?php echo $biography; ?></textarea> </div> </fieldset> <div class="clear"></div> </div> <?php if (is_object($author)) { ?> <div id="contentContainer"> <div class="space-box"></div> <fieldset class="frame"> <ul> <?php $authoringList = ArticleAuthor::GetArticlesByAuthor($author->getId()); $authoringCount = sizeof($authoringList); if ($authoringCount > 0) { ?> <li> <label><?php putGS('Total articles'); ?>:</label> <span><?php echo $authoringCount; ?></span></li> <?php foreach ($authoringList as $authoringItem) { $articleUrl = $Campsite['WEBSITE_URL'] . '/' . $ADMIN . '/articles/edit.php'; $articleUrl .= '?f_publication_id=' . $authoringItem['article']->getPublicationId() . '&f_issue_number=' . $authoringItem['article']->getIssueNumber() . '&f_section_number=' . $authoringItem['article']->getSectionNumber() . '&f_article_number=' . $authoringItem['article']->getArticleNumber() . '&f_language_id=' . $authoringItem['article']->getLanguageId(); ?> <li>