REDAXO Forum

Code: Alles auswählen

       
       $links = '';
            
            $qry = 'SELECT id, parent_id, clang_id, startarticle, name, updateuser, updatedate
                    FROM ' . rex::getTable('article') . ' 
                    '. $where .' 
                    ORDER BY updatedate DESC
                    LIMIT 8';
            $datas = rex_sql::factory()->getArray($qry);

         

   if (!count($datas)) {
			   $link .= '<div class="alert">Keine Einträge gefunden</div>';
			}
            
            
            if (count($datas)) {
                foreach ($datas as $data) {
                    $lang = rex_clang::get($data['clang_id']);
                    $langcode = $lang->getCode();
                    if ($langcode) {
                        $langcode = '<i class="fa fa-flag-o" aria-hidden="true"></i> ' . $langcode . ' - ';
                    }
                   $date = rex_formatter::strftime(strtotime($data['updatedate']), 'datetime');
                   $attributes = [
                        'href' => rex_url::backendPage('content/edit',
                            [
                                'mode' => 'edit',
                                'clang' => $data['clang_id'],
                                'article_id' => $data['id']
                            ]
                        )
                    ];
                    $links .= '<a class="list-group-item"  href="'.rex_getUrl($data['id']).'" title="' . $data['name'] . '">' . $data['name'] . '<span class="badge"><i class="fa fa-calendar-o" aria-hidden="true"></i> ' . $date . '</span></a>';
                }                
            }
            
            echo $links;