} if (isset($arr['isArchived'])) { $this->isArchived = $arr['isArchived']; } if (isset($arr['text'])) { $this->text = $arr['text']; } if (isset($arr['id'])) { $this->id = $arr['id']; } } } $axt = isset($_GET['axt']) ? strtolower($_GET['axt']) : null; $data = isset($_GET['data']) ? json_decode($_GET['data']) : null; $td = new todo(); $td->bind($data); if (!$axt) { return; } if ($db = new PDO('sqlite:todo.sqlite')) { if ($axt == "save") { if (isset($data->id) && strlen($data->id) > 0) { $res = $db->prepare("UPDATE todo SET isComplete=? , isArchived=?, user_text=? where id=?"); $myData = array((int) $td->isComplete, (int) $td->isArchived, $td->text, $td->id); $res->execute($myData); echo "1"; } else { $res = $db->prepare("INSERT into todo (isComplete, isArchived,user_text) values (0,0,?)"); $res->execute(array($td->text)); echo $db->lastInsertId(); }