Оценка новостей

<?php
    //require_once $_SERVER['DOCUMENT_ROOT']."/config.php";
    $connect = mysql_connect('host', 'name_db', 'pass');
    mysql_select_db('name_db', $connect);
        $SQL1 = "SELECT count(*)
                FROM `rating`
                WHERE `url`='".$_SERVER['REQUEST_URI']."'";
        $res1 = mysql_query($SQL1);
        //echo $res1;
        while($row = mysql_fetch_array($res1)){
            $count_r=$row['count(*)'];
        }
        
        $SQL = "SELECT rating
                FROM `rating`
                WHERE url = '".$_SERVER['REQUEST_URI']."'";
        $res = mysql_query($SQL);
        $rating = 0;
        while($row = mysql_fetch_array($res)){
            //print_r($row);
            $rating += $row['rating'];
        }
        if($rating != 0) {
        $rating = round($rating/$count_r,1);
        }
        /*
        echo $res;
        while($row = mysql_fetch_array($res)){
            $count_r = $row['rating'];
        }
        print_r($res);
        */
    //mysql_close($connect);
    $lang="Оценка";
    
?>
<div style="float:right; width:auto">   
    <ul id="rating" style="float:right;">
        <p style="display:inline-block">Оценить: </p>
        <li class="rating-foreground" id="rating1" onclick = "SaveVote(this.id)" onmouseover = "SetRating(this.id)" onmouseout = "ClearRating()"> <meta itemprop="rating" content="1" /></li>
        <li class="rating-foreground" id="rating2" onclick = "SaveVote(this.id)" onmouseover = "SetRating(this.id)" onmouseout = "ClearRating()"> <meta itemprop="rating" content="2" /></li>
        <li class="rating-foreground" id="rating3" onclick = "SaveVote(this.id)" onmouseover = "SetRating(this.id)" onmouseout = "ClearRating()"> <meta itemprop="rating" content="3" /></li>
        <li class="rating-foreground" id="rating4" onclick = "SaveVote(this.id)" onmouseover = "SetRating(this.id)" onmouseout = "ClearRating()"> <meta itemprop="rating" content="4" /></li>
        <li class="rating-foreground" id="rating5" onclick = "SaveVote(this.id)" onmouseover = "SetRating(this.id)" onmouseout = "ClearRating()"> <meta itemprop="rating" content="5" /></li>
    </ul>
<div style="float:none; clear:both;">
    <div style="font-size:10px;" itemscope itemtype="https://schema.org/Article">
   <div itemprop="aggregateRating" itemscope itemtype="https://schema.org/AggregateRating">Рейтинг <span itemprop="ratingValue"><?php echo $rating; ?></span> из <span itemprop="bestRating">5</span>. Голосов: <span itemprop="ratingCount"><?php echo $count_r; ?></span>
   </div>
    </div>
</div>
</div>
    <script>
        var PageRating = <?php echo $rating; ?>;
 
        function SaveVote(id){
            $.ajax({
                type: "POST",
                url: "https://mydomein/rating/SaveRating.php",
                data: "rating="+id.replace("rating", "")+"&url="+window.location.pathname,
            }).done(function() {
              PageRating = parseInt(id.replace("rating", ""));
              SetRating(id);
              document.getElementById("rating_value").innerHTML = id.replace("rating", "");
            });
        }
 
        function SetRating(id){
            RatingClearAll();
            var i = 1;
            while(id != "rating"+i){
                document.getElementById("rating"+i).className = "rating-foreground active";
                i++;
            }
        }
        function ClearRating(){
            RatingClearAll();
            for(i = 1; i <= PageRating; i++){
                document.getElementById("rating"+i).className = "rating-foreground active";
                if(PageRating == i){
                    break;
                }
            }
        }
        function RatingClearAll(){
            for(i = 1; i <= 5; i++){
                document.getElementById("rating"+i).className = "rating-foreground";
            }
        }
        ClearRating();
        console.log(window.location.pathname);
    </script>

<?php
    if(isset($_POST['rating']) && isset($_POST['url'])){
        //$connect = mysql_connect('host', 'name_db', 'pass');
        $connect = mysql_connect('host', 'name_db', 'pass');
        mysql_select_db('vscenter_db');
/*
            $SQL = "SELECT id, rating
                    FROM `rating`
                    WHERE url = '".$_POST['url']."'";
            $page_id = 0;
            $page_rating = 0;
            $res = mysql_query($SQL);
            while($row = mysql_fetch_array($res)){
                $page_id = $row['id'];
                $page_rating = $row['rating'];
            }
 
            if($page_id == 0){
                $SQL = "INSERT INTO `rating` VALUES(NULL, '".$_POST['url']."', ".$_POST['rating'].")";
                $res = mysql_query($SQL);
            } elseif($page_rating != 0 && $page_rating < $_POST['rating']){
                $SQL = "UPDATE `rating`
                        SET rating = ".$_POST['rating']."
                        WHERE id = ".$page_id;
                $res = mysql_query($SQL);
            }
        mysql_close($connect);
*/
           $SQL = "SELECT id, rating
                    FROM `rating`
                    WHERE url = '".$_POST['url']."'";
            $page_id = 0;
            $page_rating = 0;
            $res = mysql_query($SQL);
            while($row = mysql_fetch_array($res)){
                $page_id = $row['id'];
                $page_rating = $row['rating'];
            }
            $post_url = $_POST['url'];
            //if($page_id == 0){
            if(!isset($_COOKIE[$post_url])) {
                $SQL = "INSERT INTO `rating` VALUES(NULL, '".$_POST['url']."', ".$_POST['rating'].")";
                $res = mysql_query($SQL);
                SetCookie("$post_url","1");
            }
    }
?>