Esempi in PHP per DbMySqli::update

Esempio n. 1

File: modify_proc.php Progetto: kisstest/snu_stress_manage

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
$db = new DbMySqli();
$idx = $_POST['idx'];
$page = $_POST['page'];
$search = $_POST['search'];
$name = addslashes($_POST['name']);
$title = addslashes($_POST['title']);
$content = addslashes($_POST['content']);
$userip = $_SERVER['REMOTE_ADDR'];
$db['mb_uniqid'] = $admin_uniqid;
$db['name'] = $name;
$db['title'] = $title;
$db['content'] = $content;
$db['userip'] = $userip;
$db->update("tbl_postscript", "idx = '{$idx}'");
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="page" value="<?php 
echo $page;
?>
" />
<input type="hidden" name="search" value="<?php 
echo $search;
?>
" />
</form>

<script type="text/javascript">
<!--
alert("수정되었습니다.");

Esempio n. 2

File: modify_proc.php Progetto: kisstest/snu_stress_manage

        }
    }
} else {
    $origin_filename = $pre_origin_filename;
    $filename = $pre_filename;
    $filesize = $pre_filesize;
}
$userip = $_SERVER['REMOTE_ADDR'];
$db['name'] = $name;
$db['title'] = $title;
$db['content'] = $content;
$db['origin_filename'] = $origin_filename;
$db['filename'] = $filename;
$db['filesize'] = $filesize;
$db['userip'] = $userip;
$db->update("tbl_qna", "idx = '{$idx}'");
?>
<form name="pagemove" method="post" action="view.php">
<input type="hidden" name="idx" value="<?php 
echo $idx;
?>
" />
<input type="hidden" name="page" value="<?php 
echo $page;
?>
" />
<input type="hidden" name="search" value="<?php 
echo $search;
?>
" />
</form>

Esempio n. 3

File: 1session_proc.php Progetto: kisstest/snu_stress_manage

    $db['regdate'] = $nowdate;
    $idx_val = $db->insert($table, $idx_field);
    $_SESSION['session1_idx'] = $idx_val;
} else {
    $db['qst_1'] = $qst_1;
    $db['qst_2'] = $qst_2;
    $db['qst_3'] = $qst_3;
    $db['qst_4'] = $qst_4;
    $db['qst_5'] = $qst_5;
    $db['qst_6'] = $qst_6;
    $db['qst_7'] = $qst_7;
    $db['qst_8'] = $qst_8;
    $db['qst_9'] = $qst_9;
    $db['qst_10'] = $qst_10;
    $db['qst_11'] = $qst_11;
    $db['qst_12'] = $qst_12;
    $db['qst_13'] = $qst_13;
    $db['qst_14'] = $qst_14;
    $db['qst_15'] = $qst_15;
    $db['userip'] = $userip;
    $db->update($table, "idx = '{$session1_idx}'");
}
?>
<form name="pagemove" method="post" action="1session_13.php">
</form>

<script type="text/javascript">
<!--
pagemove.submit();
-->
</script>

Esempio n. 4

File: remember.php Progetto: kisstest/snu_stress_manage

<?php

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_master.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/top.php";
set_time_limit(0);
$db = new DbMySqli();
$mode = $_REQUEST['mode'];
$kind = $_REQUEST['kind'];
$no = $_REQUEST['no'];
if (!$kind) {
    if (!$mode) {
        $db['bookmark'] = '1';
        $db->update("iroad_log_dlog", "no = '{$no}'");
    }
    if ($mode == "del") {
        $db['bookmark'] = '';
        $db->update("iroad_log_dlog", "no = '{$no}'");
    }
} else {
    if (!$mode) {
        $db['bookmark'] = '1';
        $db->update("iroad_log_test", "no = '{$no}'");
    }
    if ($mode == "del") {
        $db['bookmark'] = '';
        $db->update("iroad_log_test", "no = '{$no}'");
    }
}
Replace($HTTP_REFERER);

Esempio n. 5

File: modify_proc.php Progetto: kisstest/snu_stress_manage

include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
$db = new DbMySqli();
$idx = $_POST['idx'];
$use_YN = $_POST['use_YN'];
$passwd = addslashes(trim($_POST['passwd']));
$name = addslashes($_POST['name']);
$phone = addslashes($_POST['phone']);
$mobile1 = addslashes($_POST['mobile1']);
$mobile2 = addslashes($_POST['mobile2']);
$mobile3 = addslashes($_POST['mobile3']);
if ($mobile1 != "" && $mobile2 != "" && $mobile3 != "") {
    $mobile = $mobile1 . "-" . $mobile2 . "-" . $mobile3;
}
$userip = $_SERVER['REMOTE_ADDR'];
$db['use_YN'] = $use_YN;
$db['passwd'] = "(hex(aes_encrypt('{$passwd}', '{$encrypt_code}')))";
$db['name'] = $name;
$db['phone'] = $phone;
$db['mobile'] = $mobile;
$db['userip'] = $userip;
$db->update("tbl_admin", "idx = '{$idx}'");
?>
<form name="pagemove" method="post" action="list.php">
</form>

<script type="text/javascript">
<!--
alert("수정되었습니다.");
pagemove.submit();
-->
</script>

Esempio n. 6

File: reply_proc.php Progetto: kisstest/snu_stress_manage

$rows = mysqli_fetch_row($result);
$max_idx = $rows[0];
$idx_field = "idx";
$db['mb_uniqid'] = $admin_uniqid;
$db['f_idx'] = $f_idx;
$db['thread'] = $new_thread;
$db['name'] = "관리자";
$db['content'] = $content;
$db['origin_filename'] = $origin_filename;
$db['filename'] = $filename;
$db['filesize'] = $filesize;
$db['userip'] = $userip;
$db['regdate'] = $nowdate;
$db->insert($table, $idx_field);
$db['reply_idx'] = $max_idx;
$db->update($table, "idx = '{$f_idx}'");
?>
<form name="pagemove" method="post" action="view.php">
<input type="hidden" name="idx" value="<?php 
echo $f_idx;
?>
" />
<input type="hidden" name="page" value="<?php 
echo $page;
?>
" />
<input type="hidden" name="search" value="<?php 
echo $search;
?>
" />
</form>

Esempio n. 7

File: modify_proc.php Progetto: kisstest/snu_stress_manage

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
$db = new DbMySqli();
$idx = $_POST['idx'];
$page = $_POST['page'];
$search = $_POST['search'];
$exposure_YN = $_POST['exposure_YN'];
$title = addslashes($_POST['title']);
$content = addslashes($_POST['content']);
$userip = $_SERVER['REMOTE_ADDR'];
$db['mb_uniqid'] = $admin_uniqid;
$db['exposure_YN'] = $exposure_YN;
$db['title'] = $title;
$db['content'] = $content;
$db['userip'] = $userip;
$db->update("tbl_faq", "idx = '{$idx}'");
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="page" value="<?php 
echo $page;
?>
" />
<input type="hidden" name="search" value="<?php 
echo $search;
?>
" />
</form>

<script type="text/javascript">
<!--
alert("수정되었습니다.");

Esempio n. 8

File: modify_proc.php Progetto: kisstest/snu_stress_manage

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
$db = new DbMySqli();
$idx = $_POST['idx'];
$page = $_POST['page'];
$search = $_POST['search'];
$name = addslashes($_POST['name']);
$title = addslashes($_POST['title']);
$content = addslashes($_POST['content']);
$userip = $_SERVER['REMOTE_ADDR'];
$db['mb_uniqid'] = $admin_uniqid;
$db['name'] = $name;
$db['title'] = $title;
$db['content'] = $content;
$db['userip'] = $userip;
$db->update("tbl_notice", "idx = '{$idx}'");
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="page" value="<?php 
echo $page;
?>
" />
<input type="hidden" name="search" value="<?php 
echo $search;
?>
" />
</form>

<script type="text/javascript">
<!--
alert("수정되었습니다.");