ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
interface.ilQueryUtilsInterface.php
Go to the documentation of this file.
1<?php
2
19declare(strict_types=1);
20
27{
31 public function in(string $field, array $values, bool $negate = false, string $type = ""): string;
32
33
37 public function quote($value, ?string $type = null): string;
38
39
40 public function concat(array $values, bool $allow_null = true): string;
41
42
43 public function locate(string $a_needle, string $a_string, int $a_start_pos = 1): string;
44
45
46 public function free(ilPDOStatement $statement): bool;
47
48
49 public function quoteIdentifier(string $identifier): string;
50
51
55 public function createTable(string $name, array $fields, array $options = []): string;
56
57
61 public function like(string $column, string $type, string $value = "?", bool $case_insensitive = true): string;
62
63
64 public function now(): string;
65
66
67 public function lock(array $tables): string;
68
69
70 public function unlock(): string;
71
72
73 public function createDatabase(string $name, string $charset = "utf8", string $collation = ""): string;
74
75
76 public function groupConcat(string $a_field_name, string $a_seperator = ",", ?string $a_order = null): string;
77
78
82 public function cast(string $a_field_name, $a_dest_type): string;
83}
Class ilPDOStatement is a Wrapper Class for PDOStatement.
Interface ilQueryUtilsInterface.
locate(string $a_needle, string $a_string, int $a_start_pos=1)
concat(array $values, bool $allow_null=true)
like(string $column, string $type, string $value="?", bool $case_insensitive=true)
createTable(string $name, array $fields, array $options=[])
in(string $field, array $values, bool $negate=false, string $type="")
quoteIdentifier(string $identifier)
cast(string $a_field_name, $a_dest_type)
lock(array $tables)
free(ilPDOStatement $statement)
quote($value, ?string $type=null)
groupConcat(string $a_field_name, string $a_seperator=",", ?string $a_order=null)
createDatabase(string $name, string $charset="utf8", string $collation="")