ilQueryUtils Class Reference

Class ilQueryUtils. More...

Inheritance diagram for ilQueryUtils:

Collaboration diagram for ilQueryUtils:

Public Member Functions
	__construct (ilDBInterface $ilDBInterface)
	ilMySQLQueryUtils constructor. More...
	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)
	Parameters string $a_field_name string $a_seperator string $a_order Returns string More...
	cast ($a_field_name, $a_dest_type)
	Parameters string $a_field_name mixed $a_dest_type Returns string More...

Protected Attributes
	$db_instance

Detailed Description

Class ilQueryUtils.

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

Constructor & Destructor Documentation

__construct()

ilQueryUtils::__construct

(

ilDBInterface

$ilDBInterface

)

ilMySQLQueryUtils constructor.

Parameters

\ilDBInterface

$ilDBInterface

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

References $column, $name, $options, $type, array, cast(), concat(), createDatabase(), createTable(), free(), groupConcat(), in(), like(), locate(), lock(), now(), quote(), quoteIdentifier(), and unlock().

    {
        $this->db_instance = $ilDBInterface;
    }

Here is the call graph for this function:

Member Function Documentation

cast()

ilQueryUtils::cast (   $a_field_name,   $a_dest_type  )

abstract

Parameters

string	$a_field_name
mixed	$a_dest_type

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

concat()

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

abstract

Parameters

array	$values
bool	$allow_null

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

createDatabase()

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

abstract

Parameters

	$a_name
string	$a_charset
string	$a_collation

Returns

mixed

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

createTable()

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

abstract

Parameters

	$name
	$fields
array	$options

Returns

string

Exceptions

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

free()

ilQueryUtils::free ( ilPDOStatement  $statement )

abstract

Parameters

\ilPDOStatement

$statement

Returns

bool

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

groupConcat()

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

abstract

Parameters

string	$a_field_name
string	$a_seperator
string	$a_order

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

in()

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

abstract

Parameters

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

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

like()

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

abstract

Parameters

	$column
	$type
string	$value
bool	$case_insensitive

Returns

string

Exceptions

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

locate()

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

abstract

Parameters

	$a_needle
	$a_string
int	$a_start_pos

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

lock()

ilQueryUtils::lock ( array  $tables )

abstract

Parameters

array

$tables

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

now()

ilQueryUtils::now ( )

abstract

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

quote()

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

abstract

Parameters

mixed	$value
null	$type

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

quoteIdentifier()

ilQueryUtils::quoteIdentifier (   $identifier )

abstract

Parameters

$identifier

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

unlock()

ilQueryUtils::unlock ( )

abstract

Returns

string

Implements ilQueryUtilsInterface.

Referenced by __construct().

Here is the caller graph for this function:

Field Documentation

$db_instance

ilQueryUtils::$db_instance

protected

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

---

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

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