HTML 报表统计页面：动态日期选择、网点频次排名
<!DOCTYPE html>
<html>
<head>
<title>统计页面</title>
<style>
table {
border-collapse: collapse;
width: 100%;
}
th, td {
border: 1px solid black;
padding: 8px;
}
th {
background-color: #4CAF50;
color: white;
}
</style>
</head>
<body>
<h1>统计页面</h1>
<form>
<label for="date">选择日期：</label>
<input type="date" id="date" name="date" value="<?php echo date('Y-m-d'); ?>">
<label for="month">选择月份：</label>
<input type="month" id="month" name="month" value="<?php echo date('Y-m'); ?>">
<input type="submit" value="查询">
</form>
<br>
<?php
// 连接到数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");
<p>// 检查连接是否成功
if (!$conn) {
die("数据库连接失败：" . mysqli_connect_error());
}</p>
<p>// 获取日期和月份参数
$date = isset($_GET['date']) ? $_GET['date'] : date('Y-m-d');
$month = isset($_GET['month']) ? $_GET['month'] : date('Y-m');</p>
<p>// 查询数据库中频次最多的十个网点
$query = "SELECT website, COUNT(*) as frequency FROM table_name WHERE date = '$date' OR date LIKE '$month-%' GROUP BY website ORDER BY frequency DESC LIMIT 10";
$result = mysqli_query($conn, $query);</p>
<p>// 显示结果
if (mysqli_num_rows($result) > 0) {
echo "<table>";
echo "<tr><th>网点</th><th>频次</th></tr>";
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr><td>" . $row['website'] . "</td><td>" . $row['frequency'] . "</td></tr>";
}
echo "</table>";
} else {
echo "没有找到数据";
}</p>
<p>// 关闭数据库连接
mysqli_close($conn);
?></p>
</body>
</html>
原文地址: https://www.cveoy.top/t/topic/qnO8 著作权归作者所有。请勿转载和采集!