如何从数据库中的mysqli输入中搜索值

2021-12-25 00:00:00 php mysqli

我想在使用值的第一个字符时显示我的数据库值.让我用我的网站来描述它我有一个带有主页输入的网站，其中用户键入输入作为火车号.我需要那个用户类型的火车号.他从我存储的数据库中获得了火车名称.

解决方案

检查此代码.我认为它会对您有所帮助

<头><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>PHP、jQuery搜索演示</title><link rel="stylesheet" type="text/css" href="my.css"><script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script><script type="text/javascript">$(document).ready(function () {$("输入").keyup(function () {$('#results').html('');var searchString = $("#search_box").val();var data = 'search_text=' + searchString;如果(搜索字符串){$.ajax({类型:POST"，网址:'search.php'，数据:数据，数据类型:'文本'，异步:假，缓存:假，成功:功能(结果){$('#results').html(result);//window.location.reload();}});}});});<身体><div id="容器"><div style="margin:20px auto; text-align: center;"><form method="post" action="do_search.php"><input type="text" name="search" id="search_box" class='search_box'/><input type="submit" value="Search" class="search_button"/><br/></表单><div><div id="searchresults">搜索结果:</div><ul id="results" class="update">

首先为您输入的输入字段创建 html 和 jquery 代码然后调用使用ajax方法命中数据库的jquery函数keyup然后创建一个 php 文件来管理您的搜索我创建了一个 search.php 文件

connect_error){die("连接失败:" . $conn->connect_error);}$sql = "从 yourtable_name WHERE match_text LIKE '%$searchquery%' 中选择字段 1，字段 2";$result = $conn->query($sql);如果($result->num_rows>0){//输出每一行的数据while($row = $result->fetch_assoc()) {回声-名称:".$row["filed1"]."".$row["field2"]."<br>";}} 别的 {echo "0 结果";}$conn->close();?>

从此页面您将获得搜索结果，您可以根据需要进行更改.为了您的检查，您还可以添加搜索文本长度，如果您不搜索，如果搜索文本长度 > 2 或 etc

I want to show my database value when use type first character of the value. Let me describe it with my site I have a website with homepage input where user type input as train no. I need that user type train no. he got train name from my database where i store.

解决方案

check this code .i think it will help you

<html>
 <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>PHP, jQuery search demo</title>
<link rel="stylesheet" type="text/css" href="my.css">

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script type="text/javascript">
    $(document).ready(function () {
        $("input").keyup(function () {
            $('#results').html('');
            var searchString = $("#search_box").val();
            var data = 'search_text=' + searchString;
            if (searchString) {
                $.ajax({
                    type: "POST",
                    url: 'search.php',
                    data: data,
                    dataType: 'text',
                    async: false,
                    cache: false,
                    success: function (result) {
                        $('#results').html(result);
                        //window.location.reload();

                    }
                });
            }
        });
    });
  </script>

 </head>
  <body>
 <div id="container">
 <div style="margin:20px auto; text-align: center;">
    <form method="post" action="do_search.php">
        <input type="text" name="search" id="search_box" class='search_box'/>
        <input type="submit" value="Search" class="search_button"/><br/>
    </form>
</div>
<div>

    <div id="searchresults">Search results :</div>
    <ul id="results" class="update">
    </ul>

</div>
</div>

</body>
</html>

first create html and jquery code for input field which you type then call jquery function keyup which hit database using ajax method then create a php file which manage your search i create a search.php file

<?php
  $servername = "localhost";
  $username = "db_username";
  $password = "db_password";
  $dbname = "your_db_name";
  $searchquery = trim($_POST['search_text']); //input for search
  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
  }

 $sql = "SELECT  filed1, field2 FROM yourtable_name WHERE match_text LIKE '%$searchquery%'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
    echo " - Name: " . $row["filed1"]. " " . $row["field2"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();
?>

from this page you will get your search result and you can change it as your demand . for your check you can also add search text length if you do not search if search text length > 2 or etc

相关文章