Esempi in PHP per dbModel::deleteItem

Esempio n. 1

File: dropTable.php Progetto: LeoComing/Registration

 * Date: 2015/12/23
 * Time: 16:53
 */
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
require '../../../../../Model/dbModel.php';
//获取button_id值
$button_id = $_GET["q"];
//$button_id = "adasddasdsads";
$dbModel = new dbModel();
//删除与button_id同名的表
$tableName = $button_id;
$dropTblSql = "DROP TABLE IF EXISTS " . $tableName;
$resDropTbl = $dbModel->dropTable($dropTblSql);
//删除task_regis中的数据
$task_id = substr($button_id, -10);
//取出后10位
//$task_id = substr($lastLetter,0,10);//取出前10位
$deleteSql = "DELETE FROM task_regis WHERE id = " . $task_id;
$resDel = $dbModel->deleteItem($deleteSql);
if ($resDropTbl == "删除成功" && $resDel == "删除成功") {
    echo "success";
    //页面跳转
    $url = "http://demo-firstlab.huawei.com:8081/Registration/pcController/manage_Console/taskController/tasks/task.php?p=1";
    if (isset($url)) {
        Header("Location: {$url}");
    }
} else {
    echo "fail";
}