}
}
} elseif ($action = 'rank') {
$data = array();
//最长的编辑时间
if (isValid(array('sitename'))) {
$siteName = escapeParameters(array('sitename'), $mysqli)['sitename'];
$query = "SELECT * FROM `wikiplus_statistics` WHERE `wikiname` = '{$siteName}' ORDER BY `wikiplus_statistics`.`usetime` DESC LIMIT 10";
} else {
$query = "SELECT * FROM `wikiplus_statistics` ORDER BY `wikiplus_statistics`.`usetime` DESC LIMIT 10";
}
$res = $mysqli->query($query)->fetch_all(MYSQLI_ASSOC);
if (count($res) > 0) {
$data['longest'] = $res;
}
//最短的编辑时间
if (isValid(array('sitename'))) {
$siteName = escapeParameters(array('sitename'), $mysqli)['sitename'];
$query = "SELECT * FROM `wikiplus_statistics` WHERE `wikiname` = '{$siteName}' ORDER BY `wikiplus_statistics`.`usetime` ASC LIMIT 10";
} else {
$query = "SELECT * FROM `wikiplus_statistics` ORDER BY `wikiplus_statistics`.`usetime` ASC LIMIT 10";
}
$res = $mysqli->query($query)->fetch_all(MYSQLI_ASSOC);
if (count($res) > 0) {
$data['shortest'] = $res;
}
exit(json_encode($data));
} else {
exit;
}
}
{
foreach ($array as $value) {
if (!isset($_GET[$value]) || empty($_GET[$value])) {
return false;
}
}
return true;
}
//转义提交数据
function escapeParameters($params, $mysqli)
{
$paramsArray = array();
foreach ($params as $value) {
$paramsArray[$value] = mysqli_real_escape_string($mysqli, $_GET[$value]);
}
return $paramsArray;
}
if (isValid(array('wikiname', 'username', 'usetime', 'pagename'))) {
//连接数据库
$mysqli = new mysqli($DB_Host, $DB_UserName, $DB_UserPass, $DB_Name);
$params = escapeParameters(array('wikiname', 'username', 'usetime', 'pagename'), $mysqli);
$wikiname = $params['wikiname'];
$username = $params['username'];
$usetime = (int) $params['usetime'];
$pagename = $params['pagename'];
$query = "INSERT INTO wikiplus_statistics (wikiname,username,usetime,pagename) VALUES ('{$wikiname}','{$username}',{$usetime},'{$pagename}')";
$res = $mysqli->query($query);
if ($res) {
echo '{"result":"success"}';
}
}
