public static function run_json($sql)
{
$result = parent::getInstance()->getConnection()->query($sql);
// reset json response
JSON::$response = array();
// If query failed, return `false`
if ($result === FALSE) {
JSON::$response[] = array("sql" => "nok");
return;
}
if ($result === TRUE) {
JSON::$response[] = array("sql" => "ok");
return;
}
// reset json response
JSON::$response = array();
// If query was successful, retrieve all the rows into an array or True
JSON::$response[] = array("sql" => "ok");
$rows = array();
while ($row = $result->fetch_assoc()) {
// echoing JSON response
JSON::$response[] = $row;
}
return;
}
