ILIAS  release_6 Revision v6.24-5-g0c8bfefb3b8
All Data Structures Namespaces Files Functions Variables Modules Pages
class.ilQueryUtils.php
Go to the documentation of this file.
1 <?php
2 
7 abstract class ilQueryUtils implements ilQueryUtilsInterface
8 {
9 
13  protected $db_instance;
14 
15 
21  public function __construct(ilDBInterface $ilDBInterface)
22  {
23  $this->db_instance = $ilDBInterface;
24  }
25 
26 
34  abstract public function in($field, $values, $negate = false, $type = "");
35 
36 
42  abstract public function quote($value, $type = null);
43 
44 
50  abstract public function concat(array $values, $allow_null = true);
51 
52 
59  abstract public function locate($a_needle, $a_string, $a_start_pos = 1);
60 
61 
66  abstract public function free(ilPDOStatement $statement);
67 
68 
73  abstract public function quoteIdentifier($identifier);
74 
75 
83  abstract public function createTable($name, $fields, $options = array());
84 
85 
94  abstract public function like($column, $type, $value = "?", $case_insensitive = true);
95 
96 
100  abstract public function now();
101 
102 
107  abstract public function lock(array $tables);
108 
109 
113  abstract public function unlock();
114 
115 
122  abstract public function createDatabase($a_name, $a_charset = "utf8", $a_collation = "");
123 
124 
128  abstract public function groupConcat($a_field_name, $a_seperator = ",", $a_order = null);
129 
130 
134  abstract public function cast($a_field_name, $a_dest_type);
135 }
groupConcat($a_field_name, $a_seperator=",", $a_order=null)
string
createTable($name, $fields, $options=array())
__construct(ilDBInterface $ilDBInterface)
ilMySQLQueryUtils constructor.
$type
in($field, $values, $negate=false, $type="")
Class ilPDOStatement is a Wrapper Class for PDOStatement.
quote($value, $type=null)
cast($a_field_name, $a_dest_type)
string
locate($a_needle, $a_string, $a_start_pos=1)
Interface ilDBInterface.
if($format !==null) $name
Definition: metadata.php:230
free(ilPDOStatement $statement)
concat(array $values, $allow_null=true)
lock(array $tables)
like($column, $type, $value="?", $case_insensitive=true)
createDatabase($a_name, $a_charset="utf8", $a_collation="")
quoteIdentifier($identifier)
Interface ilQueryUtilsInterface.
Class ilQueryUtils.