echo $project['project_title'];
?>
">
Send Request</a>
</div>
<?php
}
?>
</div>
</div>
<div class="project-action">
<?php
$rate = getUserRateForProject($project['project_id'], $_SESSION['uid']);
if ($rate) {
?>
<a href="#" class="project-action-btn inactive" id="rate_project" data-id="<?php
echo $project['project_id'];
?>
">Rated</a>
<?php
} else {
$rate = 0;
?>
<a href="#" class="project-action-btn" id="rate_project" data-id="<?php
echo $project['project_id'];
?>
">Rate</a>
<?php
function rateProject($project_id, $user_id, $value)
{
global $db_con;
$rate = getUserRateForProject($project_id, $user_id);
if (!isset($rate)) {
$query = 'INSERT INTO `rating` SET
`project_id` = ' . $project_id . ',
`user_id` = ' . $user_id . ',
`value` = ' . $value . '
';
} else {
$query = 'UPDATE `rating` SET `value` = ' . $value . ' WHERE `project_id` = ' . $project_id . ' AND `user_id` = ' . $user_id;
}
$id = $db_con->query($query);
$query = 'UPDATE `projects` SET `avr_rating` = (SELECT AVG(value) FROM `rating` WHERE `project_id` = ' . $project_id . ') WHERE `project_id` = ' . $project_id;
$db_con->query($query);
return $id;
}
