function updateTransaction($name, $gender, $email, $phone) { $dbQuery = sprintf("UPDATE Transaction SET name = '%s',gender='%d',phone='%d' WHERE email = '%s'", mysql_real_escape_string($name), $gender, $phone, mysql_real_escape_string($email)); $result = getDBResultAffected($dbQuery); //header("Content-type: application/json"); echo json_encode($result); }
function updateStudent($name, $gender, $phone, $sid) { $dbQuery = sprintf("UPDATE Student SET name = '%s',gender='%d',phone='%d' WHERE ID = '%d'", mysql_real_escape_string($name), $gender, $phone, $sid); $result = getDBResultAffected($dbQuery); //header("Content-type: application/json"); echo json_encode($result); }
function setMaxMenteesPerMentor($newMax) { $query = "UPDATE GlobalSettings SET settingValue='{$newMax}' WHERE settingName='MaxMenteesPerMentor';"; getDBResultAffected($query); //TODO check if the row was actually updated; rows_affected returns 0 if value was the same; see http://php.net/manual/en/pdostatement.rowcount.php#allnotes for workaround return $newMax; }
function deleteComment($id) { $dbQuery = sprintf("DELETE FROM comments WHERE id = '%s'", mysql_real_escape_string($id)); $result = getDBResultAffected($dbQuery); header("Content-type: application/json"); echo json_encode($result); }
function updateTutor($name, $gender, $phone, $email, $class, $year, $major, $password, $id) { echo $id; $dbQuery = sprintf("UPDATE Tutor SET name = '%s', gender = '%d', phone = '%d', class = '%d', year = '%d', major = '%d', email = '%s', password = '******' WHERE id = '%d'", mysql_real_escape_string($name), $gender, $phone, $class, $year, $major, mysql_real_escape_string($email), mysql_real_escape_string($password), $id); $result = getDBResultAffected($dbQuery); echo json_encode($result); }