|
|
| Data SITU |
10) $banyak = 10;
$sql=" SELECT COUNT(*) FROM UPLOAD"; // jumlah data yang ada di tabel upload
$totalUpload = mysql_result(mysql_query($sql),0);
//echo "banyak data:$totalUpload";
$banyakHalaman = 0;
if($totalUpload % $banyak > 0){
$banyakHalaman = (int) ($totalUpload / $banyak) + 1;
}else{
$banyakHalaman = (int) ($totalUpload / $banyak);
}
//echo $banyakHalaman;
for($i=1 ;$i <= $banyakHalaman;$i++){
echo 'Halaman '.$i.' ';
}
//$sql = "select * from upload "; //bahaya kalau datanya besar, misal: 10 000 data akan membuat lammma
$sql = "SELECT * from situ where id=".$_SESSION['id']." LIMIT $start, $banyak"; //ALTER TABLE `situ` ADD FOREIGN KEY ( `id` ) REFERENCES `user` ( `id` )
$qry = mysql_query($sql,$sambung)
or die ("SQL Error: ".mysql_error());
while($data=mysql_fetch_array($qry)) {
$no++;
?>
| |
| |
|
|
| Nama |
:
|
| Umur |
:
|
| Kewarganegaraan |
:
|
| No KTP |
:
|
| Alamat Tinggal |
:
|
| Jenisusaha |
:
|
| Nama usaha |
:
|
| Alamat Usaha |
:
|
| Kelurahan |
:
|
| Kecamatan |
:
|
| STATUS SITU |
:
|
kembali
|