예제 #1
0
        }
        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();
        }