好久没有用到原生PHP进行页面的开发了，昨天帮忙写了一个，不过脑子，也没有封装，像流水一样，哈哈哈哈
<!DOCTYPE html>
<html lang="zh_CN" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="referrer" content="no-referrer">
<meta name="robots" content="noindex,nofollow">
<meta http-equiv="X-UA-Compatible" content="IE=Edge">
<link rel="stylesheet" type="text/css" href="index.css">
<title>玩转上海</title>
</head>
<?php
$mysql_server = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "旅游数据库";
$conn = new mysqli($mysql_server, $mysql_username, $mysql_password, $mysql_database);
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$sql = "SELECT 类别,GROUP_CONCAT(DISTINCT 品种) as 品种 from 旅游数据表 GROUP BY 类别";
$category = $conn->query($sql);
$conn->close();
?>
<body>
<div class="main">
<div class="wp">
<h1 class="wzsh">玩转上海</h1>
</div>
<div class="wp2">
<h4 class="wzsh">(学生：张三 编辑)</h4>
</div>
<div class="line"></div>
<form action="list.php" method="get" class="form" onSubmit="return search();">
<?php
while ($row = $category->fetch_assoc()) {
echo "<div class='title'>" . $row["类别"] . "</div>";
$pinzhong = explode(',', $row["品种"]);
foreach ($pinzhong as $v) {
echo "<input type='radio' value={$v} name='pinzhong' />" . $v . "<br>";
}
}
?>
<input class="subbtn" type="submit" value="选择种类" />
</form>
<div class="line"></div>
</div>
<script>
function search() {
var pinzhongVal;
var pinzhong = document.getElementsByName('pinzhong');
for (var i = 0; i < pinzhong.length; i++) {
if (pinzhong[i].checked == true) {
pinzhongVal = pinzhong[i].value;
break;
}
}
if(pinzhongVal==undefined){
return false;
}
return true;
}
</script>
</body>
</html>
之前头疼的分页，如今很好写呢
<!DOCTYPE html>
<html lang="zh_CN" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="referrer" content="no-referrer">
<meta name="robots" content="noindex,nofollow">
<meta http-equiv="X-UA-Compatible" content="IE=Edge">
<link rel="stylesheet" type="text/css" href="index.css">
<title>玩转上海</title>
</head>
<?php
$mysql_server = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "旅游数据库";
$conn = new mysqli($mysql_server, $mysql_username, $mysql_password, $mysql_database);
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$pinzhong = $_GET['pinzhong'];
if(empty($pinzhong)) $pinzhong != '';
$where = "品种 = '{$pinzhong}'";
$count = $conn->query("SELECT count(*) as nums from 旅游数据表 where {$where}");
$totalRow = $count->fetch_row();
$totalNums = $totalRow[0];
$pageSize = 2;
$totalPage = ceil($totalNums / $pageSize);
$page = $_GET['page'] ? $_GET['page'] : 1;
if ($page > $totalPage) {
$page = $totalPage;
}
$num = ($page - 1) * $pageSize;
$sql = "SELECT * from 旅游数据表 where {$where} limit {$num},{$pageSize}";
$list = $conn->query($sql);
$conn->close();
?>
<body>
<div class="main">
<div class="wp2">
<h4 class="wzsh" style="text-align: left;">(学生：张三 编辑)</h4>
</div>
<div class="wp">
<h1 class="wzsh">玩转上海</h1>
</div>
<div class='title'>都市游</div>
<div class="rightcount">
<?php
echo "（发现 {$totalNums} 相关项目）";
?>
</div>
<table class="table">
<tr>
<th>编号</th>
<th>项目</th>
<th>简介</th>
<th>价格</th>
<th width=200>图片</th>
</tr>
<?php
if($list){
while ($row = $list->fetch_assoc()) {
echo "<tr><td>{$row['编号']}</td><td>{$row['项目']}</td><td>{$row['简介']}</td><td>{$row['价格']}</td><td height=100></td></tr>";
}
}
?>
</table>
<div>
<div class="fleft">
<form action="index.php" method="get">
<input class="subbtn" type="submit" value="选择别的种类" />
</form>
</div>
<div class="fright">
<?php
if($page>1){
echo "<input class='subbtn' onClick='up()' type='button' value='上一页' />";
}
if($totalPage>1 && $page<$totalPage){
echo "<input class='subbtn' onClick='next()' type='button' value='下一页' />";
}
?>
<!-- <input class="subbtn" type="button" value="上一页" /><input class="subbtn" type="button" value="下一页" /> -->
</div>
<div class="clear"></div>
</div>
</div>
<script>
function up(){
var page = "<?php echo $page?>";
var nextPage = parseInt(page) - 1;
var url = "pinzhong=<?php echo $pinzhong?>&page="+nextPage;
window.open("list.php?"+url,"_self");
}
function next(){
var page = "<?php echo $page?>";
var nextPage = parseInt(page) + 1;
var url = "pinzhong=<?php echo $pinzhong?>&page="+nextPage;
window.open("list.php?"+url,"_self");
}
</script>
</body>
</html>