ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
class.ilQueryUtils.php
Go to the documentation of this file.
1<?php
2
19declare(strict_types=1);
20
24abstract class ilQueryUtils implements ilQueryUtilsInterface
25{
29 public function __construct(protected \ilDBInterface $db_instance)
30 {
31 }
32
36 abstract public function in(string $field, array $values, bool $negate = false, string $type = ""): string;
37
41 abstract public function quote($value, ?string $type = null): string;
42
43 abstract public function concat(array $values, bool $allow_null = true): string;
44
45 abstract public function locate(string $a_needle, string $a_string, int $a_start_pos = 1): string;
46
47 abstract public function free(ilPDOStatement $statement): bool;
48
49 abstract public function quoteIdentifier(string $identifier): string;
50
54 abstract public function createTable(string $name, array $fields, array $options = []): string;
55
59 abstract public function like(
60 string $column,
61 string $type,
62 string $value = "?",
63 bool $case_insensitive = true
64 ): string;
65
66 abstract public function now(): string;
67
68 abstract public function lock(array $tables): string;
69
70 abstract public function unlock(): string;
71
72 abstract public function createDatabase(string $name, string $charset = "utf8", string $collation = ""): string;
73
74 abstract public function groupConcat(string $a_field_name, string $a_seperator = ",", ?string $a_order = null): string;
75
79 abstract public function cast(string $a_field_name, $a_dest_type): string;
80}
Class ilPDOStatement is a Wrapper Class for PDOStatement.
Class ilQueryUtils.
free(ilPDOStatement $statement)
createDatabase(string $name, string $charset="utf8", string $collation="")
lock(array $tables)
__construct(protected \ilDBInterface $db_instance)
ilMySQLQueryUtils constructor.
like(string $column, string $type, string $value="?", bool $case_insensitive=true)
concat(array $values, bool $allow_null=true)
quoteIdentifier(string $identifier)
locate(string $a_needle, string $a_string, int $a_start_pos=1)
groupConcat(string $a_field_name, string $a_seperator=",", ?string $a_order=null)
createTable(string $name, array $fields, array $options=[])
in(string $field, array $values, bool $negate=false, string $type="")
cast(string $a_field_name, $a_dest_type)
quote($value, ?string $type=null)
Interface ilDBInterface.
Interface ilQueryUtilsInterface.