Login

Seven Thunders · 19-Aug-2018, 04:40 AM

No matter how many combinations I try I cannot seem to get an accurate "average" rating for my reviews. The below code "should" produce 4.3 stars (through demo info put into database). Instead it shows 5 stars. Can you help me find what is wrong? Also how to show 4.3 out of 5 stars instead of 4 out of 5 stars?

<?php $cmtx_identifier = 'Location';
$cmtx_path = '';
require_once $cmtx_path . 'includes/db/connect.php';
$cmtx_identifier = mysqli_real_escape_string($cmtx_link, $cmtx_identifier);
$page_query = mysqli_query($cmtx_link, "SELECT `id` FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `identifier` = '" . $cmtx_identifier . "'");
$page = mysqli_fetch_assoc($page_query);
$id = $page['id'];
$result = mysqli_query($cmtx_link, "SELECT AVG(`rating`)
 FROM (
 SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' AND `rating` != '0' AND `page_id` = '$id'
 UNION ALL
 SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "ratings` WHERE `page_id` = '$id'
 )
 AS `average`
 ");
$votes = mysqli_num_rows($result);
$average = round($result_avg["AVG(rating)"]/0.5)*0.5;
$max_rating = round($result_avg["MAX(rating)"]/0.5)*0.5;
$min_rating = round($result_avg["MIN(rating)"]/0.5)*0.5;
$count_rating = $result_avg["count(*)"];

if ($average == 1) {
 echo ' <img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"> 1 out of 5';
} elseif ($average == 2) {
 echo ' <img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"> 2 out of 5';
} elseif ($average == 3) {
 echo ' <img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"> 3 out of 5';
} elseif ($average == 4) {
 echo ' <img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"> 4 out of 5';
} else {
 echo ' <img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****/images/stars/star_full.png"> 5 out of 5 Stars';
}
?>

***Steven*** · 20-Aug-2018, 08:16 AM

I think the first issue is that $result_avg isn't defined. Try changing all four instances of it to $result.

Only full stars are supported. If you wanted you could put some half stars into the images folder, round to the nearest half and change the if statements accordingly.

Seven Thunders · 20-Aug-2018, 01:37 PM

Thank you kindly.

I have the correct "stars" showing (whole stars as I have not got a clue about half stars, lol) now I just need to get "4 out of 5 stars" to show as "4.3 out of 5 stars" in the "text" area below the stars.
Like this:

****
4.3 out of 5 Stars

This is the previous version of Commentics (as I assume you can tell by the code) and it is HIGHLY modified or I would upgrade. The newer version looks awesome by the way!

Here is what I have:

<div itemscope itemtype="https://data-vocabulary.org/Review-aggregate">
**** ****


<?php $cmtx_identifier = 'Location';
$cmtx_path = '';
require_once $cmtx_path . 'includes/db/connect.php';
$cmtx_identifier = mysqli_real_escape_string($cmtx_link, $cmtx_identifier);
$page_query = mysqli_query($cmtx_link, "SELECT `id` FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `identifier` = 'Location'");
$page = mysqli_fetch_assoc($page_query);
$id = $page['id'];
$result = mysqli_query($cmtx_link, "SELECT AVG(`rating`)
FROM (
SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' AND `rating` != '0' AND `page_id` = '10001' AND reply_to = '0'
UNION ALL
SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "ratings` WHERE `page_id` = '10001'
)
AS `average`
");
$votes = mysqli_num_rows($result);
$average = mysqli_fetch_assoc($result);
$average = $average["AVG(`rating`)"];
$average = round($average, 0);
if ($average == 1) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png">1 out of 5';
} elseif ($average == 2) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> 2 out of 5';
} elseif ($average == 3) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> 3 out of 5';
} elseif ($average == 4) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> 4 out of 5';
} else {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> 5 out of 5 Stars';
}
?>

***Steven*** · 20-Aug-2018, 02:39 PM

Sorry I see what you mean now.

So above this line:
$average = round($average, 0);

You could put this:
$average_not_rounded = $average;

Then further down, just before it says "out of", for each one change the number that comes before it (1,2,3,4,5 etc) with <?php echo $average_not_rounded; ?>

Seven Thunders · 21-Aug-2018, 01:27 AM

Thank you for your efforts Steven. However, it now shows: "out of 5" Just a blank space. I wonder if it has something to do with this: elseif ($average == 4)
Also, where is "$average_not_rounded" defined? Seems like it's just repeating $average ???

Here's what I have after your changes:

<?php $cmtx_identifier = 'Location';
$cmtx_path = '';
require_once $cmtx_path . 'includes/db/connect.php';
$cmtx_identifier = mysqli_real_escape_string($cmtx_link, $cmtx_identifier);
$page_query = mysqli_query($cmtx_link, "SELECT `id` FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `identifier` = 'Location'");
$page = mysqli_fetch_assoc($page_query);
$id = $page['id'];
$result = mysqli_query($cmtx_link, "SELECT AVG(`rating`)
FROM (
SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' AND `rating` != '0' AND `page_id` = '10001' AND reply_to = '0'
UNION ALL
SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "ratings` WHERE `page_id` = '10001'
)
AS `average`
");
$votes = mysqli_num_rows($result);
$average = mysqli_fetch_assoc($result);
$average = $average["AVG(`rating`)"];
$average_not_rounded = $average;
$average = round($average, 0);
if ($average == 1) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><?php echo $average_not_rounded; ?> out of 5';
} elseif ($average == 2) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> <?php echo $average_not_rounded; ?> out of 5';
} elseif ($average == 3) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> <?php echo $average_not_rounded; ?> out of 5';
} elseif ($average == 4) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> <?php echo $average_not_rounded; ?> out of 5';
} else {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> <?php echo $average_not_rounded; ?> out of 5 Stars';
}
?>

</body>
</html>

Seven Thunders · 21-Aug-2018, 04:05 AM

First, I want to thank you for your help, your time, and a great script!
Next...I Got it :-)
This works for me:

<div itemscope itemtype="https://data-vocabulary.org/Review-aggregate">
**** ****


<?php $cmtx_identifier = 'Location';
$cmtx_path = '';
require_once $cmtx_path . 'includes/db/connect.php';
$cmtx_identifier = mysqli_real_escape_string($cmtx_link, $cmtx_identifier);
$page_query = mysqli_query($cmtx_link, "SELECT `id` FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `identifier` = 'Location'");
$page = mysqli_fetch_assoc($page_query);
$id = $page['id'];
$result = mysqli_query($cmtx_link, "SELECT AVG(`rating`)
FROM (
SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' AND `rating` != '0' AND `page_id` = '10001' AND reply_to = '0'
UNION ALL
SELECT `rating` FROM `" . $cmtx_mysql_table_prefix . "ratings` WHERE `page_id` = '10001'
)
AS `average`
");
$votes = mysqli_num_rows($result);
$average = mysqli_fetch_assoc($result);
$average = $average["AVG(`rating`)"];
$average = round($average, 0);
if ($average == 1) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png">';
} elseif ($average == 2) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> <?php echo $average_not_rounded; ?> out of 5';
} elseif ($average == 3) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"> <?php echo $average_not_rounded; ?> out of 5';
} elseif ($average == 4) {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png">';
} else {
echo ' <img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png"><img src="' . $cmtx_path . 'https://www.****.com/images/stars/star_full.png">';
}
?>

 

<?php
$link = mysql_connect("****", "****", "****");
mysql_select_db("****", $link);
$query = "SELECT ROUND(AVG(rating),1) FROM comments WHERE `is_approved` = '1' AND `rating` != '0' AND `page_id` = '10001' AND reply_to = '0'";
$result = @mysql_query ($query);
$row = mysql_fetch_array($result);
echo "$row[0] out of 5";
?>

More stuff down here....

Login
Username:
Password:	Lost Password?
	Remember me