crud.class.php

Gesponsorde koppelingen

PHP script bestanden

  1. crud.class.php
  2. crud.view.php

« Lees de omschrijving en reacties

Code (php)
PHP script in nieuw venster Selecteer het PHP script
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
133
134
135
136
137
138
139
140
<?php
class CRUD{
    private $_mysqli;

    /*
     * @param object $mysqli
     */
    public function __construct($mysqli)
    {
        $this->_mysqli = $mysqli;
    }

    /*
     * @param string query
     * @param string $types
     * @param array $values
     */
    public function create($query = "", $type = "", $params = array())
    {
        $query = ($query === "") ? die("Create error: Query") : $query;
        $type = ($type === "") ? die("Create error: Type") : array($type);
        $params = (count($params) == 0) ? die("Create error: Params") : $params;

        $values = array();
        foreach($params as $key => $value) {
            $values[$key] = &$params[$key];
        }

        if ($stmt = $this->_mysqli->prepare($query))
        {
            call_user_func_array(array($stmt, "bind_param"), array_merge($type, $values));
            $stmt->execute();
        }

        $stmt->close();
    }

    /*
     * @param string query
     * @param string $types
     * @param array $values
     */
    public function read($query = "", $type = "", $params = array())
    {
        $query = ($query === "") ? die("Read error: Query") : $query;
        $type = ($type === "") ? die("Read error: Type") : array($type);
        $params = (count($params) == 0) ? die("Read error: Params") : $params;

        $values = array();
        foreach($params as $key => $value) {
            $values[$key] = &$params[$key];
        }

        if ($stmt = $this->_mysqli->prepare($query))
        {
            call_user_func_array(array($stmt, "bind_param"), array_merge($type, $values));
            $stmt->execute();

            $meta = $stmt->result_metadata();
            while ($field = $meta->fetch_field()) {
                $var = $field->name;
                $$var = null;
                $fields[$field->name] = &$$var;
            }
            call_user_func_array(array($stmt, "bind_result"), $fields);

            while($stmt->fetch())
            {
                return $fields;
            }
        }
        $stmt->close();
    }

    /*
     * @param string query
     * @param string $types
     * @param array $values
     */
    public function update($query = "", $type = "", $params = array())
    {
        $query = ($query === "") ? die("Update error: Query") : $query;
        $type = ($type === "") ? die("Update error: Type") : array($type);
        $params = (count($params) == 0) ? die("Update error: Params") : $params;

        $values = array();
        foreach($params as $key => $value) {
            $values[$key] = &$params[$key];
        }

        if ($stmt = $this->_mysqli->prepare($query))
        {
            call_user_func_array(array($stmt, "bind_param"), array_merge($type, $values));
            $stmt->execute();
        }
        $stmt->close();
    }

    /*
     * @param string query
     * @param string $types
     * @param array $values
     */
    public function delete($query = "", $type = "", $params = array())
    {
        $query = ($query === "") ? die("Delete error: Query") : $query;
        $type = ($type === "") ? die("Delete error: Type") : array($type);
        $params = (count($params) == 0) ? die("Delete error: Params") : $params;

        $values = array();
        foreach($params as $key => $value) {
            $values[$key] = &$params[$key];
        }

        if ($stmt = $this->_mysqli->prepare($query))
        {
            call_user_func_array(array($stmt, "bind_param"), array_merge($type, $values));
            $stmt->execute();
        }
        $stmt->close();
    }

    /*
     * @param string query
     */
    public function query($query = "")
    {
        $query = ($query === "") ? die("Query error: Query") : $query;

        if ($result = $this->_mysqli->query($query))
        {
            $array = array();
            while ($row = $result->fetch_assoc())
            {
                $array[] = $row;
            }
            return $array;
        }
    }
}

 
 

Om de gebruiksvriendelijkheid van onze website en diensten te optimaliseren maken wij gebruik van cookies. Deze cookies gebruiken wij voor functionaliteiten, analytische gegevens en marketing doeleinden. U vindt meer informatie in onze privacy statement.