php - 从数据库中的两个输入框中搜索数据在PHP

Question

This question already has answers here:

mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result
                                
                                    （32个答案）
                                
                        
                                在10个月前关闭。
            
                    
这是警告显示：mysqli_fetch_assoc（）期望参数1为mysqli_result，布尔值在

这里我的数据库

-------------------------------------------------
'ID   Bus_Name   Stopage_Name   Time   Distance
-------------------------------------------------
 1    Radha       Chandni       5.00      0
-------------------------------------------------
 2    Radha       Metro         5.30      50
-------------------------------------------------
 3    Radha       Park          6.00      100
-------------------------------------------------
 4    Radha       Lal           6.30      150
-------------------------------------------------
 5    Rani        Lal           5.00      0
-------------------------------------------------
 6    Rani        Metro         6.00      100
-------------------------------------------------
 7    Rani        Crossing      6.30      150
-------------------------------------------------
 8    Rani        Bazzar        7.00      250
-------------------------------------------------
 9    Crish       Lal           12.00     0
-------------------------------------------------
 10   Crish       Metro         12.30     50
-------------------------------------------------
 11   Crish       Crossing      01.00     100
-------------------------------------------------
 12   Crish       Bazzar        01.30     150
-------------------------------------------------
 13   Crish       Mill          02.00     200'
-------------------------------------------------



<form action="" method="POST">
    <input type="text" name="txtStart">
    <input type="text" name="txtEnd">
    <input type="submit" value="Search" name="search">
</form>'

的PHP

<?php
if(isset($_POST['search']))
{   
  $strkey1=$_POST['txtStart'];
  $strkey2=$_POST['txtEnd'];
  $sql="SELECT *FROM  bus_details WHERE Stopage_Name BETWEEN 
        $strkey1 AND $strkey2";
  $query=mysqli_query($ccon,$sql);
  while($row=mysqli_fetch_assoc($query))
  {'
  ?>'       
  '<table>
      <tr>
        <th>BUS NAME</th>
        <th>STOPAGE NAME</th>
        <th>TIME</th>
        <th>DISTANCE</th>
    </tr>'

最佳答案

根据我的理解，您正在内部varchar数据类型中进行搜索，而搜索的方式是错误的。您必须将值放在single quote或double quote之间

$sql="SELECT * FROM  bus_details WHERE Stopage_Name BETWEEN 
    '$strkey1' AND '$strkey2' ";

如何在varchar DataType中申请BETWEEN？基本上，您可以将BETWEEN用于日期，数字等范围。

您的查询应如下所示

sql="SELECT * FROM  bus_details WHERE Stopage_Name LIKE 
    '%$strkey1%' AND '%$strkey2%' ";

请参阅 MYSQL BETWEEN

关于php - 从数据库中的两个输入框中搜索数据在PHP ，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/55789906/

上一篇：sql - 从日期范围生成天数

下一篇：php - 使用 php 脚本备份包含 3 个月前数据的特定表

Answer 1

根据我的理解，您正在内部varchar数据类型中进行搜索，而搜索的方式是错误的。您必须将值放在single quote或double quote之间

$sql="SELECT * FROM  bus_details WHERE Stopage_Name BETWEEN 
    '$strkey1' AND '$strkey2' ";

如何在varchar DataType中申请BETWEEN？基本上，您可以将BETWEEN用于日期，数字等范围。

您的查询应如下所示

sql="SELECT * FROM  bus_details WHERE Stopage_Name LIKE 
    '%$strkey1%' AND '%$strkey2%' ";

请参阅 MYSQL BETWEEN