mohon pembenahan master jika koding ini ada yang kurang pasalnya setiap saya next or prev data tidak muncul dlam melakukan paging halaman.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title></title>
</head>
<style type="text/css">
#tes {
background-color: #efefef;
color: #000000;
Border-radius: 0px 15px;
border-top-left-radius: 0px;
border-top-right-radius: 20px;
border-bottom-right-radius: 0px;
border-bottom-left-radius: 15px;
moz-box-shadow: 0 0 2em #000;
webkit-box-shadow: 0 0 2em #000;
box-shadow: 0 0 1em #000;
border: 1px solid #CCC;
margin-top: 20px;
margin-left: 35px;
width:700px;}
#jud { margin-left:50px;
margin-bottom:10px;}
.link_button
{ margin-bottom:10px;
text-decoration: none;
text-align: center;
font-size: 18px;
padding: 10px;
border : solid 1px #5DA951;
background-color: #fff;
color: #000099;
border-radius: 5px;
-moz-border-radius: 15px;
-webkit-border-radius: 15px;
box-shadow: 5px 5px 7px #5DA951;
-moz-box-shadow: 5px 5px 7px #5DA951;
-webkit-box-shadow: 5px 5px 7px #5DA951;
}
.page {
background-color:#efefef;
float:left;
margin-left:30px;
margin-bottom:20px;
}
-->
</style>
<body><br /><br /><div id="jud"><a href="index.php?page=komentar"class="link_button">Add Testimoni</a></div>
<div id="tes">
<?php
//membuat koneksi ke database
include "./config.php";
function buat_paging($curPage,$totalRec,$maxRec){
$totalPage;
$totalPage=ceil($totalRec/$maxRec);
$str="";
/*————————–Tombol Prev———————–*/
if($curPage>1){
$prevPage = $curPage-1;
$str.="".makeLink('prev','?page='.$prevPage)." ";
}
/*————————-Untuk Page Number—————-*/
for($i=1;$i<=$totalPage;$i++){
if($i==$curPage){
$bold=true;
}else{
$bold=false;
}
$str.="".makeLink($i,'?page='.$i,$bold)."";
}
/*————————–Tombol Next———————–*/
if($curPage<$totalPage){
$nextPage=$curPage+1;
$str.="".makeLink('next','?page='.$nextPage)."";
}
return $str;
}
function makeLink($str,$url,$bold="true"){
if($bold){
$str="<b>".$str."</b>";
} return '<a href="'.$url.'">'.$str.'</a>';
}
//connection
$total=mysql_query("select * from kontak");
$total=mysql_num_rows($total);
$total=ceil($total/4);
$curPage=abs((int)$_GET['page']);
if ($curPage==null){$curPage=1;}
elseif($curPage>$total){$curPage=$total;}
$maxRec=6;
$startRec = ($curPage-1)*$maxRec;
$sql = "select * from kontak order by email desc limit ".$startRec.",".$maxRec;
$rs=mysql_query($sql);
//menampilkan data
while($rows=mysql_fetch_array($rs)){
//menampilkan field nama
echo "<b>Waktu : </b>".$rows['email'];
echo "<br>";
echo "<b>Nama : </b>".$rows['nama'];
echo "<br><b>Testimoni : </b>".$rows['komentar'];
echo "<br>";
echo "<hr>";
}
$total_record=mysql_query("select * from kontak");
$total_record=mysql_num_rows($total_record);
echo "<br>";
echo buat_paging($curPage,$total_record,$maxRec);
?></div>
</body>
</html>
<br><div class="page">
</div>
Tidak ada komentar:
Posting Komentar