首页 \ 问答 \ 使用PHP进行精确值搜索(Exact value search with PHP)

使用PHP进行精确值搜索(Exact value search with PHP)

 我正在使用以下代码来搜索生成的表并过滤数据。 我的问题是，当我搜索让我们说1 ，它不会搜索和过滤仅1而是包含1的数据，如11, 21, etc. 。  
 如何搜索并过滤我输入的确切数据？  
<?php

if(isset($_POST['search']))
{
    $valueToSearch = $_POST['valueToSearch'];
    // search in all table columns
    // using concat mysql function
    $query = "SELECT * FROM `tbstats` WHERE CONCAT(`date`, `mode`, `svar`, `sdev`) LIKE '%".$valueToSearch."%'";
    $search_result = filterTable($query);

}
 else {
    $query = "SELECT * FROM `tbstats`";
    $search_result = filterTable($query);
}


function filterTable($query)
{
    $connect = mysqli_connect("localhost", "root", "", "dbstats");
    $filter_Result = mysqli_query($connect, $query);
    return $filter_Result;
}

?>

<!DOCTYPE html>
<html>
    <head>
        <title>Stats</title>
        <style>
            table,tr,th,td
            {
                border: 1px solid black;
            }
        </style>
    </head>
    <body>

        <form action="stats_filter.php" method="post">
            <input type="text" name="valueToSearch" placeholder="Value To Search"><br><br>
            <input type="submit" name="search" value="Filter"><br><br>

            <table>
                <tr>
                    <th>Date</th>
                    <th>Mode</th>
                    <th>Svar</th>
                    <th>Sdev</th>
                </tr>


                <?php while($row = mysqli_fetch_array($search_result)):?>
                <tr>
                    <td><?php echo $row['date'];?></td>
                    <td><?php echo $row['mode'];?></td>
                    <td><?php echo $row['svar'];?></td>
                    <td><?php echo $row['sdev'];?></td>
                </tr>
                <?php endwhile;?>
            </table>
        </form>

    </body>
</html>

I'm using the following code to search the generated table and filter data. My problem is that when I search for lets say 1, it doesn't search & filter only 1 but also the data containing 1 like 11, 21, etc. .  
How can I make it search and filter the exact data I enter?  
<?php

if(isset($_POST['search']))
{
    $valueToSearch = $_POST['valueToSearch'];
    // search in all table columns
    // using concat mysql function
    $query = "SELECT * FROM `tbstats` WHERE CONCAT(`date`, `mode`, `svar`, `sdev`) LIKE '%".$valueToSearch."%'";
    $search_result = filterTable($query);

}
 else {
    $query = "SELECT * FROM `tbstats`";
    $search_result = filterTable($query);
}


function filterTable($query)
{
    $connect = mysqli_connect("localhost", "root", "", "dbstats");
    $filter_Result = mysqli_query($connect, $query);
    return $filter_Result;
}

?>

<!DOCTYPE html>
<html>
    <head>
        <title>Stats</title>
        <style>
            table,tr,th,td
            {
                border: 1px solid black;
            }
        </style>
    </head>
    <body>

        <form action="stats_filter.php" method="post">
            <input type="text" name="valueToSearch" placeholder="Value To Search"><br><br>
            <input type="submit" name="search" value="Filter"><br><br>

            <table>
                <tr>
                    <th>Date</th>
                    <th>Mode</th>
                    <th>Svar</th>
                    <th>Sdev</th>
                </tr>


                <?php while($row = mysqli_fetch_array($search_result)):?>
                <tr>
                    <td><?php echo $row['date'];?></td>
                    <td><?php echo $row['mode'];?></td>
                    <td><?php echo $row['svar'];?></td>
                    <td><?php echo $row['sdev'];?></td>
                </tr>
                <?php endwhile;?>
            </table>
        </form>

    </body>
</html>

原文：https://stackoverflow.com/questions/51443382

更新时间：2022-09-24 21:09

最满意答案

 
  我想删除使用LibGit2Sharp从远程存储库克隆的本地repo文件夹。 我在这里读到，我必须在删除之前Dispose（）存储库。  
 
 LibGit2Sharp保持.git文件夹中的一些文件（主要是出于性能原因的包文件）。 调用Dispose()将释放这些句柄并释放非托管内存。  
 因此，依赖using语句确实是一个强烈的建议（或者，至少在完成时使用Dispose()存储库实例）。  
 如果你不这样做，那么当你的AppDomain卸载时，这些句柄最终将通过终结器发布，但是你将不能真正控制将要发生的“何时”。  
 编辑：再次读你的代码，我忽略了一些东西。 推荐的模式是  
using (var repo = new LibGit2Sharp.Repository(path))
{
    // Do amazing stuff
}
 
 要么  
var repo = new LibGit2Sharp.Repository(path);
// Do amazing stuff
repo.Dispose();
 
 事实上，一旦代码到达作用域的末尾， using语句将自动发出对Dispose()的调用。  
 
  访问路径'c16566a7-202a-4c8a-84de-3e3caadd5af9'被拒绝。  
 
 关于这一点，我认为这与LibGit2Sharp无关。  
 这个过程（试图删除以guid命名的文件夹）在授予足够权限的身份下运行？ 

 
 I would like to delete the local repo folder that I cloned from remote repository using LibGit2Sharp. I read here here that I have to Dispose() the Repository before I can delete it. 
 
LibGit2Sharp keeps hold on some files in the .git folder (mainly the packfiles for performance reasons). Calling Dispose() will release those handles and deallocate the non managed memory. 
As such, it's indeed a strong recommendation to rely on the using statement (or, at the very least to Dispose() the Repository instance when you're done with it). 
If you don't do this, those handles will eventually be released through finalizers when your AppDomain has unloaded, but you will have no real control regarding "when" that's going to happen. 
Edit: Reading your code once again, I overlooked something. The recommended pattern is either 
using (var repo = new LibGit2Sharp.Repository(path))
{
    // Do amazing stuff
}
 
or  
var repo = new LibGit2Sharp.Repository(path);
// Do amazing stuff
repo.Dispose();
 
Indeed, the using statement will automatically issue a call to Dispose() once the code reach the end of the scope. 
 
 Access to the path 'c16566a7-202a-4c8a-84de-3e3caadd5af9' is denied. 
 
Regarding this point, I think this has nothing to do with LibGit2Sharp. 
Is the process (trying to delete the folder named after a guid) running under an identity granted with enough rights to do so?

使用PHP进行精确值搜索(Exact value search with PHP)

最满意答案

相关问答

LibGit2Sharp CheckoutPaths（）(LibGit2Sharp CheckoutPaths())[2022-04-27]

用LibGit2Sharp编程删除本地存储库(Programmatically delete local repository with LibGit2Sharp)[2022-02-17]

使用libgit2sharp从远程存储库获取更新(Usage of libgit2sharp to get updates from remote repository)[2022-04-03]

使用libgit2sharp检出远程分支(Checking out remote branch using libgit2sharp)[2023-09-10]

LibGit2Sharp是否支持初始化共享存储库？(Does LibGit2Sharp support initialize shared repository?)[2023-11-15]

使用LibGit2Sharp截断GIT提交历史记录(Using LibGit2Sharp to truncate GIT commit history)[2020-08-18]

LibGit2Sharp 1冲突阻止结帐(LibGit2Sharp 1 conflict prevent from checkout)[2022-04-29]

LibGit2Sharp是否支持从本地文件系统克隆存储库？(Does LibGit2Sharp support cloning a repository from the local file system?)[2020-02-19]

LibGit2Sharp无响应(LibGit2Sharp Unresponsiveness)[2023-09-26]

使用libgit2sharp导出(Do an export with libgit2sharp)[2022-04-21]

相关文章

最新问答