MENGHITUNG REVIEWS IMAGAE DENGAN PHP & MYSQL

index.php

<?php
session_start();
mysql_connect('localhost','root','');
mysql_select_db('kandhang_bnc');
$sql_select="select * from tb_hewan";
$result=mysql_query($sql_select);
?>
<table>
<tr><td><b>no</b></td><td><b>harga</b></td><td><b>reviews</b></td><td><b>detail</b></td></tr>
<?php
$no=0;
while($data=mysql_fetch_array($result)){
$_SESSION['harga_jual']=$data['hewan_harga_jual'];
$no++;
?>
<tr>
<td><?php echo $no; ?></td><td><?php echo $_SESSION['harga_jual']  ?></td><td><?php echo $data['reviews']; ?></td>
<td>
<a href="update.php?detail=<?php echo $data['hewan_id']; ?>">DETAIL</a></td>
<tr>
<?php
}
?>
</table>
<br>
<br>
 

update.php

<?php 
session_start();
mysql_connect('localhost','root','');
mysql_select_db('kandhang_bnc');
//---------------------------------------------------
$_SESSION['id']=$_GET['detail'];
//echo "ID -->".$_SESSION['id'];
//exit;
$sql_select="select * from tb_hewan where hewan_id=".$_SESSION['id'];
//echo $sql_select;
//exit;
$result=mysql_query($sql_select);
$data=mysql_fetch_array($result);
$reviews=$data['reviews'];
$ilusi=0;
$jum_klik=($ilusi != 0) ? 'serius amat lo' : $reviews+1;
//echo "Juml reviews :".$reviews."<br>";
//echo "Juml reviews :".$jum_klik;
//exit;
$update="UPDATE tb_hewan SET reviews=".$jum_klik." WHERE hewan_id=".$_SESSION['id'];
$result=mysql_query($update);
header('location: detail.php');
exit;
?>

detail.php

<?php
session_start();
mysql_connect('localhost','root','');
mysql_select_db('kandhang_bnc');
$id=$_SESSION['id'];
$sql_select="select * from tb_hewan where hewan_id=".$id;
//echo $sql_select;
//exit;
$result=mysql_query($sql_select);
$data=mysql_fetch_array($result);
echo $data['reviews'];
echo "<a href='index.php'>menu awal</a>";
exit;
?>

Tweet