MDB2_Statement_pgsql Class Reference

Inheritance diagram for MDB2_Statement_pgsql:

Collaboration diagram for MDB2_Statement_pgsql:

Public Member Functions
&	_execute ($result_class=true, $result_wrap_class=false)
	Execute a prepared query statement helper method. More...
	free ()
	Release resources allocated for the specified prepared query. More...
Public Member Functions inherited from MDB2_Statement_Common
	__construct (&$db, &$statement, $positions, $query, $types, $result_types, $is_manip=false, $limit=null, $offset=null)
	Constructor. More...
	MDB2_Statement_Common (&$db, &$statement, $positions, $query, $types, $result_types, $is_manip=false, $limit=null, $offset=null)
	PHP 4 Constructor. More...
	bindValue ($parameter, $value, $type=null)
	Set the value of a parameter of a prepared query. More...
	bindValueArray ($values, $types=null)
	Set the values of multiple a parameter of a prepared query in bulk. More...
	bindParam ($parameter, &$value, $type=null)
	Bind a variable to a parameter of a prepared query. More...
	bindParamArray (&$values, $types=null)
	Bind the variables of multiple a parameter of a prepared query in bulk. More...
&	execute ($values=null, $result_class=true, $result_wrap_class=false)
	Execute a prepared query statement. More...
&	_execute ($result_class=true, $result_wrap_class=false)
	Execute a prepared query statement helper method. More...
	free ()
	Release resources allocated for the specified prepared query. More...

Additional Inherited Members
Data Fields inherited from MDB2_Statement_Common
	$db
	$statement
	$query
	$result_types
	$types
	$values = array()
	$limit
	$offset
	$is_manip

Detailed Description

Definition at line 1310 of file pgsql.php.

Member Function Documentation

_execute()

& MDB2_Statement_pgsql::_execute	(		$result_class = true,
			$result_wrap_class = false
	)

Execute a prepared query statement helper method.

Parameters

mixed	$result_class	string which specifies which result class to use
mixed	$result_wrap_class	string which specifies which class to wrap results in

Returns

mixed a result handle or MDB2_OK on success, a MDB2 error on failure private

Definition at line 1322 of file pgsql.php.

References MDB2_Driver_Common\$connection, $data, $query, $result, $type, array, PEAR\isError(), MDB2_ERROR_NOT_FOUND, and MDB2_Driver_Common\query().

    {
        if (is_null($this->statement)) {
            $result =& parent::_execute($result_class, $result_wrap_class);
            return $result;
        }
        $this->db->last_query = $this->query;
        $this->db->debug($this->query, 'execute', array('is_manip' => $this->is_manip, 'when' => 'pre', 'parameters' => $this->values));
        if ($this->db->getOption('disable_query')) {
            $result = $this->is_manip ? 0 : null;
            return $result;
        }

        $connection = $this->db->getConnection();
        if (PEAR::isError($connection)) {
            return $connection;
        }

        $query = false;
        $parameters = array();
        // todo: disabled until pg_execute() bytea issues are cleared up
        if (true || !function_exists('pg_execute')) {
            $query = 'EXECUTE '.$this->statement;
        }
        if (!empty($this->positions)) {
            foreach ($this->positions as $parameter) {
                if (!array_key_exists($parameter, $this->values)) {
                    return $this->db->raiseError(MDB2_ERROR_NOT_FOUND, null, null,
                        'Unable to bind to missing placeholder: '.$parameter, __FUNCTION__);
                }
                $value = $this->values[$parameter];
                $type = array_key_exists($parameter, $this->types) ? $this->types[$parameter] : null;
                if (is_resource($value) || $type == 'clob' || $type == 'blob') {
                    if (!is_resource($value) && preg_match('/^(\w+:\/\/)(.*)$/', $value, $match)) {
                        if ($match[1] == 'file://') {
                            $value = $match[2];
                        }
                        $value = @fopen($value, 'r');
                        $close = true;
                    }
                    if (is_resource($value)) {
                        $data = '';
                        while (!@feof($value)) {
                            $data.= @fread($value, $this->db->options['lob_buffer_length']);
                        }
                        if ($close) {
                            @fclose($value);
                        }
                        $value = $data;
                    }
                }
                $parameters[] = $this->db->quote($value, $type, $query);
            }
            if ($query) {
                $query.= ' ('.implode(', ', $parameters).')';
            }
        }

        if (!$query) {
            $result = @pg_execute($connection, $this->statement, $parameters);
            if (!$result) {
                $err =& $this->db->raiseError(null, null, null,
                    'Unable to execute statement', __FUNCTION__);
                return $err;
            }
        } else {
            $result = $this->db->_doQuery($query, $this->is_manip, $connection);
            if (PEAR::isError($result)) {
                return $result;
            }
        }

        if ($this->is_manip) {
            $affected_rows = $this->db->_affectedRows($connection, $result);
            return $affected_rows;
        }

        $result =& $this->db->_wrapResult($result, $this->result_types,
            $result_class, $result_wrap_class, $this->limit, $this->offset);
        $this->db->debug($this->query, 'execute', array('is_manip' => $this->is_manip, 'when' => 'post', 'result' => $result));
        return $result;
    }

Here is the call graph for this function:

free()

MDB2_Statement_pgsql::free

(

)

Release resources allocated for the specified prepared query.

Returns

mixed MDB2_OK on success, a MDB2 error on failure public

Definition at line 1414 of file pgsql.php.

References MDB2_Driver_Common\$connection, $query, $result, PEAR\isError(), MDB2_ERROR, and MDB2_OK.

    {
        if (is_null($this->positions)) {
            return $this->db->raiseError(MDB2_ERROR, null, null,
                'Prepared statement has already been freed', __FUNCTION__);
        }
        $result = MDB2_OK;

        if (!is_null($this->statement)) {
            $connection = $this->db->getConnection();
            if (PEAR::isError($connection)) {
                return $connection;
            }
            $query = 'DEALLOCATE PREPARE '.$this->statement;
            $result = $this->db->_doQuery($query, true, $connection);
        }

        parent::free();
        return $result;
    }

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• Services/Database/lib/PEAR/MDB2/Driver/pgsql.php