请写一个统计市场监管局4月份处理的占道经营数据统计的页面,可以使用任意语言
时间: 2024-06-11 10:08:07 浏览: 6
<!DOCTYPE html>
<html>
<head>
<title>市场监管局4月份占道经营数据统计</title>
<style type="text/css">
table {
border-collapse: collapse;
width: 100%;
}
th, td {
border: 1px solid black;
padding: 8px;
text-align: center;
}
th {
background-color: #4CAF50;
color: white;
}
tr:nth-child(even) {
background-color: #f2f2f2;
}
.btn {
background-color: #4CAF50;
color: white;
padding: 12px 20px;
border: none;
cursor: pointer;
border-radius: 5px;
}
.btn:hover {
background-color: #2E8B57;
}
.form-group {
margin-bottom: 10px;
}
.form-group label {
display: inline-block;
width: 150px;
font-weight: bold;
margin-right: 10px;
}
.form-group input {
padding: 5px;
border-radius: 5px;
border: 1px solid #ccc;
width: 250px;
}
.form-group select {
padding: 5px;
border-radius: 5px;
border: 1px solid #ccc;
width: 256px;
}
</style>
</head>
<body>
<h1>市场监管局4月份占道经营数据统计</h1>
<form method="post">
<div class="form-group">
<label for="start_date">起始日期:</label>
<input type="date" id="start_date" name="start_date">
</div>
<div class="form-group">
<label for="end_date">结束日期:</label>
<input type="date" id="end_date" name="end_date">
</div>
<div class="form-group">
<label for="area">区域:</label>
<select id="area" name="area">
<option value="">请选择</option>
<option value="东城区">东城区</option>
<option value="西城区">西城区</option>
<option value="朝阳区">朝阳区</option>
<option value="海淀区">海淀区</option>
<option value="丰台区">丰台区</option>
<option value="石景山区">石景山区</option>
<option value="通州区">通州区</option>
<option value="顺义区">顺义区</option>
<option value="昌平区">昌平区</option>
<option value="大兴区">大兴区</option>
<option value="怀柔区">怀柔区</option>
<option value="平谷区">平谷区</option>
<option value="延庆区">延庆区</option>
<option value="密云区">密云区</option>
</select>
</div>
<button type="submit" class="btn">查询</button>
</form>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$start_date = $_POST["start_date"];
$end_date = $_POST["end_date"];
$area = $_POST["area"];
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
die("连接失败:" . mysqli_connect_error());
}
// 查询数据
$sql = "SELECT COUNT(*) AS total, SUM(fine) AS revenue FROM business WHERE date BETWEEN '$start_date' AND '$end_date'";
if (!empty($area)) {
$sql .= " AND area='$area'";
}
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$total = $row["total"];
$revenue = $row["revenue"];
echo "<p>查询结果:共有 $total 宗占道经营行为,罚款总额为 $revenue 元。</p>";
// 显示数据表格
$sql = "SELECT * FROM business WHERE date BETWEEN '$start_date' AND '$end_date'";
if (!empty($area)) {
$sql .= " AND area='$area'";
}
$result = mysqli_query($conn, $sql);
echo "<table>";
echo "<tr><th>序号</th><th>日期</th><th>地点</th><th>经营者</th><th>行业类别</th><th>罚款金额</th></tr>";
while ($row = mysqli_fetch_assoc($result)) {
$id = $row["id"];
$date = $row["date"];
$location = $row["location"];
$operator = $row["operator"];
$category = $row["category"];
$fine = $row["fine"];
echo "<tr><td>$id</td><td>$date</td><td>$location</td><td>$operator</td><td>$category</td><td>$fine</td></tr>";
}
echo "</table>";
} else {
echo "<p>未查询到符合条件的数据。</p>";
}
mysqli_close($conn);
}
?>
</body>
</html>
相关推荐
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![pptx](https://img-home.csdnimg.cn/images/20210720083543.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)