php代码不能在在线主机上完美运行,但可以在本地主机上运行

cetgtptt  于 2021-06-17  发布在  Mysql
关注(0)|答案(1)|浏览(274)

我的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;
}

?>
qni6mghb

qni6mghb1#

您需要传递联机数据库的配置:

$connect = mysqli_connect("DOMAIN", "LIVE_MYSQL_USER", "LIVE_MYSQL_PASSWORD", "mall");

相关问题