File io/db/driver/mysql/MySQLSelectQueryResult.class.php

  1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 

<?php
/**
 * @package     IO
 * @subpackage  DB\driver\mysql
 * @copyright   &copy; 2005-2019 PHPBoost
 * @license     https://www.gnu.org/licenses/gpl-3.0.html GNU/GPL-3.0
 * @author      Loic ROUCHON <horn@phpboost.com>
 * @version     PHPBoost 5.2 - last update: 2014 12 22
 * @since       PHPBoost 3.0 - 2009 10 01
*/

class MySQLSelectQueryResult extends AbstractSelectQueryResult
{
    /**
     * @var Resource
     */
    private $resource = null;

    /**
     * @var int
     */
    private $index = 0;

    /**
     * @var string[string]
     */
    private $current = '';

    /**
     * @var int
     */
    private $fetch_mode;

    /**
     * @var bool
     */
    private $is_disposed = false;

    public function __construct($query, $parameters, $resource, $fetch_mode = self::FETCH_ASSOC)
    {
        $this->fetch_mode = $fetch_mode;
        $this->resource = $resource;
        parent::__construct($query, $parameters);
    }

    public function __destruct()
    {
        $this->dispose();
    }

    public function set_fetch_mode($fetch_mode)
    {
        $this->fetch_mode = $fetch_mode;
    }

    public function get_rows_count()
    {
        return mysqli_num_rows($this->resource);
    }

    public function rewind()
    {
        if ($this->index > 0)
        {
            @mysqli_data_seek($this->resource, 0);
            $this->index = 0;
        }
        $this->next();
    }

    public function valid()
    {
        return $this->current !== null;
    }

    public function current()
    {
        return $this->current;
    }

    public function key()
    {
        return $this->index;
    }

    public function next()
    {
        switch ($this->fetch_mode)
        {
            case SelectQueryResult::FETCH_NUM:
                $this->current = mysqli_fetch_row($this->resource);
                break;
            case SelectQueryResult::FETCH_ASSOC:
            default:
                $this->current = mysqli_fetch_assoc($this->resource);
                break;
        }
        $this->index++;
    }

    public function dispose()
    {
        if (!$this->is_disposed && is_resource($this->resource))
        {
            if (!@mysqli_free_result($this->resource))
            {
                throw new MySQLQuerierException('can\'t close sql resource');
            }
            $this->is_disposed = true;
        }
    }

    protected function needs_rewind()
    {
        return $this->index == 0;
    }
}
?>