Product details query function (drop-down box infinite classification operation)

1, first you need a form form

<form method="get" action="">
<select name="gid">
    <option value="0">请选择商品</option>
    <option id="" value=""></option>
    <input id="select" type="submit" value="查询">
</select>
</form>

2, use Infinitus classification to loop through the drop-down box

The code is as follows:

<?php
function show($fid,$i)
{
    global $mysqli;
    $sql = "select *from goodstype where fid=$fid";
    $result = $mysqli->query($sql);
    $str=" ";
    $i++;
    for($n=1;$n<$i;$n++) {
        $str .= "---";
    }
    $id=$_GET["gid"];
    ?>
    <?php
    while ($row = $result->fetch_assoc()) {
        ?>
        <option <?php if($id==$row['id']){echo "selected";}?> id="<?php echo $str.$row["classname"] ?>" value="<?php echo $row["id"] ?>">
            <?php echo $str.$row["classname"] ?>
        </option>
        <?php
        show($fid=$row["id"],$i);
        ?>
        <?php
    }
}
show(0,0);

3, add query conditions

We need to perform fuzzy query on the products to be queried. We only need to change the sql statement. The code is as follows

<?php
    $id=isset($_GET["gid"])?$id=$_GET["gid"]:"";
    if(!empty($id)){
        $sql="select *from goods where goodstypefid=$id or goodstypefstr like '%$id%' and checkinfo=1 and delstate=0";
    }else{
        $sql="select *from goods";
    }
    $result=$mysqli->query($sql);
    ?>

4, give the page Optimize it

Add a time display, the code is as follows:

<?php
<!--    显示当前系统时间-->
    <h3><p id="demo"></p>
        <script>
            var myVar=setInterval(function(){myTimer()},1000);
            function myTimer() {
                var d = new Date();
                document.getElementById("demo").innerHTML = d.toLocaleTimeString();
            }
        </script>
    </h3>

Add some borders and the overall code is as follows:

<?php
header("Content-type:text/html;charset=utf-8");
include "mysqli.php";
?>
<div style='width:800px;float:none'>
    <h1>商品列表</h1>
    <!--    显示当前系统时间-->
    <h3><p id="demo"></p>
        <script>
            var myVar=setInterval(function(){myTimer()},1000);
            function myTimer() {
                var d = new Date();
                document.getElementById("demo").innerHTML = d.toLocaleTimeString();
            }
        </script>
    </h3>
    <form method="get" action="">
    <table style="100%" border="1">
        <tr>
            <td>
                <select name="gid">
                    <option value="0">请选择商品</option>
<?php
function show($fid,$i)
{
    global $mysqli;
    $sql = "select *from goodstype where fid=$fid";
    $result = $mysqli->query($sql);
    $str=" ";
    $i++;
    for($n=1;$n<$i;$n++) {
        $str .= "---";
    }
    $id=$_GET["gid"];
    ?>
    <?php
    while ($row = $result->fetch_assoc()) {
        ?>
        <option <?php if($id==$row['id']){echo "selected";}?> id="<?php echo $str.$row["classname"] ?>" value="<?php echo $row["id"] ?>">
            <?php echo $str.$row["classname"] ?>
        </option>
        <?php
        show($fid=$row["id"],$i);
        ?>
        <?php
    }
}
show(0,0);
    ?>
     <input id="select" type="submit" value="查询"></select></td></tr>
    </table>
    </form>
</div>
<div style="float: none;width: 600px">
<?php
    $id=isset($_GET["gid"])?$id=$_GET["gid"]:"";
    if(!empty($id)){
        $sql="select *from goods where goodstypefid=$id or goodstypefstr like '%$id%' and checkinfo=1 and delstate=0";
    }else{
        $sql="select *from goods";
    }
    $result=$mysqli->query($sql);
    ?>
<table border="1" cellpadding="3" cellspacing="0" width="60%">
    <tr bgcolor="skyblue">
<?php
  while($row=$result->fetch_assoc()){
?>
<td >
    <image width="200px" height="200px" src="<?php echo $row["picurl"]?>"></image>
    <a title="查看商品详细信息" href="goodsshow.php?id=<?php echo $row["id"]?>"><?php echo $row["title"]?></a>
</td>
<?php
  }
      ?>
    </tr>
</table>
</div>

5, the effect display: