<?php
if (!empty($_POST["id"])) {
require_once "dbcontroller.php";
$db_handle = new DBController();
switch ($_POST["action"]) {
case "like":
$query = "INSERT INTO ipaddress_likes_map (ip_address,tutorial_id) VALUES ('" . $_SERVER['REMOTE_ADDR'] . "','" . $_POST["id"] . "')";
$result = $db_handle->insertQuery($query);
if (!empty($result)) {
$query = "UPDATE tutorial SET likes = likes + 1 WHERE id='" . $_POST["id"] . "'";
$result = $db_handle->updateQuery($query);
}
break;
case "unlike":
$query = "DELETE FROM ipaddress_likes_map WHERE ip_address = '" . $_SERVER['REMOTE_ADDR'] . "' and tutorial_id = '" . $_POST["id"] . "'";
$result = $db_handle->deleteQuery($query);
if (!empty($result)) {
$query = "UPDATE tutorial SET likes = likes - 1 WHERE id='" . $_POST["id"] . "' and likes > 0";
$result = $db_handle->updateQuery($query);
}
break;
}
}
<?php
if (!empty($_POST["rating"]) && !empty($_POST["id"])) {
require_once "dbcontroller.php";
$db_handle = new DBController();
$id = $_POST['id'];
$reviews = "UPDATE ratings SET reviews = reviews + 1 WHERE id='{$id}'";
$result = $db_handle->updateQuery($reviews);
$sum = "UPDATE ratings SET sum = sum +'" . $_POST["rating"] . "'WHERE id='{$id}'";
$result = $db_handle->updateQuery($sum);
$query = mysql_query("SELECT * FROM ratings WHERE id='{$id}'");
while ($row = mysql_fetch_array($query)) {
$count = $row['sum'];
$divide = $row['reviews'];
}
$average = $count / $divide;
$av = round($average, 0);
$queryy = "UPDATE ratings SET rating = '{$av}' WHERE id='{$id}'";
$result = $db_handle->updateQuery($queryy);
}
