Ejemplo n.º 1
0
 $dataperiksaurut = mysql_fetch_array($periksaurut);
 $orderby = $dataperiksaurut['order'];
 if ($cekparentid == '0') {
     $tengah .= '<div class="border"><strong>Kategori</strong> &raquo; ' . $dataperiksa['kategori'] . ', Urut Menurut : ' . $orderby . '</div>';
     $query2 = mysql_query("SELECT count(`id`) AS `total_files` FROM `katalog` WHERE `kategori`='{$kid}' OR `parentid`='{$kid}'");
 } else {
     $pc = mysql_query("SELECT `kategori`,`kid` FROM `kat_katalog` WHERE `kid`='{$cekparentid}'");
     $datapc = mysql_fetch_array($pc);
     $tengah .= '<div class="border"><table width="100%"><tr><td>Kategori# &raquo; <a href="' . $url_situs . '/' . get_link($dataperiksa['kid'], $dataperiksa['kategori'], "kategori-produk") . '" title="' . $datapc['kategori'] . '">' . $dataperiksa['kategori'] . '</a> , Urut Menurut : ' . $orderby . '</td>';
     ///////////////////
     $tengah .= '<td align="right">Pilih Urutan <select onchange="redir(this)"><option value="' . $url_situs . '/katalog.html">- Silahkan Pilih -</option>';
     $bs = $koneksi_db->sql_query("SELECT * FROM kat_urut ORDER BY urut asc");
     while ($dat = $koneksi_db->sql_fetchrow($bs)) {
         $urut = $dat['urut'];
         $uid = $dat['uid'];
         $tengah .= '<option value="' . $url_situs . '/' . get_link2($kid, $uid, $kategori, "kategori-produk-urut") . '" title="' . $urut . '">' . $urut . '</option>';
     }
     $tengah .= '</select></td></tr></table></div>';
     ///////////////////
     $query2 = mysql_query("SELECT count(`id`) AS `total_files` FROM `katalog` WHERE `kategori`='{$kid}'");
 }
 //title
 $judul_situs = '' . $dataperiksa['kategori'] . ' | ' . $judul_situs . '';
 $_META['description'] = limittxt(htmlentities(strip_tags($data['ket'])), 150);
 $_META['keywords'] = empty($data['tags']) ? implode(',', explode(' ', htmlentities(strip_tags($data['judul'])))) : $data['tags'];
 $getdata2 = mysql_fetch_assoc($query2);
 $jumlah = $getdata2['total_files'];
 $limit = 16;
 if ($jumlah > 0) {
     if (empty($_GET['offset']) and !isset($_GET['offset'])) {
         $offset = 0;
Ejemplo n.º 2
0
        $gambar = 'photo-default.jpg';
    }
    $sp = mysql_query("SELECT * FROM `photo` where id<'{$id}' order by id desc");
    $datasp = mysql_fetch_array($sp);
    $idsp = $datasp['id'];
    $judulsp = $datasp['judul'];
    $sn = mysql_query("SELECT * FROM `photo` where id>'{$id}' order by id asc");
    $datasn = mysql_fetch_array($sn);
    $idsn = $datasn['id'];
    $judulsn = $datasn['judul'];
    if (!$idsp) {
        $prev = "";
    } else {
        $prev = '<b><a href="/' . get_link2($idsp, $kid, $judulsp, "photo") . '">Prev</a></b> - ';
    }
    if (!$idsn) {
        $next = "";
    } else {
        $next = '<b><a href="/' . get_link2($idsn, $kid, $judulsn, "photo") . '">Next</a></b>';
    }
    $tengah .= '<tr>
<td style="text-align:center; padding:5px 0 10px 0">' . $prev . '' . $next . '</td>
</tr>';
    $tengah .= '<tr>
<td align="center">
<img src="' . $url_situs . '/mod/photo/images/normal/' . $gambar . '" alt="' . $judul . '"></td></tr>';
    $tengah .= '<tr><td><h1>' . $judul . '</h1>' . $ket . '</td></tr>';
    $tengah .= '</table>';
    $tengah .= '</div>';
}
echo $tengah;