把这个页面弄的好看些去掉表格phpincludeconfigphp; 连接数据库$search = $_POSTsearch;$str =SELECT FROM wenzhang WHERE wenzhang_name LIKE $search OR wenzhang_neirong LIKE $search OR wenzhang_miaoshu LIKE $search
以下是去掉表格并美化页面后的代码:
<?php
include('config.php'); //连接数据库
$search = $_POST['search'];
$str ="SELECT * FROM wenzhang WHERE (wenzhang_name LIKE '%" . $search . "%' OR wenzhang_neirong LIKE '%" . $search . "%' OR wenzhang_miaoshu LIKE '%" . $search . "%') and wenzhang_shenhe = '已通过' order by wenzhang_new LIMIT 20;";
$result = mysqli_query($con,$str);
$arr=array();
while($row = mysqli_fetch_array($result))
{
$arr[] = $row;
$user_id = $row['user_login_id'];
$sql = "SELECT * FROM user WHERE user_login_id = '$user_id'";
$result2 = mysqli_query($con, $sql);
$user_info = mysqli_fetch_assoc($result2);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询中心</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
<style>
body {
font-family: Arial, sans-serif;
}
form {
margin-bottom: 20px;
}
input[type="text"] {
padding: 5px;
width: 300px;
}
input[type="submit"] {
padding: 5px 10px;
background-color: #4CAF50;
color: white;
border: none;
cursor: pointer;
}
table {
width: 100%;
border-collapse: collapse;
}
th, td {
padding: 10px;
text-align: left;
}
th {
background-color: #4CAF50;
color: white;
}
tr:nth-child(even) {
background-color: #f2f2f2;
}
</style>
</head>
<body>
<div align="center">
<form action="" method="post">
<input type="text" name="search" value="" placeholder="">
<input type="submit" name="submit" value="搜索">
</form>
<?php
foreach ($arr as $key=>$value)
{
?>
<div>
<h3><?php echo $value['wenzhang_name'];?></h3>
<p>作者: <?php echo $user_info['user_name'];?></p>
<p><?php echo $value['wenzhang_miaoshu'];?></p>
<p>点赞: <?php echo $value['wenzhang_dianzan'];?></p>
<p>浏览: <?php echo $value['wenzhang_view'];?></p>
</div>
<?php
}
?>
</div>
</body>
</html>
我将表格替换为了使用 <div> 元素来显示查询结果,同时添加了一些样式来美化页面
原文地址: https://www.cveoy.top/t/topic/hUvE 著作权归作者所有。请勿转载和采集!