parse/bd.php at master · webazex/parse · 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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
<?php

/**
 * Created by PhpStorm.
 * User: Webazex
 * Date: 08.02.2020
 * Time: 09:28
 */
class bd
{
    public $h = 'localhost';
    public $bd = 'parse';
    public $u = 'root';
    public $p = '';

    public $table = 'data';

//    getters and setters
    public function getBd()
    {
        return $this->bd;
    }

    public function getHost()
    {
        return $this->h;
    }

    public function getPassword()
    {
        return $this->p;
    }

    public function getUser()
    {
        return $this->u;
    }

//    setters
    public function setBd($bd)
    {
        $this->bd = $bd;
    }

    public function setHost($h)
    {
        $this->h = $h;
    }

    public function setPassword($p)
    {
        $this->p = $p;
    }

    public function setUser($u)
    {
        $this->u = $u;
    }

    public function connect($h, $bd, $u, $p)
    {
        $con = mysqli_connect($h, $u, $p, $bd);
        if ($con == false) {
            return array(
                0 => false,
                1 => 'Ошибка подключения' . mysqli_connect_error()
            );
        } else {
            return array(
                0 => true,
                1 => $con
            );
        }
    }

    public function getConnectRezult()
    {
        $rezult = $this->connect($this->h, $this->bd, $this->u, $this->p);
        return $rezult;
    }

    public function insertInTable($table, $fields, $html)
    {
        $con = $this->getConnectRezult();
        if ($con == true) {
            $success = $con[1];
            $values = $html;
            $values = mysqli_escape_string($success, $values);
            $values = '\'' . $values . '\'';
            $query = "INSERT INTO `$table` (`id`, `$fields`) VALUES (NULL, $values)";
            if (mysqli_query($success, $query)) {
                return true;
            } else {
                echo "Error: " . $query . "<br>" . mysqli_error($success);
            }
            mysqli_close($success);
        } else {
            return $this->success;
        }
    }

    public function getFromTable($table, $fields)
    {
        $con = $this->getConnectRezult();
        if ($con == true) {
            $success = $con[1];
            $query = "SELECT `$fields` FROM `$table`";
            $q = mysqli_query($success, $query);
            if (!$q) {
                echo "Error: " . $query . "<br>" . mysqli_error($success);
            } else {
                $return = mysqli_fetch_assoc($q);
                while ($return = mysqli_fetch_assoc($q)) {
                    $v = array_values($return);
//                    $rezult = htmlspecialchars($v[0]);
                    echo('<div class="stocks-container">' . $v[0] . '</div>');
                }
//                не отработает так как нет +1
                while ($return = mysqli_fetch_assoc($q)) {
                    $v = array_values($return);
//                    $rezult = htmlspecialchars($v[0]);
                    echo('<div style="margin: 20px auto; width: 80%;">' . $v[0] . '</div>');
                }

            }
            mysqli_close($success);
        } else {
            return $this->success;
        }

    }
}