agan gan nih sintak pagging , nah paging itu untuk membatasi sebuah tampil data
nah sintak sebagai berikit
<?php
$conn = mysql_connect("localhost", "root", "");
mysql_select_db("belajar");
//mencari banyak data yang ada dalam tabel
$sqlCount = "select count(filename) from upload";
$rsCount = mysql_fetch_array(mysql_query($sqlCount));
$banyakData = $rsCount[0];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 5;
$mulai_dari = $limit * ($page - 1);
$sql_limit = "select * from upload order by filename limit $mulai_dari, $limit";
$hasil = mysql_query($sql_limit);
?>
<!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=utf-8" />
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body >
<?php
?>
<table border="1" >
<tr>
<?php do { ?>
<td width="50" height="50">
<?php echo $row_tampil['id']; ?>
<img src="file/<?php echo $row_tampil['filename']; ?>" height="50" width="50" /></td>
<?php } while ($row_tampil = mysql_fetch_array($hasil)); ?>
</tr>
</table>
<?php
$banyakHalaman = ceil($banyakData / $limit);
echo 'Halaman: ';
for($i = 1; $i <= $banyakHalaman; $i++){
if($page != $i){
echo '[<a href="paging.php?page='.$i.'">'.$i.'</a>] ';
}else{
echo "[$i] ";
}
}
?>
</body>
</html>
save nya paging.php
nah moga bermaamfat jika ada yang di tayakan koment aja di sini
nah sintak sebagai berikit
<?php
$conn = mysql_connect("localhost", "root", "");
mysql_select_db("belajar");
//mencari banyak data yang ada dalam tabel
$sqlCount = "select count(filename) from upload";
$rsCount = mysql_fetch_array(mysql_query($sqlCount));
$banyakData = $rsCount[0];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 5;
$mulai_dari = $limit * ($page - 1);
$sql_limit = "select * from upload order by filename limit $mulai_dari, $limit";
$hasil = mysql_query($sql_limit);
?>
<!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=utf-8" />
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body >
<?php
?>
<table border="1" >
<tr>
<?php do { ?>
<td width="50" height="50">
<?php echo $row_tampil['id']; ?>
<img src="file/<?php echo $row_tampil['filename']; ?>" height="50" width="50" /></td>
<?php } while ($row_tampil = mysql_fetch_array($hasil)); ?>
</tr>
</table>
<?php
$banyakHalaman = ceil($banyakData / $limit);
echo 'Halaman: ';
for($i = 1; $i <= $banyakHalaman; $i++){
if($page != $i){
echo '[<a href="paging.php?page='.$i.'">'.$i.'</a>] ';
}else{
echo "[$i] ";
}
}
?>
</body>
</html>
save nya paging.php
nah moga bermaamfat jika ada yang di tayakan koment aja di sini
No comments:
Post a Comment