ilPDOStatement Class Reference

Class ilPDOStatement is a Wrapper Class for PDOStatement. More...

Inheritance diagram for ilPDOStatement:

Collaboration diagram for ilPDOStatement:

Public Member Functions
	__construct (PDOStatement $pdo_statement)
	fetchRow ($fetch_mode=ilDBConstants::FETCHMODE_ASSOC)
	fetch ($fetch_mode=ilDBConstants::FETCHMODE_ASSOC)
	closeCursor ()
	Pdo allows for a manual closing of the cursor. More...
	rowCount ()
	fetchObject ()
	fetchAssoc ()
	numRows ()
	execute ($a_data=null)
	Parameters array $a_data Returns \ilPDOStatement|\MDB2_Result_Common More...
	errorCode ()
	errorInfo ()
	fetchRow ($fetch_mode)
	fetch ($fetch_mode=ilDBConstants::FETCHMODE_ASSOC)
	rowCount ()
	numRows ()
	fetchObject ()
	fetchAssoc ()
	execute ($a_data=null)

Protected Attributes
	$pdo_statement

Detailed Description

Class ilPDOStatement is a Wrapper Class for PDOStatement.

Author

Oskar Truffer ot@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 11 of file class.ilPDOStatement.php.

Constructor & Destructor Documentation

__construct()

ilPDOStatement::__construct

(

PDOStatement

$pdo_statement

)

Parameters

$pdo_statement

PDOStatement The PDO Statement to be wrapped.

Definition at line 22 of file class.ilPDOStatement.php.

                                                                 {
                $this->pdo_statement = $pdo_statement;
        }

References $pdo_statement.

Member Function Documentation

closeCursor()

ilPDOStatement::closeCursor

(

)

Pdo allows for a manual closing of the cursor.

Definition at line 55 of file class.ilPDOStatement.php.

                                      {
                $this->pdo_statement->closeCursor();
        }

Referenced by ilMySQLQueryUtils\free(), and ilPostgresQueryUtils\free().

Here is the caller graph for this function:

errorCode()

ilPDOStatement::errorCode

(

)

Returns

string

Definition at line 104 of file class.ilPDOStatement.php.

                                    {
                return $this->pdo_statement->errorCode();
        }

errorInfo()

ilPDOStatement::errorInfo

(

)

Returns

array

Definition at line 111 of file class.ilPDOStatement.php.

                                    {
                return $this->pdo_statement->errorInfo();
        }

execute()

ilPDOStatement::execute

(

$a_data = null

)

Parameters

array

$a_data

Returns

\ilPDOStatement|\MDB2_Result_Common

Implements ilDBStatement.

Definition at line 95 of file class.ilPDOStatement.php.

                                                {
                $this->pdo_statement->execute($a_data);
 
                return $this;
        }

fetch()

ilPDOStatement::fetch

(

$fetch_mode = ilDBConstants::FETCHMODE_ASSOC

)

Parameters

int

$fetch_mode

Returns

mixed|void

Implements ilDBStatement.

Definition at line 47 of file class.ilPDOStatement.php.

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

References fetchRow().

Referenced by fetchAssoc(), and fetchObject().

Here is the call graph for this function:

Here is the caller graph for this function:

fetchAssoc()

ilPDOStatement::fetchAssoc

(

)

Returns

array

Implements ilDBStatement.

Definition at line 79 of file class.ilPDOStatement.php.

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

References fetch(), and ilDBConstants\FETCHMODE_ASSOC.

Here is the call graph for this function:

fetchObject()

ilPDOStatement::fetchObject

(

)

Returns

stdClass

Implements ilDBStatement.

Definition at line 71 of file class.ilPDOStatement.php.

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

References fetch(), and ilDBConstants\FETCHMODE_OBJECT.

Here is the call graph for this function:

fetchRow()

ilPDOStatement::fetchRow

(

$fetch_mode = ilDBConstants::FETCHMODE_ASSOC

)

Parameters

int

$fetch_mode

Returns

mixed

Exceptions

ilDatabaseException

Implements ilDBStatement.

Definition at line 32 of file class.ilPDOStatement.php.

                                                                             {
                if ($fetch_mode == ilDBConstants::FETCHMODE_ASSOC) {
                        return $this->pdo_statement->fetch(PDO::FETCH_ASSOC);
                } elseif ($fetch_mode == ilDBConstants::FETCHMODE_OBJECT) {
                        return $this->pdo_statement->fetch(PDO::FETCH_OBJ);
                } else {
                        throw new ilDatabaseException("No valid fetch mode given, choose ilDBConstants::FETCHMODE_ASSOC or ilDBConstants::FETCHMODE_OBJECT");
                }
        }

References ilDBConstants\FETCHMODE_ASSOC, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by fetch().

Here is the caller graph for this function:

numRows()

ilPDOStatement::numRows

(

)

Returns

int

Implements ilDBStatement.

Definition at line 87 of file class.ilPDOStatement.php.

                                  {
                return $this->pdo_statement->rowCount();
        }

rowCount()

ilPDOStatement::rowCount

(

)

Returns

int

Implements ilDBStatement.

Definition at line 63 of file class.ilPDOStatement.php.

                                   {
                return $this->pdo_statement->rowCount();
        }

Field Documentation

$pdo_statement

ilPDOStatement::$pdo_statement

protected

Definition at line 16 of file class.ilPDOStatement.php.

Referenced by __construct().

---

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

• Services/Database/classes/PDO/class.ilPDOStatement.php