We are going to create a simple page that lists three courses, and allows you to rate them. This means we need the stars to show the current rating, and to allow voting. We also want an area to show the total votes cast, and the current rating down to one decimal place. You may also like How to Generate QR Code Using PHP And HTML and How to Generate Barcode Using PHP
PHP, HTML and CSS Code
<html>
<head>
<style>
#total_votes
{
font-size:30px;
color:#FE2E2E;
font-weight:bold;
}
.div
{
border:1px solid #E6E6E6;
clear:both;
margin-top:20px;
height:100px;
width:400px;
padding:10px;
margin-left:300px;
border-radius:3px;
}
.div p
{
margin:0px;
font-size:20px;
text-align:left;
color:#E6E6E6;
}
img
{
margin-top:10px;
width:50px;
height:50px;
float:left;
}
input[type="submit"]
{
border:none;
background:none;
background-color:#585858;
width:100px;
height:50px;
color:white;
border-radius:3px;
font-size:17px;
margin-top:20px;
}
</style>
<script type="text/javascript">
function change(id)
{
var cname=document.getElementById(id).className;
var ab=document.getElementById(id+"_hidden").value;
document.getElementById(cname+"rating").innerHTML=ab;
for(var i=ab;i>=1;i--)
{
document.getElementById(cname+i).src="star2.png";
}
var id=parseInt(ab)+1;
for(var j=id;j<=5;j++)
{
document.getElementById(cname+j).src="star1.png";
}
}
</script>
</head>
<body>
<h1>How to Star Rating System Using PHP and JavaScript</h1>
<?php
$select_rating=mysqli_query($con,"SELECT * FROM rating");
$total=mysql_num_rows($select_rating);
$phpar = array();
$aspar = array();
$jspar = array();
while($row = mysqli_fetch_assoc($select_rating))
{
$phpar[]=$row['php'];
$aspar[]=$row['asp'];
$jspar[]=$row['jsp'];
}
$total_php_rating=(array_sum($phpar)/$total);
$total_asp_rating=(array_sum($aspar)/$total);
$total_jsp_rating=(array_sum($jspar)/$total);
?>
<form method="post" action="">
<p id="total_votes">Total Votes:<?php echo $total;?></p>
<div class="div">
<p>PHP (<?php echo $total_php_rating;?>)</p>
<input type="hidden" id="php1_hidden" value="1">
<img src="images/star1.png" onmouseover="change(this.id);" id="php1" class="php">
<input type="hidden" id="php2_hidden" value="2">
<img src="images/star1.png" onmouseover="change(this.id);" id="php2" class="php">
<input type="hidden" id="php3_hidden" value="3">
<img src="images/star1.png" onmouseover="change(this.id);" id="php3" class="php">
<input type="hidden" id="php4_hidden" value="4">
<img src="images/star1.png" onmouseover="change(this.id);" id="php4" class="php">
<input type="hidden" id="php5_hidden" value="5">
<img src="images/star1.png" onmouseover="change(this.id);" id="php5" class="php">
</div>
<div class="div">
<p>ASP (<?php echo $total_asp_rating;?>)</p>
<input type="hidden" id="asp1_hidden" value="1">
<img src="images/star1.png" onmouseover="change(this.id);" id="asp1" class="asp">
<input type="hidden" id="asp2_hidden" value="2">
<img src="images/star1.png" onmouseover="change(this.id);" id="asp2" class="asp">
<input type="hidden" id="asp3_hidden" value="3">
<img src="images/star1.png" onmouseover="change(this.id);" id="asp3" class="asp">
<input type="hidden" id="asp4_hidden" value="4">
<img src="images/star1.png" onmouseover="change(this.id);" id="asp4" class="asp">
<input type="hidden" id="asp5_hidden" value="5">
<img src="images/star1.png" onmouseover="change(this.id);" id="asp5" class="asp">
</div>
<div class="div">
<p>JSP (<?php echo $total_jsp_rating;?>)</p>
<input type="hidden" id="jsp1_hidden" value="1">
<img src="images/star1.png" onmouseover="change(this.id);" id="jsp1" class="jsp">
<input type="hidden" id="jsp2_hidden" value="2">
<img src="images/star1.png" onmouseover="change(this.id);" id="jsp2" class="jsp">
<input type="hidden" id="jsp3_hidden" value="3">
<img src="images/star1.png" onmouseover="change(this.id);" id="jsp3" class="jsp">
<input type="hidden" id="jsp4_hidden" value="4">
<img src="images/star1.png" onmouseover="change(this.id);" id="jsp4" class="jsp">
<input type="hidden" id="jsp5_hidden" value="5">
<img src="images/star1.png" onmouseover="change(this.id);" id="jsp5" class="jsp">
</div>
<input type="hidden" name="phprating" id="phprating" value="0">
<input type="hidden" name="asprating" id="asprating" value="0">
<input type="hidden" name="jsprating" id="jsprating" value="0">
<input type="submit" value="Submit" name="submit_rating">
</form>
</body>
</html>PHP Code (Insert Rating in Database)
<?php
define('DB_SERVER', "localhost");
define('DB_USER', "root");
define('DB_PASS', "");
define('DB_DATABASE', "whatsappdwld_db");
$con = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
if(isset($_POST['submit_rating']))
{
$php_rating=$_POST['phprating'];
$asp_rating=$_POST['asprating'];
$jsp_rating=$_POST['jsprating'];
$insert=mysqli_query($con,"INSERT INTO rating (php,asp,jsp) values('$php_rating','$asp_rating','$jsp_rating')");
}
?>
