ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
ilQueryUtils Class Reference

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: