Example #1
0
function listComments()
{
    $dbQuery = sprintf("SELECT id,comment,time FROM comments");
    $result = getDBResultsArray($dbQuery);
    header("Content-type: application/json");
    echo json_encode($result);
}
Example #2
0
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);
}
Example #4
0
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);
}