throw new Exception($this->dbc->connect_error, $this->dbc->connect_errno);
65
}
66
67
1
$this->dbc->set_charset("utf8");
68
1
}
69
70
/**
71
* Destroy this connection to the database
72
*/
73
public function __destruct()
74
{
75
$this->closeConnection();
76
}
77
78
/**
79
* Get an instance of the Database object
80
*
81
* This should be the main way to acquire access to the database
82
*
83
* @return Database The Database object
84
*/
85
39
public static function getInstance()
86
{
87
39
if (!self::$Database) {
88
1
if (Service::getEnvironment() == 'test') {
89
1
if (!Service::getParameter('bzion.testing.enabled')) {
90
throw new Exception('You have to specify a MySQL database for testing in the bzion.testing section of your configuration file.');
91
}
92
93
1
self::$Database = new self(
94
1
Service::getParameter('bzion.testing.host'),
95
1
Service::getParameter('bzion.testing.username'),
96
1
Service::getParameter('bzion.testing.password'),
97
1
Service::getParameter('bzion.testing.database')
98
);
99
} else {
100
self::$Database = new self(
101
Service::getParameter('bzion.mysql.host'),
102
Service::getParameter('bzion.mysql.username'),
103
Service::getParameter('bzion.mysql.password'),
104
Service::getParameter('bzion.mysql.database')
105
);
106
}
107
}
108
109
39
return self::$Database;
110
}
111
112
/**
113
* Close the current connection to the MySQL database
114
*/
115
public function closeConnection()
116
{
117
@mysqli_close($this->dbc);
118
}
119
120
/**
121
* Tests whether or not the connection to the database is still active
122
* @return bool True if the connection is active
123
*/
124
public function isConnected()
125
{
126
return $this->dbc->ping();
127
}
128
129
/**
130
* Get the unique row ID of the last row that was inserted
131
* @return int The ID of the row
132
*/
133
39
public function getInsertId()
134
{
135
39
return $this->last_id;
136
}
137
138
/**
139
* Prepares and executes a MySQL prepared statement. <em>Second two parameters are optional when using this function to execute a query with no placeholders.</em>
140
*
141
* <code>
142
* //the appropriate letters to show what type of variable will be passed
143
* //i - integer
144
* //d - double
145
* //s - string
146
* //b - blob
147
*
148
* $database = new Database(); //create a new database object
149
*
150
* $query = "SELECT * FROM table WHERE id = ?"; //write the prepared statement where ? are placeholders
151
* $params = array("1"); //all the parameters to be binded, in order
152
* $results = $database->query($query, "i", $params); //execute the prepared query
153
* </code>
154
*
155
* @param string $queryText The prepared SQL statement that will be executed
156
* @param bool|string $typeDef (Optional) The types of values that will be passed through the prepared statement. One letter per parameter
157
* @param mixed|array $params (Optional) The array of values that will be binded to the prepared statement
158
* @return mixed Returns an array of the values received from the query or returns false on empty
159
*/
160
39
public function query($queryText, $typeDef = false, $params = false)
161
{
162
39
if (!is_array($params)) {
163
1
$params = array($params);
164
}
165
166
39
$debug = new DatabaseQuery($queryText, $typeDef, $params);
It seems like $typeDef defined by parameter $typeDef on line 160 can also be of type boolean; however, BZIon\Debug\DatabaseQuery::__construct() does only seem to accept string, maybe add an additional type check?
This check looks at variables that have been passed in as parameters and are passed out again
to other methods.
If the outgoing method call has stricter type requirements than the method itself, an issue is raised.
allejo /
bzion
kongr45gpen
This check looks at variables that have been passed in as parameters and are passed out again to other methods.
If the outgoing method call has stricter type requirements than the method itself, an issue is raised.
An additional type check may prevent trouble.