Inheritance diagram for MDB2_Result_Common:

Collaboration diagram for MDB2_Result_Common:

Public Member Functions
	__construct ($db, $result, $limit=0, $offset=0)
	Constructor. More...

	fetch ($fetch_mode=ilDBConstants::FETCHMODE_ASSOC)

	fetchObject ()

	fetchAssoc ()

	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...

	execute ($a_data=null)

Public Member Functions inherited from ilDBStatement
	fetchRow ($fetch_mode)

	fetch ($fetch_mode=ilDBConstants::FETCHMODE_ASSOC)

	rowCount ()

	numRows ()

	fetchObject ()

	fetchAssoc ()

	execute ($a_data=null)

Data Fields
	$db

	$result

	$rownum = -1

	$types = array()

	$values = array()

	$offset

	$offset_count = 0

	$limit

	$column_names

Detailed Description

Definition at line 3348 of file MDB2.php.

Constructor & Destructor Documentation

◆ __construct()

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

Constructor.

Definition at line 3368 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 3806 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 $column, $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 3722 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 3774 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 $column, MDB2_OK, and MDB2_PORTABILITY_FIX_CASE.

◆ execute()

MDB2_Result_Common::execute ( $a_data = null )

Parameters

array $a_data

Returns: mixed

Exceptions

ilDatabaseException

Implements ilDBStatement.

Definition at line 3839 of file MDB2.php.

                                                {
                $res = $this->result->execute($a_data);
                if (MDB2::isError($res)) {
                        throw new ilDatabaseException("There was an MDB2 error executing the prepared query: ".$this->result->getMessage());
                }
                return $res;
        }

References $res, and MDB2\isError().

Here is the call graph for this function:

◆ fetch()

MDB2_Result_Common::fetch ( $fetch_mode = ilDBConstants::FETCHMODE_ASSOC )

Parameters

int $fetch_mode

Returns: mixed

Implements ilDBStatement.

Definition at line 3377 of file MDB2.php.

                                                                      {
        return $this->fetchRow($fetch_mode);
    }

References fetchRow().

Here is the call graph for this function:

◆ 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 3570 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:

◆ fetchAssoc()

MDB2_Result_Common::fetchAssoc ( )

Returns: array

Implements ilDBStatement.

Definition at line 3387 of file MDB2.php.

                                 {
        return $this->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
    }

References ilDBConstants\FETCHMODE_ASSOC, and fetchRow().

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 3524 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 $column, $row, fetchRow(), PEAR\isError(), MDB2_ERROR_TRUNCATED, MDB2_FETCHMODE_ASSOC, and MDB2_FETCHMODE_ORDERED.

Here is the call graph for this function:

◆ fetchObject()

MDB2_Result_Common::fetchObject ( )

Returns: stdClass

Implements ilDBStatement.

Definition at line 3382 of file MDB2.php.

                                  {
        return $this->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
    }

References ilDBConstants\FETCHMODE_OBJECT, and fetchRow().

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 3498 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 3478 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 fetch(), fetchAll(), fetchAssoc(), fetchCol(), fetchObject(), 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 3827 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 3694 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 3755 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 3397 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 3672 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 3739 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

Implements ilDBStatement.

Reimplemented in MDB2_BufferedResult_mysql, MDB2_BufferedResult_mysqli, MDB2_BufferedResult_oci8, and MDB2_BufferedResult_pgsql.

Definition at line 3656 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

Implements ilDBStatement.

Definition at line 3641 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 3452 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 3426 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 3360 of file MDB2.php.

Referenced by MDB2_BufferedResult_oci8\fetchRow().

◆ $db

MDB2_Result_Common::$db

Definition at line 3352 of file MDB2.php.

Referenced by __construct().

◆ $limit

MDB2_Result_Common::$limit

Definition at line 3359 of file MDB2.php.

Referenced by __construct(), and MDB2_Result_Common().

◆ $offset

MDB2_Result_Common::$offset

Definition at line 3357 of file MDB2.php.

Referenced by __construct(), and MDB2_Result_Common().

◆ $offset_count

MDB2_Result_Common::$offset_count = 0

Definition at line 3358 of file MDB2.php.

◆ $result

MDB2_Result_Common::$result

Definition at line 3353 of file MDB2.php.

Referenced by __construct(), and MDB2_Result_Common().

◆ $rownum

MDB2_Result_Common::$rownum = -1

Definition at line 3354 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 3355 of file MDB2.php.

Referenced by setResultTypes().

◆ $values

MDB2_Result_Common::$values = array()

Definition at line 3356 of file MDB2.php.

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

Services/Database/lib/PEAR/MDB2.php

Public Member Functions

Data Fields

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _assignBindColumns()

◆ _getColumnNames()

◆ bindColumn()

◆ execute()

◆ fetch()

◆ fetchAll()

◆ fetchAssoc()

◆ fetchCol()

◆ fetchObject()

◆ fetchOne()

◆ fetchRow()

◆ free()

◆ getColumnNames()

◆ getResource()

◆ MDB2_Result_Common()

◆ nextResult()

◆ numCols()

◆ numRows()

◆ rowCount()

◆ seek()

◆ setResultTypes()

Field Documentation

◆ $column_names

◆ $db

◆ $limit

◆ $offset

◆ $offset_count

◆ $result

◆ $rownum

◆ $types

◆ $values