PHP checkresult 예제들

예제 #1

파일: dobook.php 프로젝트: TinyNiko/simplelibrary

function ret($id, $db)
{
    $stmt = $db->stmt_init();
    $sql = "delete from stateinfo where book_id=?";
    $stmt->prepare($sql);
    $stmt->bind_param("s", $id);
    $stmt->execute();
    checkresult($stmt->affected_rows);
    $stmt->close();
}

예제 #2

파일: adminstuwork.php 프로젝트: TinyNiko/simplelibrary

function delete($data, $db)
{
    $stmt = $db->stmt_init();
    $userid = $data->{"userid"} != null ? $data->{"userid"} : "NULL";
    $sql = "delete from userinfo where user_id=?";
    $stmt->prepare($sql);
    $stmt->bind_param("s", $userid);
    $stmt->execute();
    checkresult($stmt->affected_rows);
    $stmt->close();
}

예제 #3

파일: adminbookwork.php 프로젝트: TinyNiko/simplelibrary

function delete($data, $db)
{
    $stmt = $db->stmt_init();
    $bookserial = $data->{"bookserial"} != null ? $data->{"bookserial"} : "NULL";
    $sql = "delete from bookinfo where book_serial=?";
    $stmt->prepare($sql);
    $stmt->bind_param("s", $bookserial);
    $stmt->execute();
    checkresult($stmt->affected_rows);
    $stmt->close();
}