prepare("UPDATE tasks SET status = :status WHERE id = :id"); $result = $stmt->execute(['status' => $newStatus, 'id' => $taskId]); if ($result && $stmt->rowCount() > 0) { log_message('Database update successful. Rows affected: ' . $stmt->rowCount()); echo json_encode(['success' => true, 'message' => 'Task status updated.']); } else { log_message('Database update failed or status unchanged. Rows affected: ' . $stmt->rowCount()); echo json_encode(['success' => false, 'message' => 'Task not found or status unchanged.']); } } catch (PDOException $e) { log_message('Database error: ' . $e->getMessage()); http_response_code(500); echo json_encode(['success' => false, 'message' => 'Database error: ' . $e->getMessage()]); } } else { log_message('Invalid input. Task ID or New Status is missing.'); http_response_code(400); echo json_encode(['success' => false, 'message' => 'Invalid input.']); } } else { log_message('Request method not allowed: ' . $_SERVER['REQUEST_METHOD']); http_response_code(405); echo json_encode(['success' => false, 'message' => 'Method not allowed.']); } ?>