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; }