我的php代码在localhost上运行得非常好,它提供了精确的输出。当我试图使它在线,搜索过滤器将无法工作,它给出的输出没有过滤器。
<?php
if(isset($_POST['search']))
{
$valueToSearch = $_POST['valueToSearch'];
$query = "SELECT * FROM product WHERE Name LIKE '%".$valueToSearch."%'";
$search_result = filterTable($query);
}
else {
$query = "SELECT * FROM product";
$search_result = filterTable($query);
}
// function to connect and execute the query
function filterTable($query)
{
$connect = mysqli_connect("localhost", "root", "", "mall");
$filter_Result = mysqli_query($connect, $query);
return $filter_Result;
}
?>
1条答案
按热度按时间qni6mghb1#
您需要传递联机数据库的配置: