PHP delete_vdo示例

示例#1

文件： my_audio.php 项目： Terry89tx/itzUncut-Version-2.0

<?php

session_start();
include "include/config.php";
include "include/function.php";
chk_member_login();
if ($_POST[remove_video] != "") {
    $msg = delete_vdo($VID, $_SESSION[UID]);
}
//PAGING STARTS
if ($page == "") {
    $page = 1;
}
$sql = "SELECT count(*) as total from audio WHERE UID={$_SESSION['UID']} limit {$config['total_per_ini']}";
$ars = $conn->Execute($sql);
if ($ars->fields['total'] <= $config[total_per_ini]) {
    $total = $ars->fields['total'];
} else {
    $total = $config[total_per_ini];
}
$tpage = ceil($total / $config[items_per_page]);
if ($tpage == 0) {
    $spage = $tpage + 1;
} else {
    $spage = $tpage;
}
$startfrom = ($page - 1) * $config[items_per_page];
$sql = "select * from audio WHERE UID={$_SESSION['UID']} limit {$startfrom}, {$config['items_per_page']}";
$rs = $conn->execute($sql);
if ($rs->recordcount() > 0) {
    $vdo = $rs->getrows();

示例#2

文件： my_video.php 项目： Terry89tx/itzUncut-Version-2.0

<?php

session_start();
include "include/config.php";
include "include/function.php";
chk_member_login();
if ($_REQUEST[remove_video] != "") {
    $msg = delete_vdo($_REQUEST[VID], $_SESSION[UID]);
    $sql = "DELETE from video where vid='{$_REQUEST['VID']}'";
    $path = $config['BASE_DIR'] . "/video/" . $_REQUEST[VID] . ".mpg";
    if (file_exists($path)) {
        unlink($path);
    }
    $ars = $conn->Execute($sql);
}
//PAGING STARTS
if ($_REQUEST[page] == "") {
    $page = 1;
} else {
    $page = $_REQUEST[page];
}
$sql = "SELECT count(*) as total from video WHERE UID={$_SESSION['UID']} limit {$config['total_per_ini']}";
$ars = $conn->Execute($sql);
if ($ars->fields['total'] <= $config[total_per_ini]) {
    $total = $ars->fields['total'];
} else {
    $total = $config[total_per_ini];
}
$tpage = ceil($total / $config[items_per_page]);
if ($tpage == 0) {
    $spage = $tpage + 1;