KW\Inlagg\Anvandare

Complexity

Total Complexity

5

Size/Duplication

Total Lines	47
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	allaAnvandare()	0	8	1
A	anvandarensSvar()	0	7	1
A	anvandarensFragor()	0	7	1
A	enAnvandare()	0	8	1

<?php

namespace KW\Inlagg;

use Anax\Commons\ContainerInjectableInterface;
use Anax\Commons\ContainerInjectableTrait;

class Anvandare implements ContainerInjectableInterface
{
    use ContainerInjectableTrait;


    public function __construct($di)
    {
        $this->di = $di;
    }

    public function allaAnvandare()
    {
        $db = $this->di->get("db");
        $db->connect();
        $sql = "SELECT * FROM anvandare2;";
        $res = $db->executeFetchAll($sql);

        return $res;
    }

    public function enAnvandare($id)
    {
        $db = $this->di->get("db");
        $db->connect();
        $sql = "SELECT * FROM anvandare2 WHERE anvandarid=?;";
        $res = $db->executeFetch($sql, [$id]);

        return $res;
    }


    public function anvandarensFragor($userid)
    {
        $db = $this->di->get("db");
        $db->connect();
        $sql = "SELECT * FROM inlagg WHERE userid=? AND type='fraga';";
        $res = $db->executeFetchAll($sql, [$userid]);
        return $res;
    }

    public function anvandarensSvar($userid)
    {
        $db = $this->di->get("db");
        $db->connect();
        $sql = "SELECT * FROM inlagg WHERE userid=? AND type='svar';";
        $res = $db->executeFetchAll($sql, [$userid]);
        return $res;
    }
}