<?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; }