File manager - Edit - /home/missmand/public_html/learning/old/main/formation/rating.php
Back
<?php /* For licensing terms, see /license.txt */ /** * @author Batiste Roger <batiste.roger@live.fr> * @package chamilo.formation */ define ('TABLE_RATING', 'c_lp_user_rating'); // Requires require_once '../inc/global.inc.php'; require_once (api_get_path(SYS_PATH) . 'main/subrole/subrole.php'); require_once (api_get_path(SYS_PATH) . 'main/couple/error.php'); // Autonomous controller (used by ajax calls essentially) if (isset($_POST['rating_action'])) { switch ($_POST['rating_action']) { case read : if (isset($_POST['user_id'])) return rating_read ($_POST['user_id']); break; case avg : case average : return rating_average(); break; case create : if (isset($_POST['user_id']) && isset($_POST['c_id']) && isset($_POST['lp_id']) && isset($_POST['rating'])) { return rating_create($_POST['user_id'], $_POST['c_id'], $_POST['lp_id'], $_POST['rating']); } break; default : error_throw("Action found is not valid (" . $_POST['rating_action'] . ")", "rating.php"); } } /** * List all ratings that user rated * @param type $user_id * @return type */ function rating_read ($user_id) { error_test_param(UserManager::is_user_id_valid($user_id), "User id is not a user id ($user_id)"); $sql = "SELECT * FROM " . TABLE_RATING . " WHERE user_id = '" . trim(Database::escape_string($user_id)) . "'"; $res = Database::query($sql); $result = array(); while ($row = Database::fetch_assoc($res)) { $result[$row['c_id']][$row['lp_id']] = $row['rating']; } return $result; } /** * Lists, for all lp, the acg rating * @return type */ function rating_average () { // avg rating per lp $sql = "SELECT c_id, lp_id, AVG(rating) as rating FROM " . TABLE_RATING . " GROUP BY c_id, lp_id"; return db_query($sql); } /** * Inserts an entry in table rating * @param type $user_id * @param type $c_id * @param type $lp_id */ function rating_create ($user_id, $c_id, $lp_id, $rating) { error_test_param(UserManager::is_user_id_valid($user_id), "User id is not a user id ($user_id)"); if (Database::num_rows(Database::query("SELECT * FROM " . TABLE_RATING . " WHERE user_id = '$user_id' AND c_id = '$c_id' AND lp_id = '$lp_id'")) == 0) { $sql = "INSERT INTO " . TABLE_RATING . " SET user_id = '$user_id', c_id = '$c_id', lp_id = '$lp_id', rating = '$rating'"; } else { $sql = "UPDATE " . TABLE_RATING . " SET rating = '$rating' WHERE user_id = '$user_id' AND c_id = '$c_id' AND lp_id = '$lp_id'"; } return db_query($sql); }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings