Get the selected rows from the mysqli_stmt as an array full of standard objects using mysqli

gistfile1.php

<?php
/**
 * Returns all the selected rows as an array full of objects
 * @param MySQLi_STMT $stmt
 * @return array
 */
public function getResult($stmt)
{
    if (is_a($stmt, 'MySQLi_STMT')) {
        $result = array();

        $metadata = $stmt->result_metadata();
        $fields = $metadata->fetch_fields();

        for (; ;)
        {
            $pointers = array();
            $row = new \stdClass();

            $pointers[] = $stmt;
            foreach ($fields as $field)
            {
                $fieldname = $field->name;
                $pointers[] = &$row->$fieldname;
            }

            call_user_func_array('mysqli_stmt_bind_result', $pointers);

            if (!$stmt->fetch())
                break;

            $result[] = $row;
        }

        $metadata->free();
            
        return $result;
    }
    return array();
}

/**
 * Gets the first row from a select statement
 * @param MySQLi_STMT $stmt
 * @return stdClass
 */
public function getRow($stmt)
{
    $result = $this->getResult($stmt);
    if ($result && !empty($result)) {
        return $result[0];
    }
    return $result;
}