class error { public $code = ""; public function getCode() { return $this->code; } } $output = new response(); $err = new error(); //SQL query goes here //Location is default to "BC", Days is defaulted to 5, //Desease is defauled to 'flu' $output->diseasetype = "flu"; $output->location = "BC"; $sql = "SELECT infected FROM " . $output->getLocation() . " WHERE deseasetype = '" . $output->getDiseasetype() . "' LIMIT 5"; $result = $conn->query($sql); //JSON parsing and echo go here if ($result->num_rows == 5) { while ($r = $result->fetch_assoc()) { $output->arrayInfected[] = $r; } echo json_encode($output); } else { $err->code = "Something went wrong"; echo json_encode($err); } $conn->close; ?>