把这个页面弄的好看些phpincludeconfigphp; 连接数据库$search = $_POSTsearch;$str =SELECT FROM wenzhang WHERE wenzhang_name LIKE $search OR wenzhang_neirong LIKE $search OR wenzhang_miaoshu LIKE $search a
<?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>
table,th,td{
border: 1px solid #000;
}
</style>
</head>
<body>
<div align="center">
<form action="" method="post">
<input type="text" name="search" value="" placeholder="">
<input type="submit" name="submit" value="搜索">
</form>
<table>
<th colspan="5">资源查询</th>
<tr>
<td>标题</td>
<td>作者</td>
<td>描述</td>
<td>点赞</td>
<td>浏览</td>
</tr>
<?php
foreach ($arr as $key=>$value)
{
?>
<tr>
<td><?php echo $value['wenzhang_name'];?></td>
<td><?php echo $user_info['user_name'];?></td>
<td><?php echo $value['wenzhang_miaoshu'];?></td>
<td><?php echo $value['wenzhang_dianzan'];?></td>
<td><?php echo $value['wenzhang_view'];?></td>
</tr>
<?php
}
?>
</table>
</div>
</body>
</html
原文地址: https://www.cveoy.top/t/topic/hUvx 著作权归作者所有。请勿转载和采集!