显示记录或字段的非 OOP 方式 - MySQLI

我一直在使用mysql，它做了我想做的，但是随着我的项目越来越大，我决定选择mysqli。

我在这里查看了输入链接描述的教程，这真的很直截了当，直到我想显示一些数据

存储过程（连接.php）

<?php
function db_connect() {
    // Define connection as a static variable, to avoid connecting more than once 
    static $con;
    // Try and connect to the database, if a connection has not been established yet
    if(!isset($con)) {
         // Load configuration as an array. Use the actual location of your configuration file
        $config = parse_ini_file('config.ini'); 
        $con = mysqli_connect('localhost',$config['username'],$config['password'],$config['dbname']);
    }
    // If connection was not successful, handle the error
    if( $con === false) {
        // Handle error - notify administrator, log to a file, show an error screen, etc.
        return mysqli_connect_error(); 
    }
    return  $con;
}
function db_query($query) {
    // Connect to the database
     $con = db_connect();

    // Query the database
    $result = mysqli_query( $con,$query);
    return $result;
}
function db_error() {
     $con = db_connect();
        return mysqli_error($con);
}
function db_select($query) {
    $rows = array();
    $result = db_query($query);
    // If query failed, return `false`
    if($result === false) {
        return false;
    }
    // If query was successful, retrieve all the rows into an array
    while ($row = mysqli_fetch_assoc($result)) {
        $rows[] = $row;
    }
    return $rows;
}
function db_quote($value) {
     $con = db_connect();
        return "'" . mysqli_real_escape_string($con,$value) . "'";
}
?>

php/html

<div class="grid_4">
        <div class="left-1">
            <h2 class="top-1 p3">Find a property</h2>
            <form id="form-1" method="post" class="form-1 bot-1" action="prop_result.php">
                <div class="select-1">
                    <label>Select Area</label>
                    <select name="field4" id="field4" >
    <?php

$rows = db_select("SELECT id,city_id,area FROM area");
    if($rows === false) {
    $error = db_error();
    }else
    {
    while($rows=mysqli_fetch_assoc($result))
{
?>
<option value=""><?php $rows['
area'];?></option>
<?php 
}}
?>
                    </select>   
                </div>

我不明白的是如何在 while 循环中使用存储过程，以便它将输出字段 ID 和 Area 中的数据，以便我的选择框和任何其他输入都可以根据查询正确填充

当前

我尝试了不同的方法：

<?php

$rows = db_select("SELECT id,city_id,area FROM area");
    if($rows === false) {
    $error = db_error();
        }
    while($rows=mysqli_fetch_assoc($result))
{
?>
<option value=""><?php $rows['
area'];?></option>
<?php 
}
?>

和

$rows = db_select("SELECT id,city_id,area FROM area");
    if($rows === false) {
    $error = db_error();
        }
{
?>
<option value=""><?php $rows['
area'];?></option>
<?php 
}
?>

和

 <?php

$rows = db_select("SELECT area_id from property");
    if($rows === false) {
    $error = db_error();
    }
{
echo "<option value='".$rows['id']."'>".$rows[$col4]."</option>";
}
    ?>

这些都不输出任何数据。回显$rows不会提供任何数据。我不知道使用存储过程显示输出的逻辑是什么。

任何帮助将不胜感激，如果需要任何其他信息来帮助解决此问题，请告诉我。