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

UserDAO::__construct() A
last analyzed 2024-03-07 17:20 UTC

↳ Parent: UserDAO

Complexity

Conditions	1
Paths	1

Size

Total Lines	2
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/User/User.php" ;

/**
 * DAO for User
 */
class UserDAO {
    private $mysqli;

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

    /**
     * Retrieve all users
     * @return \AL\Common\Model\User\User[] A list of users
     */
    public function getAllUsers() {
        $stmt = \AL\Db\execute_query(
            "UserDAO: getAllUsers",
            $this->mysqli,
            "SELECT
                user_id,
                userid,
                email,
                join_date,
                karma,
                show_email,
                avatar_ext
            FROM users
            ORDER BY userid ASC",
            null, null
        );

        \AL\Db\bind_result(
            "UserDAO: getAllUsers",
            $stmt,
            $id,
            $userid,
            $email,
            $join_date,
            $karma,
            $show_email,
            $avatar_ext
        );

        $users = [];

        while ($stmt->fetch()) {
            $users[] = new \AL\Common\Model\User\User(
                $id,
                $userid,
                $email,
                $join_date,
                $karma,
                $show_email,
                $avatar_ext,
                0
            );
        }

        $stmt->close();

        return $users;
    }
}


1			<?php
2			namespace AL\Common\DAO;
3
4			require_once __DIR__."/../../lib/Db.php" ;
5			require_once __DIR__."/../Model/User/User.php" ;
6
7			/**
8			* DAO for User
9			*/
10			class UserDAO {
11			private $mysqli;
12
13			public function __construct($mysqli) {
14			$this->mysqli = $mysqli;
15			}
16
17			/**
18			* Retrieve all users
19			* @return \AL\Common\Model\User\User[] A list of users
20			*/
21			public function getAllUsers() {
22			$stmt = \AL\Db\execute_query(
23			"UserDAO: getAllUsers",
24			$this->mysqli,
25			"SELECT
26			user_id,
27			userid,
28			email,
29			join_date,
30			karma,
31			show_email,
32			avatar_ext
33			FROM users
34			ORDER BY userid ASC",
35			null, null
36			);
37
38			\AL\Db\bind_result(
39			"UserDAO: getAllUsers",
40			$stmt,
41			$id,
42			$userid,
43			$email,
44			$join_date,
45			$karma,
46			$show_email,
47			$avatar_ext
48			);
49
50			$users = [];
51
52			while ($stmt->fetch()) {
53			$users[] = new \AL\Common\Model\User\User(
54			$id,
55			$userid,
56			$email,
57			$join_date,
58			$karma,
59			$show_email,
60			$avatar_ext,
61			0
62			);
63			}
64
65			$stmt->close();
66
67			return $users;
68			}
69			}
70

atari-legend / legacy

UserDAO::__construct() A last analyzed 2024-03-07 17:20 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

UserDAO::__construct() A
last analyzed 2024-03-07 17:20 UTC