I think a simple solution could be to add a new property and function like that:

protected $_last_statement = null;

public function execute($query, $input_parameters = array()) {
    $statement = self::$_db->prepare($query);
    $success = $statement->execute($input_parameters);
    $this->_last_statement = $statement;

    return $success;
}

After replacing code like

$statement = self::$_db->prepare($query);
$statement->execute($this->_values);

By:

$this->execute($query,$this->_values);

For example _run could be:

protected function _run() {
        $query = $this->_build_select();
        $caching_enabled = self::$_config['caching'];

        if ($caching_enabled) {
                $cache_key = self::_create_cache_key($query, $this->_values);
                $cached_result = self::_check_query_cache($cache_key);

                if ($cached_result !== false) {
                        return $cached_result;
                }
        }

        self::_log_query($query, $this->_values);
        $this->execute($query,$this->_values);

        $rows = array();
        while ($row = $this->_last_statement->fetch(PDO::FETCH_ASSOC)) {
                $rows[] = $row;
        }

        if ($caching_enabled) {
                self::_cache_query_result($cache_key, $rows);
        }

        return $rows;
}

rowCount #84

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions