模糊查询.php

最新推荐文章于 2022-09-01 21:23:50 发布

Vivian_shuang

最新推荐文章于 2022-09-01 21:23:50 发布

阅读量525

点赞数

分类专栏： php 文章标签： php

本文链接：https://blog.csdn.net/Vivian_shuang/article/details/52213895

版权

php 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        th,td{
            border:1px solid deeppink;
        }
    </style>

</head>
<body>
<table border="1px">
    <th>id</th>
    <th>username</th>
    <th>password</th>
    <th>tel</th>
    <?php
    require_once "initsql.php";
    if ($_POST){
        $search = @$_POST["search"];
    }else{
        $search = "";
    }
    $sql = "SELECT * FROM user WHERE username LIKE '%$search%'";
    $result = mysql_query($sql);
    while ($row = mysql_fetch_assoc($result)){
        echo "<tr>";
//        echo "<td>";
//        echo $row['id'];
//        echo "</td>";
//        echo "<td>";
//        echo $row['username'];
//        echo "</td>";
//        echo "<td>";
//        echo $row['password'];
//        echo "</td>";
//        echo "<td>";
//        echo $row['tel'];
//        echo "</td>";
        foreach ($row as $key => $item){
            echo "<td>";
            if ($key == "username"){
                echo str_replace($search,"<font color='aqua'>{$search}</font>",$item);
            }else{
                echo $item;
            }
            echo "</td>";
        }
        echo "</tr>";
    }
    ?>
</table>
<form action="mohuchaxun.php" method="post">
    <input type="text" name="search">
    <input type="submit" value="提交">
</form>
</body>
</html>