db_lib

Complexity

Total Complexity

10

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	prepared_execute()	0	18	5
A	bind_params()	0	13	5

<?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;
    }

}