ilQueryUtilsInterface Interface Reference

Interface ilQueryUtilsInterface. More...

Inheritance diagram for ilQueryUtilsInterface:

Collaboration diagram for ilQueryUtilsInterface:

Public Member Functions
	in ($field, $values, $negate=false, $type="")
	quote ($value, $type=null)
	concat (array $values, $allow_null=true)
	locate ($a_needle, $a_string, $a_start_pos=1)
	free (ilPDOStatement $statement)
	quoteIdentifier ($identifier)
	createTable ($name, $fields, $options=array())
	like ($column, $type, $value="?", $case_insensitive=true)
	now ()
	lock (array $tables)
	unlock ()
	createDatabase ($a_name, $a_charset="utf8", $a_collation="")
	groupConcat ($a_field_name, $a_seperator=",", $a_order=null)
	cast ($a_field_name, $a_dest_type)

Detailed Description

Interface ilQueryUtilsInterface.

Author

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

Definition at line 8 of file interface.ilQueryUtils.php.

Member Function Documentation

cast()

ilQueryUtilsInterface::cast	(		$a_field_name,
			$a_dest_type
	)

Parameters

string	$a_field_name
mixed	$a_dest_type

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

concat()

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

Parameters

array	$values
bool	$allow_null

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

createDatabase()

ilQueryUtilsInterface::createDatabase	(		$a_name,
			$a_charset = "utf8",
			$a_collation = ""
	)

Parameters

	$a_name
string	$a_charset
string	$a_collation

Returns

mixed

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

createTable()

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

Parameters

	$name
	$fields
array	$options

Returns

string

Exceptions

ilDatabaseException

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

free()

ilQueryUtilsInterface::free

(

ilPDOStatement

$statement

)

Parameters

\ilPDOStatement

$statement

Returns

bool

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

groupConcat()

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

Parameters

string	$a_field_name
string	$a_seperator
string	$a_order

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

in()

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

Parameters

string	$field
string[]	$values
bool	$negate
string	$type

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

like()

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

Parameters

	$column
	$type
string	$value
bool	$case_insensitive

Returns

string

Exceptions

ilDatabaseException

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

locate()

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

Parameters

	$a_needle
	$a_string
int	$a_start_pos

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

lock()

ilQueryUtilsInterface::lock

(

array

$tables

)

Parameters

array

$tables

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

now()

ilQueryUtilsInterface::now

(

)

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

quote()

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

Parameters

mixed	$value
null	$type

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

quoteIdentifier()

ilQueryUtilsInterface::quoteIdentifier

(

$identifier

)

Parameters

$identifier

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

unlock()

ilQueryUtilsInterface::unlock

(

)

Returns

string

Implemented in ilMySQLQueryUtils, ilPostgresQueryUtils, and ilQueryUtils.

---

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

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