ilQueryUtilsInterface Interface 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 ilQueryUtilsInterface:

Collaboration diagram for ilQueryUtilsInterface:

Public Member Functions
	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

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 Interface ilQueryUtilsInterface

Author

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

Definition at line 26 of file interface.ilQueryUtilsInterface.php.

Member Function Documentation

cast()

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

Parameters

mixed

$a_dest_type

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

concat()

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

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

createDatabase()

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

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

createTable()

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

Exceptions

ilDatabaseException

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

free()

ilQueryUtilsInterface::free

(

ilPDOStatement

$statement

)

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

groupConcat()

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

Implemented in ilQueryUtils, and ilMySQLQueryUtils.

in()

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

Parameters

string[]

$values

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

like()

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

Exceptions

ilDatabaseException

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

locate()

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

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

lock()

ilQueryUtilsInterface::lock

(

array

$tables

)

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

now()

ilQueryUtilsInterface::now

(

)

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

quote()

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

Parameters

mixed

$value

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

quoteIdentifier()

ilQueryUtilsInterface::quoteIdentifier

(

string

$identifier

)

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

unlock()

ilQueryUtilsInterface::unlock

(

)

Implemented in ilMySQLQueryUtils, and ilQueryUtils.

---

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

• Services/Database/interfaces/interface.ilQueryUtilsInterface.php