Witam
Posiadam dwa pliki. Jeden przetrzymuje operacje na bazie danych, a drugi wywoluje funkcje i wypluwa json. Problem w tym, ze poradziłem sobie z włożeniem danych do DB ale z wyciagnieciem danych mam juz problem, ciągle mam "the response was empty" a do testowania restapi uzywam dodatku do chroma Advence REST client. Oto kod:
public function createData($title, $url) {
$stmt = $this->conn->prepare("INSERT INTO data(title, url) VALUES(?, ?)");
$stmt->bind_param("ss", $title, $url);
$result = $stmt->execute();
$stmt->close();
if ($result) {
return DATA_CREATED_SUCCESSFULLY;
}
}
public function getAll() {
$sql = "SELECT id, title, url FROM data";
$result = $this->conn->query($sql);
}
$app->post('/data', function() use ($app) {
// check for required params
verifyRequiredParams(array('title', 'url'));
$response = array();
$title = $app->request->post('title');
$url = $app->request->post('url');
$db = new DbHandler();
$data_id = $db->createData($title, $url);
if ($data_id != NULL) {
$response["error"] = false;
$response["message"] = "Data created successfully";
$response["title"] = $title;
$response["url"] = $url;
echoRespnse(201, $response);
} else {
$response["error"] = true;
$response["message"] = "Failed to create data. Please try again";
echoRespnse(200, $response);
}
});
$app->get('/all', function() {
$response = array();
$db = new DbHandler();
// fetching all
$result = $db->getAll();
$response["error"] = false;
$response["tasks"] = array();
// looping through result and preparing data array
while ($task = $result->fetch_assoc()) {
$tmp = array();
$tmp["id"] = $task["id"];
$tmp["title"] = $task["title"];
$tmp["url"] = $task["url"];
$tmp["createdAt"] = $task["created_at"];
array_push($response["tasks"], $tmp);
}
echoRespnse(200, $response);
});