<?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
把这个页面弄的好看些phpincludeconfigphp; 连接数据库$search = $_POSTsearch;$str =SELECT FROM wenzhang WHERE wenzhang_name LIKE $search OR wenzhang_neirong LIKE $search OR wenzhang_miaoshu LIKE $search a

原文地址: https://www.cveoy.top/t/topic/hUvx 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录