Rankning::ner()   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 Rankning implements ContainerInjectableInterface
9
{
10
    use ContainerInjectableTrait;
11
12
    public function __construct($di)
13
    {
14
        $this->di = $di;
15
    }
16
17
    public function upp($id)
18
    {
19
        $db = $this->di->get("db");
20
        $db->connect();
21
        $sql = "UPDATE inlagg SET rankning = rankning + 1 WHERE id=?;";
22
        $db->execute($sql, [$id]);
23
24
        return;
25
    }
26
27
    public function ner($id)
28
    {
29
        $db = $this->di->get("db");
30
        $db->connect();
31
        $sql = "UPDATE inlagg SET rankning = rankning - 1 WHERE id=?;";
32
        $db->execute($sql, [$id]);
33
34
        return;
35
    }
36
37
    public function acceptera($id)
38
    {
39
        $db = $this->di->get("db");
40
        $db->connect();
41
        $sql = "UPDATE inlagg SET godkant = true WHERE id=?;";
42
        $db->execute($sql, [$id]);
43
44
        return;
45
    }
46
47
    public function uppdatera($id, $kategori, $varde)
48
    {
49
        $db = $this->di->get("db");
50
        $db->connect();
51
        $sql = "UPDATE anvandare2 SET " .$kategori. " = " .$kategori. " + " . $varde . " WHERE anvandarid = ?;";
52
        $db->execute($sql, [$id]);
53
        return;
54
    }
55
56
    public function vemsInlagg($id)
57
    {
58
        $db = $this->di->get("db");
59
        $db->connect();
60
        $sql = "SELECT * FROM inlagg WHERE id=?;";
61
        $res = $db->executeFetch($sql, [$id]);
62
        return $res;
63
    }
64
}
65