时间戳

首页 > 解决方案 > php mysql 搜索结果在列ID中显示列表

php - php mysql 搜索结果在列ID中显示列表

问题描述

我得到下面的 php 脚本搜索运行正常的 mysql 数据库，我尝试在表和第一列“ID”中列出搜索结果，例如。如果搜索结果找到 10 条记录，该表将在列 ID 中列出来自 No.1,2,3.....10 的 10 条记录；整天在谷歌上寻找解决方案但无法正确解决，任何人都可以告诉我如何实现这一目标？谢谢

 <!DOCTYPE html>
<html>   

  <body>

    <!-- [SEARCH FORM] -->
    <form method="post" action="welcome">
      <h2>WELCOME</h2>
      <p>Search criteria: key in name</p>
      <input type="text" name="search" required/>
      <input type="submit" value="Search"/>
    </form>
<br/>
<div align="left"><Font size="4"><a href="logout.php" style="margin-right:80px;">LOGOUT</a></font></div><br>
    <?php
if (isset($_POST['search']))
{
    
    require "2-search.php";
    
    echo ' <table border="1" cellspacing="0" cellpadding="5"> 
      <tr> 
          <td> <font face="Arial">No</font> </td> 
          <td> <font face="Arial">Prepaid</font> </td> 
          <td> <font face="Arial">postpaid</font> </td> 
          <td> <font face="Arial">Fiber</font> </td> 
          <td> <font face="Arial">Flex Device</font> </td> 
          
          <td> <font face="Arial">Name</font> </td> 
          <td> <font face="Arial">class</font> </td> 
          <td> <font face="Arial">AM</font> </td> 
          <td> <font face="Arial">AT</font> </td> 
          <td> <font face="Arial">shopfront_signage</font> </td> 
          
          <td> <font face="Arial">Photo1</font> </td> 
          <td> <font face="Arial">Photo2</font> </td> 
          <td> <font face="Arial">Photo3</font> </td> 
          <td> <font face="Arial">Photo4</font> </td> 
          <td> <font face="Arial">Photo5</font> </td> 
          
      </tr>';

    // DISPLAY RESULTS
    if (count($results) > 0)
    {
        foreach ($results as $r)
        {

            $field1name = $results; //<-----------this is first column ID to list the result from 1,2,3....
            $field2name = $r["pre_code"];
            $field3name = $r["post_code"];
            $field4name = $r["f_code"];
            $field5name = $r["device"];
            $field6name = $r["Name"];
            $field7name = $r["class"];
            $field8name = $r["AM"];
            $field9name = $r["AT"];
            $field10name = $r["shopfront_signage"];
            $field11name = $r["p1"];
            $field12name = $r["p2"];
            $field13name = $r["p3"];
            $field14name = $r["p4"];
            $field15name = $r["p5"];

            if ($field11name == '')
            {
                $img = 'default.png';
            }
            else
            {
                $img = $field11name;
            }
            if ($field12name == '')
            {
                $img2 = 'default.png';
            }
            else
            {
                $img2 = $field12name;
            }
            if ($field13name == '')
            {
                $img3 = 'default.png';
            }
            else
            {
                $img3 = $field13name;
            }
            if ($field14name == '')
            {
                $img4 = 'default.png';
            }
            else
            {
                $img4 = $field14name;
            }
            if ($field15name == '')
            {
                $img5 = 'default.png';
            }
            else
            {
                $img5 = $field15name;
            }

         
            echo '<tr style="width: 259px; vertical-align:top"> 
                  <td>' . $field1name . '</td>
                  <td>' . $field2name . '</td> 
                  <td >' . $field3name . '</td> 
                  <td >' . $field4name . '</td> 
                     <td>' . $field5name . '</td> 
                  <td>' . $field6name . '</td> 
                  <td >' . $field7name . '</td> 
                  <td >' . $field8name . '</td> 
                     <td>' . $field9name . '</td> 
                  <td>' . $field10name . '</td> 
                                 
                  <td><a href="/dealer/search/images/' . $img . '" target = "_blank"><img src="/dealer/search/images/' . $img . '" height="100" width="120"></td>
 <td><a href="/dealer/search/images/' . $img2 . '" target = "_blank"><img src="/dealer/search/images/' . $img2 . '" height="100" width="120"></td>
 <td><a href="/dealer/search/images/' . $img3 . '" target = "_blank"><img src="/dealer/search/images/' . $img3 . '" height="100" width="120"></td>
 <td><a href="/dealer/search/images/' . $img4 . '" target = "_blank"><img src="/dealer/search/images/' . $img4 . '" height="100" width="120"></td>
 <td><a href="/dealer/search/images/' . $img5 . '" target = "_blank"><img src="/dealer/search/images/' . $img5 . '" height="100" width="120"></td>

                   </tr>';
            
        }
        $result->free();

    }
    else
    {
        echo '<FONT COLOR="RED" SIZE="5">   &nbsp;&nbsp;&nbsp; >> &nbsp;&nbsp;&nbsp; NO RESULTS FOUND  </FONT>';
    }
    
    
}

?>
  </body>
 
  
</html>

标签： phpmysql

解决方案

最后我的代码工作了，这是解决方案：

  1. 在 php 中添加：$i=0;

  2. 在表格行中添加：++$i

谢谢。

推荐阅读