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)

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.

References $result.

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

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

private

Definition at line 3806 of file MDB2.php.

References $column, $row, and MDB2_OK.

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

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

private

Definition at line 3722 of file MDB2.php.

References MDB2_ERROR_UNSUPPORTED.

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

◆ 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

public

Definition at line 3774 of file MDB2.php.

References $column, MDB2_OK, and MDB2_PORTABILITY_FIX_CASE.

     {
         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;
     }

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

References $res, and MDB2\isError().

                                                 {
                 $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;
         }

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);
     }

◆ 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

public

See also: getAssoc()

Definition at line 3570 of file MDB2.php.

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

     {
         $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;
     }

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.

References ilDBConstants\FETCHMODE_ASSOC.

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

◆ 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

public

Definition at line 3524 of file MDB2.php.

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

     {
         $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;
     }

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.

References ilDBConstants\FETCHMODE_OBJECT.

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

◆ 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

public

Definition at line 3498 of file MDB2.php.

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

     {
         $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];
     }

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

public

Definition at line 3478 of file MDB2.php.

References MDB2_ERROR_UNSUPPORTED.

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

◆ free()

MDB2_Result_Common::free ( )

Free the internal resources associated with result.

Returns: bool true on success, false if result is invalid

public

Definition at line 3827 of file MDB2.php.

References MDB2_OK.

     {
         $this->result = false;
         return 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.

public

Definition at line 3694 of file MDB2.php.

References $result, and PEAR\isError().

     {
         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;
     }

Here is the call graph for this function:

◆ getResource()

MDB2_Result_Common::getResource ( )

return the resource associated with the result object

Returns: resource

public

Definition at line 3755 of file MDB2.php.

References $result.

     {
         return $this->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);
     }

◆ 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

public

Definition at line 3672 of file MDB2.php.

References MDB2_ERROR_UNSUPPORTED.

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

◆ 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

public

Definition at line 3739 of file MDB2.php.

References MDB2_ERROR_UNSUPPORTED.

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

◆ numRows()

MDB2_Result_Common::numRows ( )

Returns the number of rows in a result object.

Returns: mixed MDB2 Error Object or the number of rows

public

Implements ilDBStatement.

Definition at line 3656 of file MDB2.php.

References MDB2_ERROR_UNSUPPORTED.

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

◆ rowCount()

MDB2_Result_Common::rowCount ( )

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

Returns: int

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

public

Definition at line 3452 of file MDB2.php.

References MDB2_ERROR_UNSUPPORTED, and MDB2_OK.

     {
         $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;
     }

◆ 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

public

Definition at line 3426 of file MDB2.php.

References PEAR\isError(), and MDB2_OK.

     {
         $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;
     }

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.

◆ $db

MDB2_Result_Common::$db

Definition at line 3352 of file MDB2.php.

◆ $limit

MDB2_Result_Common::$limit

Definition at line 3359 of file MDB2.php.

◆ $offset

MDB2_Result_Common::$offset

Definition at line 3357 of file MDB2.php.

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

◆ $rownum

MDB2_Result_Common::$rownum = -1

Definition at line 3354 of file MDB2.php.

◆ $types

MDB2_Result_Common::$types = array()

Definition at line 3355 of file MDB2.php.

◆ $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