ilQueryUtils Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilQueryUtils:

Collaboration diagram for ilQueryUtils:

Public Member Functions
	__construct (ilDBInterface $ilDBInterface)
	ilMySQLQueryUtils constructor. More...
	in (string $field, array $values, bool $negate=false, string $type="")
	quote ($value, ?string $type=null)
	concat (array $values, bool $allow_null=true)
	locate (string $a_needle, string $a_string, int $a_start_pos=1)
	free (ilPDOStatement $statement)
	quoteIdentifier (string $identifier)
	createTable (string $name, array $fields, array $options=[])
	like (string $column, string $type, string $value="?", bool $case_insensitive=true)
	now ()
	lock (array $tables)
	unlock ()
	createDatabase (string $name, string $charset="utf8", string $collation="")
	groupConcat (string $a_field_name, string $a_seperator=",", string $a_order=null)
	cast (string $a_field_name, $a_dest_type)
	Parameters mixed $a_dest_type More...
	in (string $field, array $values, bool $negate=false, string $type="")
	quote ($value, ?string $type=null)
	concat (array $values, bool $allow_null=true)
	locate (string $a_needle, string $a_string, int $a_start_pos=1)
	free (ilPDOStatement $statement)
	quoteIdentifier (string $identifier)
	createTable (string $name, array $fields, array $options=[])
	like (string $column, string $type, string $value="?", bool $case_insensitive=true)
	now ()
	lock (array $tables)
	unlock ()
	createDatabase (string $name, string $charset="utf8", string $collation="")
	groupConcat (string $a_field_name, string $a_seperator=",", string $a_order=null)
	cast (string $a_field_name, $a_dest_type)

Protected Attributes
ilDBInterface	$db_instance

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilQueryUtils

Definition at line 24 of file class.ilQueryUtils.php.

Constructor & Destructor Documentation

__construct()

ilQueryUtils::__construct

(

ilDBInterface

$ilDBInterface

)

ilMySQLQueryUtils constructor.

Definition at line 31 of file class.ilQueryUtils.php.

    {
        $this->db_instance = $ilDBInterface;
    }

Member Function Documentation

cast()

ilQueryUtils::cast ( string  $a_field_name,   $a_dest_type  )

abstract

Parameters

mixed

$a_dest_type

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

concat()

ilQueryUtils::concat ( array  $values, bool  $allow_null = true  )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

createDatabase()

ilQueryUtils::createDatabase ( string  $name, string  $charset = "utf8", string  $collation = ""  )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

createTable()

ilQueryUtils::createTable ( string  $name, array  $fields, array  $options = []  )

abstract

Exceptions

ilDatabaseException

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

free()

ilQueryUtils::free ( ilPDOStatement  $statement )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

groupConcat()

ilQueryUtils::groupConcat ( string  $a_field_name, string  $a_seperator = ",", string  $a_order = null  )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

in()

ilQueryUtils::in ( string  $field, array  $values, bool  $negate = false, string  $type = ""  )

abstract

Parameters

string[]

$values

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

like()

ilQueryUtils::like ( string  $column, string  $type, string  $value = "?", bool  $case_insensitive = true  )

abstract

Exceptions

ilDatabaseException

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

locate()

ilQueryUtils::locate ( string  $a_needle, string  $a_string, int  $a_start_pos = 1  )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

lock()

ilQueryUtils::lock ( array  $tables )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

now()

ilQueryUtils::now ( )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

quote()

ilQueryUtils::quote (   $value, ?string  $type = null  )

abstract

Parameters

mixed

$value

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

quoteIdentifier()

ilQueryUtils::quoteIdentifier ( string  $identifier )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

unlock()

ilQueryUtils::unlock ( )

abstract

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils.

Field Documentation

$db_instance

ilDBInterface ilQueryUtils::$db_instance

protected

Definition at line 26 of file class.ilQueryUtils.php.

---

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

• Services/Database/classes/QueryUtils/class.ilQueryUtils.php