ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
Public Member Functions | Protected Attributes
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...
 
 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)
 

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.

23 {
24 $this->db_instance = $ilDBInterface;
25 }

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.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ concat()

ilQueryUtils::concat ( array  $values,
  $allow_null = true 
)
abstract
Parameters
array$values
bool$allow_null
Returns
string

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ createDatabase()

ilQueryUtils::createDatabase (   $a_name,
  $a_charset = "utf8",
  $a_collation = "" 
)
abstract
Parameters
$a_name
string$a_charset
string$a_collation
Returns
mixed

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ createTable()

ilQueryUtils::createTable (   $name,
  $fields,
  $options = array() 
)
abstract
Parameters
$name
$fields
array$options
Returns
string
Exceptions

ilDatabaseException

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ free()

ilQueryUtils::free ( ilPDOStatement  $statement)
abstract
Parameters
\ilPDOStatement$statement
Returns
bool

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ 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.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ in()

ilQueryUtils::in (   $field,
  $values,
  $negate = false,
  $type = "" 
)
abstract
Parameters
string$field
string[]$values
bool$negate
string$type
Returns
string

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ like()

ilQueryUtils::like (   $column,
  $type,
  $value = "?",
  $case_insensitive = true 
)
abstract
Parameters
$column
$type
string$value
bool$case_insensitive
Returns
string
Exceptions

ilDatabaseException

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ 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.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ lock()

ilQueryUtils::lock ( array  $tables)
abstract
Parameters
array$tables
Returns
string

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ now()

ilQueryUtils::now ( )
abstract
Returns
string

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ quote()

ilQueryUtils::quote (   $value,
  $type = null 
)
abstract
Parameters
mixed$value
null$type
Returns
string

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ quoteIdentifier()

ilQueryUtils::quoteIdentifier (   $identifier)
abstract
Parameters
$identifier
Returns
string

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

◆ unlock()

ilQueryUtils::unlock ( )
abstract
Returns
string

Implements ilQueryUtilsInterface.

Reimplemented in ilMySQLQueryUtils, and ilPostgresQueryUtils.

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: