Class ilQueryUtils. More...

Inheritance diagram for ilQueryUtils:

Collaboration diagram for ilQueryUtils:

Public Member Functions

__construct (protected \ilDBInterface $db_instance)

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)

Detailed Description

Class ilQueryUtils.

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

Constructor & Destructor Documentation

◆ __construct()

ilQueryUtils::__construct ( protected \ilDBInterface $db_instance )

ilMySQLQueryUtils constructor.

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

30 {

31 }

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.

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

components/ILIAS/Database/classes/QueryUtils/class.ilQueryUtils.php