php oop从数据库中选择数据

Question

I'm trying to display some data stored into the database and i have this function but i don't know how it works :

public function resultToArray($result){

        if(is_a($result, 'mysqli_result') && $result->num_rows > 0) {

            $myArrayResult = array ();
            while ($row = $result->fetch_assoc()) {

                $myArrayResult[] = $row;
            }

            return ($myArrayResult);
        }

        else {

            return ("Invalid Formart or Empty Result");
        }
    }

How can i use this in my fron-end? I've tried this method but it failed...

$listar = new classes_DbManager;
$result ="Select * FROM jobs_offers";
$query = $listar->resultToArray($result);

if(mysqli_affected_rows>0){
    echo $row['username'];
}

Answer 1

without looking at the rest of your custom class, I can only guess that you are needing to execute the statement before retrieving the results. From your resultToArray function, it looks like it's making a call to mysqli_result which requires a result set to work.

search for something inside the classes_DbManager class that executes a query function first, it might contain code that looks something like $result = $mysqli->query("$sql_query")

my best guess would be its usage requiring something like this:

$listar = new classes_DbManager;
$query = "Select * FROM jobs_offers";
$result = $listar->executeQuery($query);
$query = $listar->resultToArray($result);

if(mysqli_affected_rows>0){
    echo $row['username'];
}