function listComments() { $dbQuery = sprintf("SELECT id,comment,time FROM comments"); $result = getDBResultsArray($dbQuery); header("Content-type: application/json"); echo json_encode($result); }
function getUnmatchedMentees() { $dbQuery = "SELECT Mentee.username,\n\t\t\t\t\t\t\tUSER.first_name,\n\t\t\t\t\t\t\tUSER.last_name\n\t\t\t\t\tFROM Mentee JOIN USER\n\t\t\t\t\tON Mentee.username = USER.username\n\t\t\t\t\tLEFT JOIN Matches\n\t\t\t\t\tON Mentee.username = Matches.mentee_user\n\t\t\t\t\tWHERE Matches.mentee_user IS NULL"; $result = getDBResultsArray($dbQuery); echo json_encode($result); }
function listTransactionWithTutorID($sid, $con) { $dbQuery = sprintf("SELECT S_ID,Duration,Class,Rate FROM Transaction WHERE T_ID = '%d'AND Confirmed = '%d' ", $sid, $con); $result = getDBResultsArray($dbQuery); echo json_encode($result); }
function userIsAdmin($userId) { $dbQuery = "SELECT username FROM Admin WHERE username = '******'"; $result = getDBResultsArray($dbQuery); return !empty($result); }
function getStudentInfo($sid) { $dbQuery = sprintf("SELECT * FROM Student WHERE ID = '%d' ", $sid); $result = getDBResultsArray($dbQuery); echo json_encode($result); }
function getTutor($email) { $dbQuery = sprintf("SELECT * FROM Tutor WHERE email = '%s'", mysql_real_escape_string($email)); $result = getDBResultsArray($dbQuery); echo json_encode($result); }