Esempio n. 1
0
$hitungjumlah = $koneksi_db->sql_query("SELECT * FROM artikel WHERE publikasi=1 and month(tgl)='{$bulan}' and year(tgl)='{$tahun}'  ORDER BY hits DESC LIMIT {$awal},{$jml}");
$jumlah = $koneksi_db->sql_numrows($hitungjumlah);
if ($jumlah > 1) {
    $perintah = "SELECT * FROM artikel WHERE publikasi=1 ORDER BY hits DESC LIMIT {$awal},{$jml}";
    $hasil = mysql_query($perintah);
    echo '<div id="terpopuler"><ul class="ui-tabs-nav">';
    while ($data = $koneksi_db->sql_fetchrow($hasil)) {
        $judul = AuraCMSSEO($data[1]);
        $gambar = $data['gambar'] == '' ? '<img src="mod/news/images/normal/news-default.jpg">' : '<img src="mod/news/images/normal/' . $data['gambar'] . '">';
        //$id = $data[0];
        echo '<li class="ui-tabs-nav-item">';
        echo '<a href="article-' . $judul . '.html" title="' . $data[1] . '"><span>' . $gambar . '' . limitTxt($data[1], 50) . '</span></a></li>';
    }
    echo "</ul>";
    echo '</div>';
} else {
    $perintah = "SELECT * FROM artikel WHERE publikasi=1 ORDER BY hits DESC LIMIT {$awal},{$jml}";
    $hasil = mysql_query($perintah);
    echo '<div id="terpopuler"><ul class="ui-tabs-nav">';
    while ($data = $koneksi_db->sql_fetchrow($hasil)) {
        $judul = AuraCMSSEO($data[1]);
        $gambar = $data['gambar'] == '' ? '<img src="mod/news/images/normal/news-default.jpg">' : '<img src="mod/news/images/normal/' . $data['gambar'] . '">';
        //$id = $data[0];
        echo '<li class="ui-tabs-nav-item">';
        echo '<a href="article-' . $judul . '.html" title="' . $data[1] . '"><span>' . $gambar . '' . limitTxt($data[1], 50) . '</span></a></li>';
    }
    echo "</ul>";
    echo '</div>';
}
$out = ob_get_contents();
ob_end_clean();
Esempio n. 2
0
<?php

if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {
    header("HTTP/1.1 404 Not Found");
    exit;
}
ob_start();
global $koneksi_db, $maxdata;
$jml = $maxdata;
$awal = 0;
$perintah = "SELECT * FROM artikel WHERE publikasi=1 ORDER BY id DESC LIMIT {$awal},{$jml}";
$hasil = mysql_query($perintah);
echo "<ul>";
while ($data = mysql_fetch_row($hasil)) {
    $judul = AuraCMSSEO($data[1]);
    $id = $data[0];
    echo '<li><a href="article-' . $id . '-' . $judul . '.html" title="' . $data[1] . '">' . limitTxt($data[1], 19) . '</a></li>';
}
echo "</ul>";
$out = ob_get_contents();
ob_end_clean();