Esempi in PHP per DbMySqli::delete

Esempio n. 1

File: reply_delete_proc.php Progetto: kisstest/snu_stress_manage

$idx = $_POST["idx"];
$page = $_POST['page'];
$search = $_POST['search'];
$table = "tbl_qna";
$fields = "idx";
$where_sql = " where reply_idx = '{$idx}'";
$data = $db->get_record($table, $fields, $where_sql);
$f_idx = $data["idx"];
$fields = "filename";
$where_sql = " where idx = '{$idx}'";
$data = $db->get_record($table, $fields, $where_sql);
if ($data != "") {
    $filename = $data["filename"];
    delete_file($filepath1, $filename);
}
$db->delete($table, "idx = '{$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. 2

File: delete_proc.php Progetto: kisstest/snu_stress_manage

<?php

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
set_time_limit(0);
$db = new DbMySqli();
$idx = $_POST['idx'];
$search = $_POST['search'];
if (!is_array($idx)) {
    $idx = array($idx);
}
foreach ($idx as $arr_idx) {
    $db->delete("tbl_session3", "idx = '{$arr_idx}'");
}
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="search" value="<?php 
echo $search;
?>
">
</form>

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

Esempio n. 3

File: delete_proc.php Progetto: kisstest/snu_stress_manage

<?php

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
set_time_limit(0);
$db = new DbMySqli();
$idx = $_POST['idx'];
$search = $_POST['search'];
if (!is_array($idx)) {
    $idx = array($idx);
}
foreach ($idx as $arr_idx) {
    $db->delete("tbl_faq", "idx = '{$arr_idx}'");
}
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="search" value="<?php 
echo $search;
?>
">
</form>

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

Esempio n. 4

File: delete_proc.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'];
$checker = $_REQUEST['checker'];
$no = $_REQUEST['no'];
if ($mode == "del_log_1") {
    $db->delete("iroad_log_test", "no = '{$no}'");
}
if ($mode == "del_log_2") {
    $db->delete("iroad_log_dlog", "no = '{$no}'");
}
if ($mode == "del_log_3") {
    for ($i = 0; $i < 10; $i++) {
        if (!$chk[$i]) {
            continue;
        }
        $db->delete("iroad_log_test", "no = '{$chk[$i]}'");
    }
}
if ($mode == "del_log_4") {
    for ($i = 0; $i <= 10; $i++) {
        if (!$chk[$i]) {
            continue;
        }
        $db->delete("iroad_log_dlog", "no = '{$chk[$i]}'");
    }
}

Esempio n. 5

File: delete_proc_20151027.php Progetto: kisstest/snu_stress_manage

$data = $db->get_record($table, $fields, $where_sql);
if ($data != "") {
    $reply_idx = $data["reply_idx"];
    $filename = $data["filename"];
    delete_file($filepath1, $filename);
}
//답변글 삭제 시작
if ($reply_idx > 0) {
    $fields = "filename";
    $where_sql = " where idx = '{$reply_idx}'";
    $data = $db->get_record($table, $fields, $where_sql);
    if ($data != "") {
        $filename = $data["filename"];
        delete_file($filepath1, $filename);
    }
    $db->delete($table, "idx = '{$reply_idx}'");
}
//답변글 삭제 끝
$db->delete($table, "idx = '{$idx}'");
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="search" value="<?php 
echo $search;
?>
" />
</form>

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

Esempio n. 6

File: delete_proc.php Progetto: kisstest/snu_stress_manage

<?php

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_master.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
set_time_limit(0);
$db = new DbMySqli();
$idx = $_POST['idx'];
if (!is_array($idx)) {
    $idx = array($idx);
}
foreach ($idx as $arr_idx) {
    $db->delete("tbl_admin", "idx = '{$arr_idx}'");
}
?>
<form name="pagemove" method="post" action="list.php">
</form>

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

Esempio n. 7

File: delete_proc.php Progetto: kisstest/snu_stress_manage

<?php

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
set_time_limit(0);
$db = new DbMySqli();
$idx = $_POST['idx'];
$search = $_POST['search'];
if (!is_array($idx)) {
    $idx = array($idx);
}
foreach ($idx as $arr_idx) {
    $db->delete("tbl_notice", "idx = '{$arr_idx}'");
}
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="search" value="<?php 
echo $search;
?>
">
</form>

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

Esempio n. 8

File: delete_proc.php Progetto: kisstest/snu_stress_manage

<?php

include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
set_time_limit(0);
$db = new DbMySqli();
$idx = $_POST['idx'];
$search = $_POST['search'];
if (!is_array($idx)) {
    $idx = array($idx);
}
foreach ($idx as $arr_idx) {
    $db->delete("tbl_postscript", "idx = '{$arr_idx}'");
}
?>
<form name="pagemove" method="post" action="list.php">
<input type="hidden" name="search" value="<?php 
echo $search;
?>
">
</form>

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