db_lib::prepared_execute() - Code Metrics - felicity-iiith/felicity18-website - Measure and Improve Code Quality continuously with Scrutinizer

db_lib::prepared_execute() A
last analyzed 2019-04-29 06:08 UTC

↳ Parent: db_lib

Complexity

Conditions	5
Paths	5

Size

Total Lines	18
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	5
eloc	10
nc	5
nop	5
dl	0
loc	18
rs	9.6111
c	0
b	0
f	0

<?php

/**
 * Database library, common DB helpers
 */
class db_lib extends Library {

    private function bind_params($stmt, $datatypes, $data) {
        if (!empty($datatypes) && !empty($data)) {
            // Convert to references
            $data = array_merge([$datatypes], $data);
            foreach ($data as $key => $value) {
                $data[$key] = &$data[$key];
            }

            if (!call_user_func_array(array($stmt, "bind_param"), $data)) {
                return false;
            }
        }
        return true;
    }

    public function prepared_execute($conn, $sql, $datatypes, $data, $return_stmt = true) {
        $stmt = $conn->prepare($sql);
        if (!$stmt) {
            return false;
        }

        if ($this->bind_params($stmt, $datatypes, $data) === false) {
            return false;
        };

        if (!$stmt->execute()) {
            return false;
        }

        if ($return_stmt) {
            return $stmt;
        }
        return true;
    }

}


1			<?php
2
3			/**
4			* Database library, common DB helpers
5			*/
6			class db_lib extends Library {
7
8			private function bind_params($stmt, $datatypes, $data) {
9			if (!empty($datatypes) && !empty($data)) {
10			// Convert to references
11			$data = array_merge([$datatypes], $data);
12			foreach ($data as $key => $value) {
13			$data[$key] = &$data[$key];
14			}
15
16			if (!call_user_func_array(array($stmt, "bind_param"), $data)) {
17			return false;
18			}
19			}
20			return true;
21			}
22
23			public function prepared_execute($conn, $sql, $datatypes, $data, $return_stmt = true) {
24			$stmt = $conn->prepare($sql);
25			if (!$stmt) {
26			return false;
27			}
28
29			if ($this->bind_params($stmt, $datatypes, $data) === false) {
30			return false;
31			};
32
33			if (!$stmt->execute()) {
34			return false;
35			}
36
37			if ($return_stmt) {
38			return $stmt;
39			}
40			return true;
41			}
42
43			}
44

felicity-iiith / felicity18-website

db_lib::prepared_execute() A last analyzed 2019-04-29 06:08 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

db_lib::prepared_execute() A
last analyzed 2019-04-29 06:08 UTC