Anvandare::enAnvandare()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 8
Code Lines 5

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
eloc 5
nc 1
nop 1
dl 0
loc 8
c 0
b 0
f 0
cc 1
rs 10
1
<?php
2
3
namespace KW\Inlagg;
4
5
use Anax\Commons\ContainerInjectableInterface;
6
use Anax\Commons\ContainerInjectableTrait;
7
8
class Anvandare implements ContainerInjectableInterface
9
{
10
    use ContainerInjectableTrait;
11
12
13
    public function __construct($di)
14
    {
15
        $this->di = $di;
16
    }
17
18
    public function allaAnvandare()
19
    {
20
        $db = $this->di->get("db");
21
        $db->connect();
22
        $sql = "SELECT * FROM anvandare2;";
23
        $res = $db->executeFetchAll($sql);
24
25
        return $res;
26
    }
27
28
    public function enAnvandare($id)
29
    {
30
        $db = $this->di->get("db");
31
        $db->connect();
32
        $sql = "SELECT * FROM anvandare2 WHERE anvandarid=?;";
33
        $res = $db->executeFetch($sql, [$id]);
34
35
        return $res;
36
    }
37
38
39
    public function anvandarensFragor($userid)
40
    {
41
        $db = $this->di->get("db");
42
        $db->connect();
43
        $sql = "SELECT * FROM inlagg WHERE userid=? AND type='fraga';";
44
        $res = $db->executeFetchAll($sql, [$userid]);
45
        return $res;
46
    }
47
48
    public function anvandarensSvar($userid)
49
    {
50
        $db = $this->di->get("db");
51
        $db->connect();
52
        $sql = "SELECT * FROM inlagg WHERE userid=? AND type='svar';";
53
        $res = $db->executeFetchAll($sql, [$userid]);
54
        return $res;
55
    }
56
}
57