$dataperiksaurut = mysql_fetch_array($periksaurut); $orderby = $dataperiksaurut['order']; if ($cekparentid == '0') { $tengah .= '<div class="border"><strong>Kategori</strong> » ' . $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# » <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;
$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;