无法使用PHP连接数据库/从数据库获取结果

我正在尝试连接到数据库并在页面上显示信息。

这是型号

<?php
// model for the totals of the wreath orders
require_once("dbconnect.php");
// connect to database and check errors
@ $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$connection_error = $dbc->connect_error;
if ($connection_error != null) {
  echo "<p>Error connectiong to database: $connection_error</p>";
  exit();
}
?>

这是我构建字符串并尝试连接并在屏幕上显示数据的页面中的代码。

<?php
require_once('model.php');
$query = "SELECT * FROM people WHERE";
if  (isset ($_POST['fname'])) {
    $fname = $_POST['fname'];
    $query = $query . " fname = '" . $fname . "' AND";
}
if (isset ($_POST['lname'])) {
    $lname = $_POST['lname'];
    $query = $query . " lname = '" . $lname . "' AND";
}
if (isset ($_POST['age'])) {
    $age = $_POST['age'];
    $query = $query . " age = '" . $age . "' AND";
}
if (isset ($_POST['city'])) {
    $city = $_POST['city'];
    $query = $query . " city = '" . $city . "' AND";
}
$query = rtrim($query, " AND");
include('header.php');
?>
<div id="header">
<h1><strong>This is the information you requested</h1></strong>
</div>
<div id="main">
<?php
$results = $dbc->query($query);
$row_count = $result->num_rows;
for ($i = 0; $i < $row_count; $i++) :
        $product = $result->fetch_assoc();
    echo $product['fname'] . " | " . $product['lname'] . " | " . $product['age'] . " | " . $product['city'] . ' <br />';
endfor;
?>
</div>
<?php
include('footer.php');

这是我得到的错误

Notice: Undefined variable: result in C:'Program Files'wamp'www'testwebpage'Model'getinformation.php on line 34
Trying to get property of non-object in C:'Program Files'wamp'www'testwebpage'Model'getinformation.php on line 34

我可以说，我对此还很陌生，只是不确定代码会出什么问题。