All pastes #900951 Raw Edit

Someone

public text v1 · immutable
·published 2008-02-12 08:40 UTC
rendered paste body
<?php
	include "frame.php";
	$kategori = $_REQUEST["id"];
	$page = $_REQUEST["page"];
	if(!isset($page)){
		$page = 0;
	}		
	include "admin/connect.php";
	$offset = $page * 5;
	$sql = "SELECT * FROM baris WHERE kategori = '$kategori' LIMIT $offset,5 ";
	$result = mysql_query($sql);
	
	$perintah = "SELECT COUNT(*) FROM baris WHERE kategori = '$kategori' ";
	$hasil = mysql_query($perintah);
	$baris = mysql_fetch_array($hasil);
	$jmlh = $baris[0];
	$hal = ceil($jmlh / 5);
?>
<style type="text/css">
<!--
.judul {
	font-size: 16px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #FF0000;
	font-weight: bold;
}
.style2 {font-weight: bold}
-->
</style>

<div id="wrap">
<div id="main">
<h1><br />
  Kategori : 
<?php 
$kat = $kategori;
switch($kat){
	case "1" : echo "Alat Kantor"; break;
	case "2" : echo "Bisnis"; break;
	case "3" : echo "Blog"; break;
	case "4" : echo "Elektronik"; break;
	case "5" : echo "Handphone"; break;
	case "6" : echo "Hewan Peliharaan"; break;
	case "7" : echo "Hobi"; break;
	case "8" : echo "Internet"; break;
	case "9" : echo "Kendaraan"; break;
	case "10" : echo "Kesehatan"; break;
	case "11" : echo "Komputer"; break;
	case "12" : echo "Lain-Lain"; break;
	case "13" : echo "Lowongan Kerja"; break;
	case "14" : echo "Pendidikan"; break;
	case "15" : echo "Properti"; break;
	case "16" : echo "Rumah Tangga"; break;
	case "17" : echo "Wisata"; break;
	case "18" : echo "Website"; break;
}
	while($row = mysql_fetch_array($result) ){
?></h1>
<p><code><?php echo $row['tanggal']." / ".$row['waktu']; ?>
      <br />
      <br />
      <?php
	 $judul = $baris['judul'];
	 $spasi = array(" ");
	 $title = str_replace($spasi, "_", $judul);	 	 
	 $isi = $row['isi'];	 
?>
      <span class="judul"><a href="ib.php?id=<?php echo $row['no']?>&tit=<?php echo $title; ?>"><?php echo $row['judul']; ?></a></span><br />
      <br />
      <?php 
$kata = strtok($isi," ");
	for($i=1;$i<=25;$i++){
		echo $kata." ";
		$kata = strtok(" ");
	}	
?>
      <a href="ib.php?id=<?php echo $row['no']?>&tit=<?php echo $title; ?>">[detail]</a>
      <br />
      <br />
  Diposting Oleh : <?php echo $row['nama'];?>
  <br />
  </code>
    <?php
	}
?>
    <?php if($page > 0 ){
?>
</p>
<p align="center">      <span class="style2"><a href="kategori.php?id=<?= $kategori; ?>&page=<?= $page-1; ?>">prev</a>
      <?php
}
else{
	echo "<<";
}
?>
      <?php
for($j=1;$j<=$hal;$j++){
?>
      <a href="kategori.php?id=<?= $kategori; ?>&page=<?= $j; ?>"> 
      <?= $j." | "; ?> 
      </a> 
      <?php
}
?>
      <?php if($page < ($hal-1) ){
?>
      <a href="kategori.php?id=<?= $kategori; ?>&page=<?= $page+1; ?>">next</a>
      <?php
}
else{
	echo ">>";
}
?>
</span></p>
</div>
</div>

<?php
	include "footer.php";
?>