include "conf/inc.dbconf.php";
$q=mysql_query("select * from page_id where idpage_id='2'",$konekdb);
$kolom=mysql_fetch_array($q);
echo "$kolom[5]";
?>
Total : $total
";
$jmlhalaman = ceil( $total / $limit);
// ambil data sejumlah besarnya pesan per halaman
$page = $_GET[page];
if(!isset($page))
{
$page = 1;
}
$offset = ($page - 1) * $limit;
$query = "select * from berita_id order by bid desc LIMIT $offset,$limit";
$hasil = mysql_query($query);
if ($page == 1) {
$start = 0;
$end = $limit;
} elseif ($page <= $jmlhalaman && $page > 1) {
$start = ($page - 1) * $limit;
$end = $start + $limit;
} else {
$page = 1;
}
while($data = mysql_fetch_array($hasil))
{
//echo "". $start + 1 .". ";
$bid=$data[0];
$judul_berita=$data[1];
$judul_berita1=ereg_replace(",|/| ","_",$judul_berita);
$deskripsi_berita=$data[2];
$isi_berita=$data[3];
$tgl_kirim=$data[4];
$oleh=$data[5];
echo "
".strtoupper ($judul_berita)."";
echo "[ $tgl_kirim ] | oleh :
$oleh";
echo "$deskripsi_berita ...";
echo "
";
$start ++;
}
if ($page >= 1 && $page <= $jmlhalaman && $total > $limit) {
if ($page != 1) {
echo ("
« Sebelumnya ");
}
for($i=1;$i<=$jmlhalaman;$i++)
{
if ($_GET[page] == $i)
{
echo "$i | ";
}
else
{
echo "
$i | ";
}
}
if ($page <= ($jmlhalaman - 1)) {
echo ("
Selanjutnya » ");
}
}
?>