136 /**
137 * Listing all tasks of particual user
138 * method GET
139 * url /tasks
140 */
141 $app->get('/tasks', 'authenticate', function() {
142 global $user_id;
143 $response = array();
144 $db = new DbHandler();
145
146 // fetching all user tasks
147 $result = $db->getAllUserTasks($user_id);
148
149 $response["error"] = false;
150 $response["tasks"] = array();
151
152 // looping through result and preparing tasks array
153 while ($task = $result->fetch_assoc()) {
154 $tmp = array();
155 $tmp["id"] = $task["id"];
156 $tmp["task"] = $task["task"];
157 $tmp["status"] = $task["status"];
158 $tmp["createdAt"] = $task["created_at"];
159 array_push($response["tasks"], $tmp);
160 }
161
162 echoRespnse(200, $response);
163 });260 /**
261 * Fetching all user tasks
262 * @param String $user_id id of the user
263 */
264 public function getAllUserTasks($user_id) {
265 $stmt = $this->conn->prepare("SELECT t.* FROM tasks t, user_tasks ut WHERE t.id = ut.task_id AND ut.user_id = ?");
266 $stmt->bind_param("i", $user_id);
267 $stmt->execute();
268 $stmt->get_result();
269 $stmt->close();
270 return $tasks;
271 }/**
* Listing all tasks of particual user
* method GET
* url /tasks
*/
$app->get('/tasks', 'authenticate', function() {
global $user_id;
$response = array();
$db = new DbHandler();
// fetching all user tasks
$result = $db->getAllUserTasks($user_id);
if ($result != NULL) {
$items = array();
foreach ($result as $rez) {
$response["error"] = false;
$response["id"] = $rez["id"];
$response["task"] = $rez["task"];
$response["status"] = $rez["status"];
$response["createdAt"] = $rez["created_at"];
$items[] = $response;
}
echoRespnse(200, $items);
} else {
$response["error"] = true;
$response["message"] = "The requested resource doesn't exists";
echoRespnse(404, $response);
}
});/**
* Fetching all user tasks
* @param String $user_id id of the user
*/
public function getAllUserTasks($user_id) {
$stmt = $this->conn->prepare("SELECT t.* FROM tasks t, user_tasks ut WHERE t.id = ut.task_id AND ut.user_id = ?");
$stmt->bind_param("i", $user_id);
if ($stmt->execute()) {
$items = $res = array();
$stmt->bind_result($id, $task, $status, $created_at);
while ($stmt->fetch()) {
$res["id"] = $id;
$res["task"] = $task;
$res["status"] = $status;
$res["created_at"] = $created_at;
$items[] = $res;
}
$stmt->close();
return $items;
} else {
return NULL;
}
}
Буду рад совету с подсказкой как убрать эту ошибку.
Средний
Средний
Простой
Простой
Средний
Простой
