ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
class.ilQueryUtils.php
Go to the documentation of this file.
1 <?php
2 require_once 'Services/Database/interfaces/interface.ilQueryUtils.php';
3 
8 abstract class ilQueryUtils implements ilQueryUtilsInterface
9 {
10 
14  protected $db_instance;
15 
16 
22  public function __construct(ilDBInterface $ilDBInterface)
23  {
24  $this->db_instance = $ilDBInterface;
25  }
26 
27 
35  abstract public function in($field, $values, $negate = false, $type = "");
36 
37 
43  abstract public function quote($value, $type = null);
44 
45 
51  abstract public function concat(array $values, $allow_null = true);
52 
53 
60  abstract public function locate($a_needle, $a_string, $a_start_pos = 1);
61 
62 
67  abstract public function free(ilPDOStatement $statement);
68 
69 
74  abstract public function quoteIdentifier($identifier);
75 
76 
84  abstract public function createTable($name, $fields, $options = array());
85 
86 
95  abstract public function like($column, $type, $value = "?", $case_insensitive = true);
96 
97 
101  abstract public function now();
102 
103 
108  abstract public function lock(array $tables);
109 
110 
114  abstract public function unlock();
115 
116 
123  abstract public function createDatabase($a_name, $a_charset = "utf8", $a_collation = "");
124 
125 
129  abstract public function groupConcat($a_field_name, $a_seperator = ",", $a_order = null);
130 
131 
135  abstract public function cast($a_field_name, $a_dest_type);
136 }
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:146
$column
Definition: 39dropdown.php:62
free(ilPDOStatement $statement)
concat(array $values, $allow_null=true)
Create styles array
The data for the language used.
lock(array $tables)
like($column, $type, $value="?", $case_insensitive=true)
createDatabase($a_name, $a_charset="utf8", $a_collation="")
quoteIdentifier($identifier)
Interface ilQueryUtilsInterface.
Class ilQueryUtils.
if(!isset($_REQUEST['ReturnTo'])) if(!isset($_REQUEST['AuthId'])) $options
Definition: as_login.php:20