MDB2_Result_Common Class Reference

Inheritance diagram for MDB2_Result_Common:

Collaboration diagram for MDB2_Result_Common:

Public Member Functions
	__construct (&$db, &$result, $limit=0, $offset=0)
	Constructor. More...
	MDB2_Result_Common (&$db, &$result, $limit=0, $offset=0)
	PHP 4 Constructor. More...
	setResultTypes ($types)
	Define the list of types to be associated with the columns of a given result set. More...
	seek ($rownum=0)
	Seek to a specific row in a result set. More...
&	fetchRow ($fetchmode=MDB2_FETCHMODE_DEFAULT, $rownum=null)
	Fetch and return a row of data. More...
	fetchOne ($colnum=0, $rownum=null)
	fetch single column from the next row from a result set More...
	fetchCol ($colnum=0)
	Fetch and return a column from the current row pointer position. More...
	fetchAll ($fetchmode=MDB2_FETCHMODE_DEFAULT, $rekey=false, $force_array=false, $group=false)
	Fetch and return all rows from the current row pointer position. More...
	rowCount ()
	Returns the actual row number that was last fetched (count from 0) More...
	numRows ()
	Returns the number of rows in a result object. More...
	nextResult ()
	Move the internal result pointer to the next available result. More...
	getColumnNames ($flip=false)
	Retrieve the names of columns returned by the DBMS in a query result or from the cache. More...
	_getColumnNames ()
	Retrieve the names of columns returned by the DBMS in a query result. More...
	numCols ()
	Count the number of columns returned by the DBMS in a query result. More...
	getResource ()
	return the resource associated with the result object More...
	bindColumn ($column, &$value, $type=null)
	Set bind variable to a column. More...
	_assignBindColumns ($row)
	Bind a variable to a value in the result row. More...
	free ()
	Free the internal resources associated with result. More...

Data Fields
	$db
	$result
	$rownum = -1
	$types = array()
	$values = array()
	$offset
	$offset_count = 0
	$limit
	$column_names

Detailed Description

Definition at line 3343 of file MDB2.php.

Constructor & Destructor Documentation

__construct()

MDB2_Result_Common::__construct	(	&	$db,
		&	$result,
			$limit = 0,
			$offset = 0
	)

Constructor.

Definition at line 3363 of file MDB2.php.

    {
        $this->db =& $db;
        $this->result =& $result;
        $this->offset = $offset;
        $this->limit = max(0, $limit - 1);
    }

References $db, $limit, $offset, and $result.

Referenced by MDB2_Result_Common().

Here is the caller graph for this function:

Member Function Documentation

_assignBindColumns()

MDB2_Result_Common::_assignBindColumns

(

$row

)

Bind a variable to a value in the result row.

Parameters

array

row data

Returns

mixed MDB2_OK on success, a MDB2 error on failure

@access private

Definition at line 3786 of file MDB2.php.

    {
        $row = array_values($row);
        foreach ($row as $column => $value) {
            if (array_key_exists($column, $this->values)) {
                $this->values[$column] = $value;
            }
        }
        return MDB2_OK;
    }

References $row, and MDB2_OK.

Referenced by MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Result_oci8\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), and MDB2_Result_pgsql\fetchRow().

Here is the caller graph for this function:

_getColumnNames()

MDB2_Result_Common::_getColumnNames

(

)

Retrieve the names of columns returned by the DBMS in a query result.

Returns

mixed Array variable that holds the names of columns as keys or an MDB2 error on failure. Some DBMS may not return any columns when the result set does not contain any rows.

@access private

Reimplemented in MDB2_Result_mysql, MDB2_Result_mysqli, MDB2_Result_oci8, and MDB2_Result_pgsql.

Definition at line 3702 of file MDB2.php.

    {
        return $this->db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
            'method not implemented', __FUNCTION__);
    }

References MDB2_ERROR_UNSUPPORTED.

bindColumn()

MDB2_Result_Common::bindColumn	(		$column,
		&	$value,
			$type = null
	)

Set bind variable to a column.

Parameters

int	column number or name
mixed	variable reference
string	specifies the type of the field

Returns

mixed MDB2_OK on success, a MDB2 error on failure

@access public

Definition at line 3754 of file MDB2.php.

    {
        if (!is_numeric($column)) {
            $column_names = $this->getColumnNames();
            if ($this->db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) {
                if ($this->db->options['field_case'] == CASE_LOWER) {
                    $column = strtolower($column);
                } else {
                    $column = strtoupper($column);
                }
            }
            $column = $column_names[$column];
        }
        $this->values[$column] =& $value;
        if (!is_null($type)) {
            $this->types[$column] = $type;
        }
        return MDB2_OK;
    }

References MDB2_OK, and MDB2_PORTABILITY_FIX_CASE.

fetchAll()

MDB2_Result_Common::fetchAll	(		$fetchmode = MDB2_FETCHMODE_DEFAULT,
			$rekey = false,
			$force_array = false,
			$group = false
	)

Fetch and return all rows from the current row pointer position.

Parameters

int	$fetchmode	the fetch mode to use: MDB2_FETCHMODE_ORDERED MDB2_FETCHMODE_ASSOC MDB2_FETCHMODE_ORDERED | MDB2_FETCHMODE_FLIPPED MDB2_FETCHMODE_ASSOC | MDB2_FETCHMODE_FLIPPED
	bool	if set to true, the $all will have the first column as its first dimension
	bool	used only when the query returns exactly two columns. If true, the values of the returned array will be one-element arrays instead of scalars.
	bool	if true, the values of the returned array is wrapped in another array. If the same key value (in the first column) repeats itself, the values will be appended to this array instead of overwriting the existing values.

Returns

mixed data array on success, a MDB2 error on failure

@access public

See also

getAssoc()

Definition at line 3550 of file MDB2.php.

    {
        $all = array();
        $row = $this->fetchRow($fetchmode);
        if (PEAR::isError($row)) {
            return $row;
        } elseif (!$row) {
            return $all;
        }
 
        $shift_array = $rekey ? false : null;
        if (!is_null($shift_array)) {
            if (is_object($row)) {
                $colnum = count(get_object_vars($row));
            } else {
                $colnum = count($row);
            }
            if ($colnum < 2) {
                return $this->db->raiseError(MDB2_ERROR_TRUNCATED, null, null,
                    'rekey feature requires atleast 2 column', __FUNCTION__);
            }
            $shift_array = (!$force_array && $colnum == 2);
        }
 
        if ($rekey) {
            do {
                if (is_object($row)) {
                    $arr = get_object_vars($row);
                    $key = reset($arr);
                    unset($row->{$key});
                } else {
                    if ($fetchmode & MDB2_FETCHMODE_ASSOC) {
                        $key = reset($row);
                        unset($row[key($row)]);
                    } else {
                        $key = array_shift($row);
                    }
                    if ($shift_array) {
                        $row = array_shift($row);
                    }
                }
                if ($group) {
                    $all[$key][] = $row;
                } else {
                    $all[$key] = $row;
                }
            } while (($row = $this->fetchRow($fetchmode)));
        } elseif ($fetchmode & MDB2_FETCHMODE_FLIPPED) {
            do {
                foreach ($row as $key => $val) {
                    $all[$key][] = $val;
                }
            } while (($row = $this->fetchRow($fetchmode)));
        } else {
            do {
                $all[] = $row;
            } while (($row = $this->fetchRow($fetchmode)));
        }
 
        return $all;
    }

References $row, fetchRow(), PEAR\isError(), MDB2_ERROR_TRUNCATED, and MDB2_FETCHMODE_ASSOC.

Here is the call graph for this function:

fetchCol()

MDB2_Result_Common::fetchCol

(

$colnum = 0

)

Fetch and return a column from the current row pointer position.

Parameters

int	the column number to fetch

Returns

mixed data array on success, a MDB2 error on failure

@access public

Definition at line 3504 of file MDB2.php.

    {
        $column = array();
        $fetchmode = is_numeric($colnum) ? MDB2_FETCHMODE_ORDERED : MDB2_FETCHMODE_ASSOC;
        $row = $this->fetchRow($fetchmode);
        if (is_array($row)) {
            if (!array_key_exists($colnum, $row)) {
                return $this->db->raiseError(MDB2_ERROR_TRUNCATED, null, null,
                    'column is not defined in the result set: '.$colnum, __FUNCTION__);
            }
            do {
                $column[] = $row[$colnum];
            } while (is_array($row = $this->fetchRow($fetchmode)));
        }
        if (PEAR::isError($row)) {
            return $row;
        }
        return $column;
    }

References $row, fetchRow(), PEAR\isError(), MDB2_ERROR_TRUNCATED, MDB2_FETCHMODE_ASSOC, and MDB2_FETCHMODE_ORDERED.

Here is the call graph for this function:

fetchOne()

MDB2_Result_Common::fetchOne	(		$colnum = 0,
			$rownum = null
	)

fetch single column from the next row from a result set

Parameters

int	the column number to fetch
int	number of the row where the data can be found

Returns

string data on success, a MDB2 error on failure

@access public

Definition at line 3478 of file MDB2.php.

    {
        $fetchmode = is_numeric($colnum) ? MDB2_FETCHMODE_ORDERED : MDB2_FETCHMODE_ASSOC;
        $row = $this->fetchRow($fetchmode, $rownum);
        if (!is_array($row) || PEAR::isError($row)) {
            return $row;
        }
        if (!array_key_exists($colnum, $row)) {
            return $this->db->raiseError(MDB2_ERROR_TRUNCATED, null, null,
                'column is not defined in the result set: '.$colnum, __FUNCTION__);
        }
        return $row[$colnum];
    }

References $row, $rownum, fetchRow(), PEAR\isError(), MDB2_ERROR_TRUNCATED, MDB2_FETCHMODE_ASSOC, and MDB2_FETCHMODE_ORDERED.

Here is the call graph for this function:

fetchRow()

& MDB2_Result_Common::fetchRow	(		$fetchmode = MDB2_FETCHMODE_DEFAULT,
			$rownum = null
	)

Fetch and return a row of data.

Parameters

int	how the array data should be indexed
int	number of the row where the data can be found

Returns

int data array on success, a MDB2 error on failure

@access public

Reimplemented in MDB2_Result_mysql, MDB2_Result_mysqli, MDB2_Result_oci8, MDB2_BufferedResult_oci8, and MDB2_Result_pgsql.

Definition at line 3458 of file MDB2.php.

    {
        $err =& $this->db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
            'method not implemented', __FUNCTION__);
        return $err;
    }

References MDB2_ERROR_UNSUPPORTED.

Referenced by fetchAll(), fetchCol(), fetchOne(), and seek().

Here is the caller graph for this function:

free()

MDB2_Result_Common::free

(

)

Free the internal resources associated with result.

Returns

bool true on success, false if result is invalid

@access public

Reimplemented in MDB2_Result_mysql, MDB2_Result_mysqli, MDB2_Result_oci8, MDB2_BufferedResult_oci8, and MDB2_Result_pgsql.

Definition at line 3807 of file MDB2.php.

    {
        $this->result = false;
        return MDB2_OK;
    }

References MDB2_OK.

getColumnNames()

MDB2_Result_Common::getColumnNames

(

$flip = false

)

Retrieve the names of columns returned by the DBMS in a query result or from the cache.

Parameters

bool	If set to true the values are the column names, otherwise the names of the columns are the keys.

Returns

mixed Array variable that holds the names of columns or an MDB2 error on failure. Some DBMS may not return any columns when the result set does not contain any rows.

@access public

Definition at line 3674 of file MDB2.php.

    {
        if (!isset($this->column_names)) {
            $result = $this->_getColumnNames();
            if (PEAR::isError($result)) {
                return $result;
            }
            $this->column_names = $result;
        }
        if ($flip) {
            return array_flip($this->column_names);
        }
        return $this->column_names;
    }

References $result, and PEAR\isError().

Referenced by MDB2_BufferedResult_oci8\fetchRow().

Here is the call graph for this function:

Here is the caller graph for this function:

getResource()

MDB2_Result_Common::getResource

(

)

return the resource associated with the result object

Returns

resource

@access public

Definition at line 3735 of file MDB2.php.

    {
        return $this->result;
    }

References $result.

MDB2_Result_Common()

MDB2_Result_Common::MDB2_Result_Common	(	&	$db,
		&	$result,
			$limit = 0,
			$offset = 0
	)

PHP 4 Constructor.

Definition at line 3377 of file MDB2.php.

    {
        $this->__construct($db, $result, $limit, $offset);
    }

References $limit, $offset, $result, and __construct().

Here is the call graph for this function:

nextResult()

MDB2_Result_Common::nextResult

(

)

Move the internal result pointer to the next available result.

Returns

true on success, false if there is no more result set or an error object on failure

@access public

Reimplemented in MDB2_Result_mysqli, MDB2_BufferedResult_mysqli, and MDB2_Result_pgsql.

Definition at line 3652 of file MDB2.php.

    {
        return $this->db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
            'method not implemented', __FUNCTION__);
    }

References MDB2_ERROR_UNSUPPORTED.

numCols()

MDB2_Result_Common::numCols

(

)

Count the number of columns returned by the DBMS in a query result.

Returns

mixed integer value with the number of columns, a MDB2 error on failure

@access public

Reimplemented in MDB2_Result_mysql, MDB2_Result_mysqli, MDB2_Result_oci8, and MDB2_Result_pgsql.

Definition at line 3719 of file MDB2.php.

    {
        return $this->db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
            'method not implemented', __FUNCTION__);
    }

References MDB2_ERROR_UNSUPPORTED.

numRows()

MDB2_Result_Common::numRows

(

)

Returns the number of rows in a result object.

Returns

mixed MDB2 Error Object or the number of rows

@access public

Reimplemented in MDB2_BufferedResult_mysql, MDB2_BufferedResult_mysqli, MDB2_BufferedResult_oci8, and MDB2_BufferedResult_pgsql.

Definition at line 3636 of file MDB2.php.

    {
        return $this->db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
            'method not implemented', __FUNCTION__);
    }

References MDB2_ERROR_UNSUPPORTED.

rowCount()

MDB2_Result_Common::rowCount

(

)

Returns the actual row number that was last fetched (count from 0)

Returns

int

@access public

Definition at line 3621 of file MDB2.php.

    {
        return $this->rownum + 1;
    }

seek()

MDB2_Result_Common::seek

(

$rownum = 0

)

Seek to a specific row in a result set.

Parameters

int	number of the row where the data can be found

Returns

mixed MDB2_OK on success, a MDB2 error on failure

@access public

Reimplemented in MDB2_BufferedResult_mysql, MDB2_BufferedResult_mysqli, MDB2_BufferedResult_oci8, and MDB2_BufferedResult_pgsql.

Definition at line 3432 of file MDB2.php.

    {
        $target_rownum = $rownum - 1;
        if ($this->rownum > $target_rownum) {
            return $this->db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
                'seeking to previous rows not implemented', __FUNCTION__);
        }
        while ($this->rownum < $target_rownum) {
            $this->fetchRow();
        }
        return MDB2_OK;
    }

References $rownum, fetchRow(), MDB2_ERROR_UNSUPPORTED, and MDB2_OK.

Referenced by MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Result_oci8\fetchRow(), and MDB2_Result_pgsql\fetchRow().

Here is the call graph for this function:

Here is the caller graph for this function:

setResultTypes()

MDB2_Result_Common::setResultTypes

(

$types

)

Define the list of types to be associated with the columns of a given result set.

This function may be called before invoking fetchRow(), fetchOne(), fetchCol() and fetchAll() so that the necessary data type conversions are performed on the data to be retrieved by them. If this function is not called, the type of all result set columns is assumed to be text, thus leading to not perform any conversions.

Parameters

array

variable that lists the data types to be expected in the result set columns. If this array contains less types than the number of columns that are returned in the result set, the remaining columns are assumed to be of the type text. Currently, the types clob and blob are not fully supported.

Returns

mixed MDB2_OK on success, a MDB2 error on failure

@access public

Definition at line 3406 of file MDB2.php.

    {
        $load = $this->db->loadModule('Datatype', null, true);
        if (PEAR::isError($load)) {
            return $load;
        }
        $types = $this->db->datatype->checkResultTypes($types);
        if (PEAR::isError($types)) {
            return $types;
        }
        $this->types = $types;
        return MDB2_OK;
    }

References $types, PEAR\isError(), and MDB2_OK.

Here is the call graph for this function:

Field Documentation

$column_names

MDB2_Result_Common::$column_names

Definition at line 3355 of file MDB2.php.

Referenced by MDB2_BufferedResult_oci8\fetchRow().

$db

MDB2_Result_Common::$db

Definition at line 3347 of file MDB2.php.

Referenced by __construct().

$limit

MDB2_Result_Common::$limit

Definition at line 3354 of file MDB2.php.

Referenced by __construct(), and MDB2_Result_Common().

$offset

MDB2_Result_Common::$offset

Definition at line 3352 of file MDB2.php.

Referenced by __construct(), and MDB2_Result_Common().

$offset_count

MDB2_Result_Common::$offset_count = 0

Definition at line 3353 of file MDB2.php.

$result

MDB2_Result_Common::$result

Definition at line 3348 of file MDB2.php.

Referenced by __construct(), and MDB2_Result_Common().

$rownum

MDB2_Result_Common::$rownum = -1

Definition at line 3349 of file MDB2.php.

Referenced by MDB2_BufferedResult_oci8\_fillBuffer(), fetchOne(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Result_oci8\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), seek(), MDB2_BufferedResult_mysql\seek(), MDB2_BufferedResult_mysqli\seek(), MDB2_BufferedResult_oci8\seek(), and MDB2_BufferedResult_pgsql\seek().

$types

MDB2_Result_Common::$types = array()

Definition at line 3350 of file MDB2.php.

Referenced by setResultTypes().

$values

MDB2_Result_Common::$values = array()

Definition at line 3351 of file MDB2.php.

---

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

• Services/PEAR/lib/MDB2.php