File: WIAdmin/WIModule/modules/avg.php

Recommend this page to a friend!
  Classes of Jules Warner  >  WICMS  >  WIAdmin/WIModule/modules/avg.php  >  Download  
File: WIAdmin/WIModule/modules/avg.php
Role: Auxiliary script
Content type: text/plain
Description: Auxiliary script
Class: WICMS
Database driven content management system with PDO
Author: By
Last change:
Date: 3 years ago
Size: 1,657 bytes
 

Contents

Class file image Download
<?php

include_once 'core/init.php';

$totals ="";
$rating= "";
$stars = "star";

if (isset(
$_GET['id'])) {
   
// Connect to the MySQLi database

   
$id = preg_replace('#[^0-9]#i', '', $_GET['id']);
}
$sql = mysqli_query($db_conn, "SELECT rating FROM books WHERE id='$id'");

while(
$row = mysqli_fetch_array($sql))
{
   
$mynum = $row["rating"];
   
$expl = explode(",", $mynum);
   
$result = array_count_values($expl);
    foreach(
$result as $key => $value)
    {
        if(
$value =="1")
        {
           
$howmany = "person";
        }else
        {
           
$howmany ="people";
        }
        if (
$key =="")
        {
           
$pic = "img/ratings/starnorm.PNG";
        }
       
        else if(
$key =="1")
        {
           
$stars = "star";
           
$pic = "../img/ratings/1star.PNG";
        }else if(
$key =="2")
        {
           
$stars = "star";
           
$pic = "../img/ratings/2star.PNG";
        }else if(
$key =="3")
        {
           
$stars = "star";
           
$pic = "../img/ratings/3star.PNG";
        }else if(
$key =="4")
        {
           
$stars = "star";
           
$pic = "../img/ratings/4star.PNG";
        }else if(
$key =="5")
        {
           
$stars = "star";
           
$pic = "../img/ratings/5star.PNG";
        }
       
       
$totals .= '<p class="small">' . $key . ' ' . $stars . ' : <img src"' . $pic . '" alt="stars" />
         '
. $value . ' ' . $howmany . '</p>';
    }
   
   
$count = count($expl);
   
$sum = array_sum($expl);
   
$avg = $sum / $count;
   
$roundup = floor($avg);
   
    if(
$roundup == 0)
    {
       
$rating = "This book has not been rated. You can be the first to rate this book.";
    }else if (
$count == 1)
    {
       
$rating = "Average rating for the book is currently ' .$roundup . '/<b />This book has been rated by $count person.";
    }else
    {
       
$rating = "Sorry, there is an error in the system... Please try refreshing.";
    }
   
   
   
}

mysqli_close($db_conn);


For more information send a message to info at phpclasses dot org.