个人中心
gpt4 book ai didi

php - 如何从 MySQL 数据库搜索和显示数据

转载 作者：行者123 更新时间：2023-11-29 15:37:38 26 4
gpt4 key购买 nike

我怎样才能从 mysql 表字段中搜索和检索数据。找到记录后，系统会通知用户已找到记录。我已经使用操作和 php 脚本创建了 html 表单，以从数据库中获取数据。

当我点击搜索时，它只显示未找到任何记录。

我想从表中的 3 个字段中获取数据。

下面是我的 html 表单

<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Conduct Database Search</title>
  <style type="text/css">
    body,
    td,
    th {
      font-family: "Gill Sans", "Gill Sans MT", "Myriad Pro", "DejaVu Sans Condensed", Helvetica, Arial, sans-serif;
      font-size: 16px;
    }
  </style>
</head>

<body>
  <p><img src="images/logonew.png" width="150" height="73" alt="Find Real Me Logo" /> </p>
  <hr>
  <p>Welcome to the conduct database search page. You can verify domestic worker's conduct and history.
  </p>
  <p>Search database by entering First name, Middle name and ID No. below and click the Search Conduct Database.
  </p>
  <form id="form1" action="search15.php" name="form1" method="post">
    <p>
      <label for="First_name">First name:</label>
      <input name="First_name" type="text" required="required" id="First_name" title="First name" size="30" maxlength="30">
    </p>
    <p>
      <label for="Last_name">Last name:</label>
      <input name="Last_name" type="text" required="required" id="Last_name" title="last_name" size="30" maxlength="30">
    </p>
    <p>
      <label for="ID_NO">ID Number:</label>
      <input name="ID_NO" type="number" required="required" id="ID_NO" title="ID_NO">
    </p>
    <p>
      <input name="submit" type="submit" id="submit" formaction="search15.php" formmethod="POST" value="Search Conduct  Database">
    </p>
    <p>&nbsp;</p>
  </form>
  <hr>
  <p>Copyright All Rights Reserved </p>
</body>

</html>

```
<html>

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <!-- TemplateBeginEditable name="doctitle" -->
  <title>Conduct Database Search Results</title>
  <!-- TemplateEndEditable -->
  <!-- TemplateBeginEditable name="head" -->
  <!-- TemplateEndEditable -->
  <style type="text/css">
    <!-- body {
      font: 100%/1.4 Verdana, Arial, Helvetica, sans-serif;
      background-color: #006600;
      margin: 0;
      padding: 0;
      color: #000;
    }
    /* ~~ Element/tag selectors ~~ */

    ul,
    ol,
    dl {
      /* Due to variations between browsers, it's best practices to zero padding and margin 
    on lists. For consistency, you can either specify the amounts you want here, or on the list items 
    (LI, DT, DD) they contain. Remember that what you do here will cascade to the .nav list unless you 
    write a more specific selector. */
      padding: 0;
      margin: 0;
    }

    h1,
    h2,
    h3,
    h4,
    h5,
    h6,
    p {
      margin-top: 0;
      /* removing the top margin gets around an issue where margins can escape from their 
    containing div. The remaining bottom margin will hold it away from any elements that follow. */
      padding-right: 15px;
      padding-left: 15px;
      /* adding the padding to the sides of the elements within the divs, instead of 
    the divs themselves, gets rid of any box model math. A nested div with side padding can also be 
    used as an alternate method. */
    }

    a img {
      /* this selector removes the default blue border displayed in some browsers around an image 
    when it is surrounded by a link */
      border: none;
    }
    /* ~~ Styling for your site's links must remain in this order - including the group of selectors 
    that 
    create the hover effect. ~~ */

    a:link {
      color: #42413C;
      text-decoration: underline;
      /* unless you style your links to look extremely unique, it's best to 
    provide underlines for quick visual identification */
    }

    a:visited {
      color: #6E6C64;
      text-decoration: underline;
    }

    a:hover,
    a:active,
    a:focus {
      /* this group of selectors will give a keyboard navigator the same 
    hover 
    experience as the person using a mouse. */
      text-decoration: none;
    }
    /* ~~ this fixed width container surrounds the other divs ~~ */

    .container {
      width: 960px;
      background-color: #FFF;
      margin: 0 auto;
      /* the auto value on the sides, coupled with the width, centers the layout */
    }
    /* ~~ the header is not given a width. It will extend the full width of your layout. It contains an 
    image placeholder that should be replaced with your own linked logo ~~ */

    .header {
      background-color: #FFFFFF;
    }
    /* ~~ This is the layout information. ~~ 

    1) Padding is only placed on the top and/or bottom of the div. The elements within this div have 
    padding on their sides. This saves you from any "box model math". Keep in mind, if you add any side 
    padding or border to the div itself, it will be added to the width you define to create the *total* 
    width. You may also choose to remove the padding on the element in the div and place a second div 
    within it with no width and the padding necessary for your design.

    */

    .content {
      padding: 10px 0;
    }
    /* ~~ The footer ~~ */

    .footer {
      padding: 10px 0;
      background-color: #333333;
      color: #CCC;
    }
    /* ~~ miscellaneous float/clear classes ~~ */

    .fltrt {
      /* this class can be used to float an element right in your page. The floated element must 
    precede the element it should be next to on the page. */
      float: right;
      margin-left: 8px;
    }

    .fltlft {
      /* this class can be used to float an element left in your page. The floated element must 
    precede the element it should be next to on the page. */
      float: left;
      margin-right: 8px;
    }

    .clearfloat {
      /* this class can be placed on a <br /> or empty div as the final element following 
    the last floated div (within the #container) if the #footer is removed or taken out of the 
     #container */
      clear: both;
      height: 0;
      font-size: 1px;
      line-height: 0px;
    }

    -->
  </style>
</head>

<body>

  <div class="container">
    <div class="header">
      <div align="left">
        <a href="#"> </a>
        <img src="logo.png" width="180" height="88"></div>

      <!-- end .header -->
    </div>
    <div class="content">
      <div align="right"></div>
      <div align="right">
        <p><a href="http://localhost/frm_test2">Home</a> | <a href="http://localhost/frm_test2/services">Services </a> | <a href="http://localhost/frm_test2/contact">Contact</a> | <a href="http://localhost/frm_test/conduct_check.html">Search Again</a></p>
        <hr>
        <p>&nbsp;</p>
      </div>
      <h1>Results</h1>
      <?php 
     //load database connection
     $host = "localhost";
     $user = "mydata";
     $password = "mydata";
     $database_name = "mydata";
     $pdo = new PDO("mysql:host=$host;dbname=$database_name", $user, $password, array(
     PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
     ));
    // Search from MySQL database table
    $search=$_POST['submit'];
    $query = $pdo->prepare("select * from red_data1 where ID_NO LIKE '%$search%' OR First_name LIKE 
    '%$search%' OR Middle_name LIKE '%$search%' OR Last_name LIKE '%$search%' LIMIT 0 , 10");
    $query->bindValue(1, "%$search%", PDO::PARAM_STR);
    $query->execute();
    // Display search result
         if (!$query->rowCount() == 0) {
                echo "Your Reference Search <b>found</b> the following in our database:<br/> <br/>";
                echo "<a href='http://localhost/frm_test2/contact' target='_blank'>Click here </a> to 
    contact us for more information relating to your search.<br/> <br/>";
                echo "<table style=\"font-family:arial;color:#333333;\">";  
                echo "<tr><td style=\"border-style:solid;border-width:1px;border- 
    color:#98bf21;background:#98bf21;\">ID No.</td><td style=\"border-style:solid;border- 
    width:1px;border-color:#98bf21;background:#98bf21;\">First Name</td><td style=\"border- 
    style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">Middle Name</td><td 
    style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">Last 
    Name</td> 
    </tr>";             
            while ($results = $query->fetch()) {
                echo "<tr><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">";            
                echo $results['ID_NO'];
                echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">";
                echo $results['First_name'];
                echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">";
                echo $results['Middle_name'];
                echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">";
                echo $results['Last_name'];
                echo "</td></tr>";              
            }
                echo "</table>";        
        } else {
            echo 'No Records found ';
        }
     ?>
      <p>&nbsp;</p>
      <!-- end .content -->
    </div>
    <div class="footer">
      <p align="center">Copyright </p>
      <!-- end .footer -->
    </div>
    <!-- end .container -->
  </div>



</body>

</html>

最佳答案

$search = $_POST['搜索'];

$sql = "SELECT * FROM TABLE_NAME WHERE CONCAT('数据库列名') LIKE '%".$search."%' ";

关于php - 如何从 MySQL 数据库搜索和显示数据，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/58072966/

26 4 0
文章推荐： javascript - 如何正确执行从react-native到express.js和mySQL后端的POST请求
文章推荐： android - Dagger 无法提供 Kotlin 注入(inject)
文章推荐： android - Realm 使用主键插入或更新对象
文章推荐： mysql - 查询 : Find customers who have made purchase of every type of flower offered by shop
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com