ILIAS  release_6 Revision v6.24-5-g0c8bfefb3b8
class.ilQueryUtils.php
Go to the documentation of this file.
1<?php
2
7abstract 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}
An exception for terminatinating execution or to throw for unit testing.
Class ilPDOStatement is a Wrapper Class for PDOStatement.
Class ilQueryUtils.
free(ilPDOStatement $statement)
groupConcat($a_field_name, $a_seperator=",", $a_order=null)
string
concat(array $values, $allow_null=true)
__construct(ilDBInterface $ilDBInterface)
ilMySQLQueryUtils constructor.
locate($a_needle, $a_string, $a_start_pos=1)
quoteIdentifier($identifier)
lock(array $tables)
in($field, $values, $negate=false, $type="")
cast($a_field_name, $a_dest_type)
string
quote($value, $type=null)
like($column, $type, $value="?", $case_insensitive=true)
createDatabase($a_name, $a_charset="utf8", $a_collation="")
createTable($name, $fields, $options=array())
Interface ilDBInterface.
Interface ilQueryUtilsInterface.
if($format !==null) $name
Definition: metadata.php:230
$type