<?php
include_once "header.php";

class Rating {
    private $dbh;

    public function __construct() {
        $this->dbh = Database::connect();
    }

    public function addRate($permalink, $rating, $ip, $userid){
        $query = $this->dbh->prepare("INSERT INTO `shows_ranking` (`show_permalink`, `rating`, `ip`, `userid`) VALUES (:permalink, :rating, :ip, :userid)");
        $params = array(
            ':permalink' => $permalink,
            ':rating' => $rating,
            ':ip' => $_SERVER['REMOTE_ADDR'],
            ':userid' => @$_SESSION['userid']
        );
        print_r($params);
        $query->execute($params);
    }
}

$permalink = $_GET['permalink'];
$rating = (int)$_GET['rating'];
$ip = $_SERVER['REMOTE_ADDR'];
$userid = @$_SESSION['userid'];



$count = Database::getCount("shows_ranking", "WHERE `show_permalink` = '{$permalink}' AND (`ip` = '{$ip}' OR `userid` = '{$userid}')");

$rating = new Rating;

$rating->addRate($permalink, $rating, $ip, $userid);