climaker/DataBase.php at master · Skorzhyk/climaker · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<?php

class DataBase
{
    private static $db = null;

    private $mysqli;

    const SYM_QUERY = "{?}";


    public static function getDB()
    {
        if (self::$db === null) {
            self::$db = new self();
        }

        return self::$db;
    }

    private function __construct()
    {
        $this->mysqli = new mysqli(
            'localhost',
            'root',
            '',
            'climaker'
        );
    }

    private function getQuery($query, $params = null)
    {
        if ($params !== null) {
            for ($i = 0; $i < count($params); $i++) {
                $pos = strpos($query, self::SYM_QUERY);
                $arg = "'" . $this->mysqli->real_escape_string($params[$i]) . "'";
                $query = substr_replace($query, $arg, $pos, strlen(self::SYM_QUERY));
            }
        }

        return $query;
    }

    public function select($query, $params = null)
    {
        $result_set = $this->mysqli->query($this->getQuery($query, $params));

        return !$result_set ? [] : $this->resultSetToArray($result_set);
    }

    public function selectRow($query, $params = null)
    {
        $result_set = $this->mysqli->query($this->getQuery($query, $params));

        return $result_set->num_rows != 1 ? null : $result_set->fetch_assoc();
    }

    public function query($query, $params = null)
    {
        $success = $this->mysqli->query($this->getQuery($query, $params));

        if ($success) {
            return $this->mysqli->insert_id === 0 ? true : $this->mysqli->insert_id;
        }

        return false;
    }

    private function resultSetToArray($result_set)
    {
        $array = array();

        while (($row = $result_set->fetch_assoc()) != false) {
            $array[] = $row;
        }

        return $array;
    }
}