AnswersModel::getAnswersByOneQuestionId() - Code Metrics - mklkj/egzaminer - Measure and Improve Code Quality continuously with Scrutinizer

AnswersModel::getAnswersByOneQuestionId() A
last analyzed 2019-07-12 14:10 UTC

↳ Parent: AnswersModel

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	8
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	1

<?php

namespace Egzaminer\Model;

use PDO;

class AnswersModel extends AbstractModel
{
    public function getAnswersByQuestionsById(array $questions): array
    {
        if (empty($questions)) {
            return [];
        }

        $where = '';
        foreach ($questions as $key => $value) {
            $where .= ' OR question_id = :question_id_'.md5($value['id']);
        }

        $stmt = $this->db->prepare('SELECT * FROM answers WHERE '.trim($where, ' OR '));
        foreach ($questions as $key => $value) {
            $stmt->bindValue(':question_id_'.md5($value['id']), $value['id'], PDO::PARAM_INT);
        }

        $stmt->execute();

        $array = [];
        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $key => $value) {
            $array[$value['question_id']][] = $value;
        }

        return $array;
    }

    public function getAnswersByOneQuestionId(int $questionID): array
    {
        $stmt = $this->db->prepare('SELECT * FROM answers WHERE question_id = :qid');
        $stmt->bindValue(':qid', $questionID, PDO::PARAM_INT);
        $stmt->execute();

        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
}


1			<?php
2
3			namespace Egzaminer\Model;
4
5			use PDO;
6
7			class AnswersModel extends AbstractModel
8			{
9			public function getAnswersByQuestionsById(array $questions): array
10			{
11			if (empty($questions)) {
12			return [];
13			}
14
15			$where = '';
16			foreach ($questions as $key => $value) {
17			$where .= ' OR question_id = :question_id_'.md5($value['id']);
18			}
19
20			$stmt = $this->db->prepare('SELECT * FROM answers WHERE '.trim($where, ' OR '));
21			foreach ($questions as $key => $value) {
22			$stmt->bindValue(':question_id_'.md5($value['id']), $value['id'], PDO::PARAM_INT);
23			}
24
25			$stmt->execute();
26
27			$array = [];
28			foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $key => $value) {
29			$array[$value['question_id']][] = $value;
30			}
31
32			return $array;
33			}
34
35			public function getAnswersByOneQuestionId(int $questionID): array
36			{
37			$stmt = $this->db->prepare('SELECT * FROM answers WHERE question_id = :qid');
38			$stmt->bindValue(':qid', $questionID, PDO::PARAM_INT);
39			$stmt->execute();
40
41			return $stmt->fetchAll(PDO::FETCH_ASSOC);
42			}
43			}
44

mklkj / egzaminer

AnswersModel::getAnswersByOneQuestionId() A last analyzed 2019-07-12 14:10 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

AnswersModel::getAnswersByOneQuestionId() A
last analyzed 2019-07-12 14:10 UTC