<?php
require "needlogin.php";
require "mysql.php";
$pdohandler = Get_DB_Handler();
$sql = "UPDATE `" . DB_PRE . "task` SET `waitdelete` = 1 WHERE endtime < " . time();
$paramshandler = $pdohandler->prepare($sql);
$paramshandler->execute();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>操作完成!</title>
<!-- Bootstrap core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="signin.css" rel="stylesheet">
<!-- Just for debugging purposes. Don't actually copy this line! -->
<!--[if lt IE 9]><script src="http://bootstrap.evget.com/assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
<!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
function easymysql_select_adv($table, $column)
{
$pdohandler = Get_DB_Handler();
//处理sql
$sql = "SELECT * FROM `" . DB_PRE . $table . "`";
if (count($column) > 0) {
$sql .= " WHERE";
$i = 0;
foreach ($column as $key => $val) {
if ($i != 0) {
$sql .= " AND";
}
$sql .= " `" . $key . "` = :" . $key;
$i++;
}
}
$sql .= ";";
$paramshandler = $pdohandler->prepare($sql);
if (count($column) > 0) {
foreach ($column as $key => $val) {
$paramshandler->bindValue(":" . $key, $val);
}
}
$paramshandler->execute();
$result = $paramshandler->fetchALL(PDO::FETCH_ASSOC);
return $result;
}
