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"; } }