PHP DbHelper::delete示例

示例#1

文件： DeleteLink.php 项目： yunsite/nadcmajinphpgame

<?php 
require_once '../lib/global.php';
$id = stripslashes($_GET['id']);
$newsDbHelper = new DbHelper("pg_gamelink");
$idlist = split(';', $id);
$id = '';
for ($i = 0; $i < count($idlist); $i++) {
    if ($i == 0) {
        $id .= $idlist[$i];
    } else {
        $id .= " or id=" . $idlist[$i];
    }
}
if ($newsDbHelper->delete($id) > 0) {
    echo "true";
} else {
    echo "false";
}

示例#2

文件： DeleteClass.php 项目： yunsite/nadcmajinphpgame

<?php 
require_once '../lib/global.php';
$id = stripslashes($_GET['id']);
$classDbHelper = new DbHelper("pg_gameclass");
$idlist = split(';', $id);
$id = '';
$classid = 'delete from pg_gamelink where ';
for ($i = 0; $i < count($idlist); $i++) {
    if ($i == 0) {
        $id .= $idlist[$i];
        $classid .= 'classid=' . $idlist[$i];
    } else {
        $id .= " or id=" . $idlist[$i];
        $classid .= ' or classid=' . $idlist[$i];
    }
}
if ($classDbHelper->querySql($classid) > 0 && $classDbHelper->delete($id)) {
    echo "true";
} else {
    echo "false";
}

示例#3

文件： Edit_Del_NewsType.php 项目： yunsite/nadcmajinphpgame

<?php

/* TODO: Add code here */
require_once '../lib/global.php';
$conn = new DbHelper("pg_newsclass");
$id = $_GET['id'];
$type = $_GET['type'];
$name = mysql_escape_string(stripslashes($_GET['name']));
if ($_GET['type'] == 1) {
    $conn->update($id, "name='{$name}'");
}
if ($_GET['type'] == 2) {
    if ($conn->delete($id) > 0) {
        echo "true";
    } else {
        echo "false";
    }
}
if ($_GET['type'] == 3) {
    $conn->insert('name', "'{$name}'");
}
echo "OK!";
echo "<script type='text/javascript' src='../js/common.js'></script><script>GotoOtherPage('EditNewsType.php','游戏类型修改成功！')</script>";

示例#4

文件： deletenews.php 项目： yunsite/nadcmajinphpgame

<?php 
require_once '../lib/global.php';
$id = stripslashes($_GET['id']);
$newsDbHelper = new DbHelper("pg_news");
if (1 == $newsDbHelper->delete($id)) {
    echo "true";
} else {
    echo "false";
}