<?php //Get all the members of a group given a group_id include_once "../util/mysql.php"; $dao = new DAO(false); $group_id = $dao->escape($_POST["group_id"]); $query = "SELECT user.user_id,user.user_picture,user.user_name FROM grouping JOIN user ON user.user_id=grouping.user_id WHERE grouping.group_id=\"{$group_id}\";"; $dao->myquery($query); echo $dao->fetch_json_part(array("user_id", "user_picture", "user_name"));
<?php //Print in JSON format the groups that this user belongs to, excluding their cohort group include "../util/session.php"; include_once "../util/mysql.php"; include_once "../util/status.php"; $dao = new DAO(false); $query = "SELECT user_group.group_id, user_group.group_name \n\t\t\t\tFROM grouping JOIN user_group ON grouping.group_id = user_group.group_id \n\t\t\t\tWHERE user_id=\"" . $user->user_id . "\" \n\t\t\t\t\tAND NOT grouping.group_id=(SELECT group_id FROM cohort WHERE cohort.cohort_id=\"" . $user->cohort_id . "\");"; $dao->myquery($query); echo $dao->fetch_json_part(array("group_id", "group_name"));
<?php include_once "../util/mysql.php"; $dao = new DAO(false); $uni_id = $dao->escape($_GET["university_id"]); $course = $dao->escape($_GET["course"]); $course = strtolower($course); //Take the query and return a json list of courses that might match this one $dao->myquery("SELECT course_id,course_name FROM course WHERE LOWER(course_name) LIKE '%{$course}%' AND university_id = '{$uni_id}';"); echo $dao->fetch_json_part(array("course_id", "course_name"));
<?php include "session.php"; include "mysql.php"; $dao = new DAO(false); $query = "SELECT post.post_id,user.user_id,post.post_time,post.post_content,post.post_rating_up,post.post_rating_dn,user.user_name,\n\t\t\t\t(post.post_rating_up + post.post_rating_dn) AS rating,\n\t\t\t\t(SELECT COUNT(*) FROM comment WHERE comment.post_id=post.post_id) AS comments\n\t\t\t\tFROM post JOIN user ON post.user_id=user.user_id \n\t\t\t\tWHERE post.post_time > DATE(NOW()) AND post.user_id!=\"{$user->user_id}\" \n\t\t\t\tORDER BY rating DESC,comments DESC LIMIT 5;"; $dao->myquery($query); echo $dao->fetch_json_part(array("post_id", "user_id", "post_time", "post_content", "post_rating_up", "post_rating_dn", "user_name"));