LinkCategoryDAO::getCategory() - Code Metrics - atari-legend/legacy - Measure and Improve Code Quality continuously with Scrutinizer

LinkCategoryDAO::getCategory() A
last analyzed 2024-03-07 17:20 UTC

↳ Parent: LinkCategoryDAO

Complexity

Conditions	2
Paths	2

Size

Total Lines	28
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	20
nc	2
nop	1
dl	0
loc	28
rs	9.6
c	0
b	0
f	0

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/Link/LinkCategory.php" ;

/**
 * DAO for Link Categories
 */
class LinkCategoryDAO {
    private $mysqli;

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

    /**
     * Retrieve all categories, with the count of links for each
     *
     * @return AL\Common\Model\Link\LinkCategory[] An array of all categories
     */
    public function getAllCategories() {
        $stmt = \AL\Db\execute_query(
            "LinkCategoryDAO: Get all categories",
            $this->mysqli,
            "SELECT
                website_category.website_category_id,
                website_category_name,
                COUNT(website_category_cross_id)
            FROM
                website_category
            LEFT JOIN website_category_cross
                ON website_category.website_category_id = website_category_cross.website_category_id
            GROUP BY
                website_category.website_category_id
            ORDER BY
                website_category_name ASC",
            null, null
        );

        \AL\Db\bind_result(
            "LinkCategoryDAO: Get all categories",
            $stmt,
            $id, $name, $count

        );

        $categories = [];
        while ($stmt->fetch()) {
            $categories[] = new \AL\Common\Model\Link\LinkCategory($id, $name, $count);
        }

        $stmt->close();

        return $categories;
    }

    /**
     * Retrieve a specific category
     *
     * @param  integer $category_id ID of the category to retrieve
     * @return AL\Common\Model\Link\LinkCategory Category

     */
    public function getCategory($category_id) {
        $stmt = \AL\Db\execute_query(
            "LinkCategoryDAO: Get single category from id: $category_id",
            $this->mysqli,
            "SELECT
                website_category_id,
                website_category_name
            FROM
                website_category
            WHERE
                website_category_id = ?",
            "s", $category_id
        );

        \AL\Db\bind_result(
            "LinkCategoryDAO: Get single category from id: $category_id",
            $stmt,
            $id, $name
        );

        $category = null;
        if ($stmt->fetch()) {
            $category = new \AL\Common\Model\Link\LinkCategory($id, $name);
        }

        $stmt->close();

        return $category;
    }
}


1			<?php
2			namespace AL\Common\DAO;
3
4			require_once __DIR__."/../../lib/Db.php" ;
5			require_once __DIR__."/../Model/Link/LinkCategory.php" ;
6
7			/**
8			* DAO for Link Categories
9			*/
10			class LinkCategoryDAO {
11			private $mysqli;
12
13			public function __construct($mysqli) {
14			$this->mysqli = $mysqli;
15			}
16
17			/**
18			* Retrieve all categories, with the count of links for each
19			*
20			* @return AL\Common\Model\Link\LinkCategory[] An array of all categories
21			*/
22			public function getAllCategories() {
23			$stmt = \AL\Db\execute_query(
24			"LinkCategoryDAO: Get all categories",
25			$this->mysqli,
26			"SELECT
27			website_category.website_category_id,
28			website_category_name,
29			COUNT(website_category_cross_id)
30			FROM
31			website_category
32			LEFT JOIN website_category_cross
33			ON website_category.website_category_id = website_category_cross.website_category_id
34			GROUP BY
35			website_category.website_category_id
36			ORDER BY
37			website_category_name ASC",
38			null, null
39			);
40
41			\AL\Db\bind_result(
42			"LinkCategoryDAO: Get all categories",
43			$stmt,
44			$id, $name, $count
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The variable `$name` seems to be never defined. Loading history... Comprehensibility Best Practice introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The variable `$count` seems to be never defined. Loading history...
45			);
46
47			$categories = [];
48			while ($stmt->fetch()) {
49			$categories[] = new \AL\Common\Model\Link\LinkCategory($id, $name, $count);
50			}
51
52			$stmt->close();
53
54			return $categories;
55			}
56
57			/**
58			* Retrieve a specific category
59			*
60			* @param integer $category_id ID of the category to retrieve
61			* @return AL\Common\Model\Link\LinkCategory Category
			0 ignored issues – show Bug introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The type `AL\Common\DAO\AL\Common\Model\Link\LinkCategory` was not found. Did you mean `AL\Common\Model\Link\LinkCategory`? If so, make sure to prefix the type with `\`. Loading history...
62			*/
63			public function getCategory($category_id) {
64			$stmt = \AL\Db\execute_query(
65			"LinkCategoryDAO: Get single category from id: $category_id",
66			$this->mysqli,
67			"SELECT
68			website_category_id,
69			website_category_name
70			FROM
71			website_category
72			WHERE
73			website_category_id = ?",
74			"s", $category_id
75			);
76
77			\AL\Db\bind_result(
78			"LinkCategoryDAO: Get single category from id: $category_id",
79			$stmt,
80			$id, $name
81			);
82
83			$category = null;
84			if ($stmt->fetch()) {
85			$category = new \AL\Common\Model\Link\LinkCategory($id, $name);
86			}
87
88			$stmt->close();
89
90			return $category;
91			}
92			}
93

atari-legend / legacy

LinkCategoryDAO::getCategory() A last analyzed 2024-03-07 17:20 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

LinkCategoryDAO::getCategory() A
last analyzed 2024-03-07 17:20 UTC