PHP getDBResultAffected 예제들

예제 #1

파일: transaction.php 프로젝트: chenjian221/PetFeederUserHomepage

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);
}

예제 #2

파일: student.php 프로젝트: chenjian221/PetFeederUserHomepage

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);
}

예제 #3

파일: mentor_maximum.php 프로젝트: schen381/MentorWeb

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;
}

예제 #4

파일: pedestrain.php 프로젝트: TaylorDIsom/AppsOverNaps

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);
}

예제 #5

파일: tutor.php 프로젝트: chenjian221/PetFeederUserHomepage

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);
}