Database::executeStatement() - Code Metrics - Inspection of "2e0cc8ee2749ad39b7fe4bdfec7cac59d7a22f6e" - nilsteampassnet/TeamPass - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — wip_sessions (2e0cc8)

by Nils

created 2024-01-06 07:19 UTC

Database::executeStatement() A

↳ Parent: Database

Complexity

Conditions	4
Paths	7

Size

Total Lines	18
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	4
eloc	10
nc	7
nop	2
dl	0
loc	18
rs	9.9332
c	0
b	0
f	0

<?php
/**
 * Teampass - a collaborative passwords manager.
 * ---
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * ---
 *
 * @project   Teampass
 * @version    API
 *
 * @file      Database.php
 * ---
 *
 * @author    Nils Laumaillé ([email protected])
 *
 * @copyright 2009-2023 Teampass.net
 *
 * @license   https://spdx.org/licenses/GPL-3.0-only.html#licenseText GPL-3.0
 * ---
 *
 * @see       https://www.teampass.net
 */
class Database
{
    protected $connection = null;

    public function __construct()
    {
        try {
            $this->connection = new \mysqli(DB_HOST, DB_USER, DB_PASSWD_CLEAR, DB_NAME);

            if ( mysqli_connect_errno()) {
                throw new Exception("Could not connect to database.");   
            }
        } catch (Exception $e) {
            throw new Exception($e->getMessage());   
        }           
    }

    public function select($query = "" , $params = [])
    {
        try {
            $stmt = $this->executeStatement( $query , $params );
            $result = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);               
            $stmt->close();

            return $result;
        } catch(Exception $e) {
            throw New Exception( $e->getMessage() );
        }
    }

    private function executeStatement($query = "" , $params = [])
    {
        try {
            $stmt = $this->connection->prepare( $query );

            if($stmt === false) {
                throw New Exception("Unable to do prepared statement: " . $query);
            }

            if( $params ) {
                $stmt->bind_param($params[0], $params[1]);
            }

            $stmt->execute();

            return $stmt;
        } catch(Exception $e) {
            throw New Exception( $e->getMessage() );
        }   
    }
}

1			<?php
2			/**
3			* Teampass - a collaborative passwords manager.
4			* ---
5			* This library is distributed in the hope that it will be useful,
6			* but WITHOUT ANY WARRANTY; without even the implied warranty of
7			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
8			* ---
9			*
10			* @project Teampass
11			* @version API
12			*
13			* @file Database.php
14			* ---
15			*
16			* @author Nils Laumaillé ([email protected])
17			*
18			* @copyright 2009-2023 Teampass.net
19			*
20			* @license https://spdx.org/licenses/GPL-3.0-only.html#licenseText GPL-3.0
21			* ---
22			*
23			* @see https://www.teampass.net
24			*/
25			class Database
26			{
27			protected $connection = null;
28
29			public function __construct()
30			{
31			try {
32			$this->connection = new \mysqli(DB_HOST, DB_USER, DB_PASSWD_CLEAR, DB_NAME);
33
34			if ( mysqli_connect_errno()) {
35			throw new Exception("Could not connect to database.");
36			}
37			} catch (Exception $e) {
38			throw new Exception($e->getMessage());
39			}
40			}
41
42			public function select($query = "" , $params = [])
43			{
44			try {
45			$stmt = $this->executeStatement( $query , $params );
46			$result = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
47			$stmt->close();
48
49			return $result;
50			} catch(Exception $e) {
51			throw New Exception( $e->getMessage() );
52			}
53			}
54
55			private function executeStatement($query = "" , $params = [])
56			{
57			try {
58			$stmt = $this->connection->prepare( $query );
59
60			if($stmt === false) {
61			throw New Exception("Unable to do prepared statement: " . $query);
62			}
63
64			if( $params ) {
65			$stmt->bind_param($params[0], $params[1]);
66			}
67
68			$stmt->execute();
69
70			return $stmt;
71			} catch(Exception $e) {
72			throw New Exception( $e->getMessage() );
73			}
74			}
75			}

nilsteampassnet / TeamPass

Branch — wip_sessions (2e0cc8)

Database::executeStatement() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like