echo "1";
} else {
$res = $db->prepare("INSERT into todo (isComplete, isArchived,user_text) values (0,0,?)");
$res->execute(array($td->text));
echo $db->lastInsertId();
}
}
if ($axt == "get") {
$row = $db->query("SELECT * FROM todo where id='" . (int) $_GET['data'] . "'")->fetch();
$res = new todo();
if (count($row) > 0) {
$res->bindArr($row);
$res->text = $row['user_text'];
}
echo json_encode($res);
}
if ($axt == "getall") {
$retArr = array();
foreach ($db->query("SELECT * FROM todo") as $entry) {
$res = new todo();
$res->bindArr($entry);
$res->text = $entry['user_text'];
$retArr[] = $res;
}
echo json_encode($retArr);
}
if ($axt == "delete") {
$db->query("DELETE FROM todo where id=" . (int) $_GET['data']);
echo "1";
}
}
