在mysqli中获取多行

Question

I am working on a little project, but unfortunately, my hosting does not support the package mysqldn, therefore I am unable to work with fetch_all() function. This is the block of code thats causing headaches to me.

public function fetch($type = 'object')
{
    if (isset($this->result))
    {
        switch ($type)
        {
            case 'array':

                //fetch a row as array
                //$row = $this->result->fetch_all();
                $rows = array();
                while($row = $this->result->fetch_assoc())
                {
                    $rows[] = $row;
                }
            break;

            case 'object':

            //fall through...

            default:

                //fetch a row as object
                $row = $this->result->fetch_object();   

            break;
        }

        return $rows;
    }

    return FALSE;
}

As I said previously, I can not use fetch_all() function on my current hosting. Therefore, is there any alternative to that function? what can I do?

Answer 1

The native mysqli->fetch() function will return the next row in the resultset until it reaches the end.

Just call it once if you just want to get the next row, or you can include it in a loop if you want to get all rows, for example

while($row = $this->result->fetch())
{
    //Do something with $row
}

Edit: This relates to fetching results for prepared statements only, and would only work where $this->result held the result of store_result() after execution of a prepared statement.