Skip to content

Instantly share code, notes, and snippets.

@HananoshikaYomaru

HananoshikaYomaru/index.php

Created December 12, 2023 06:30
Show Gist options
  • Save HananoshikaYomaru/5762b8ddbc7fb949457c69821a2c6f7a to your computer and use it in GitHub Desktop.
Save HananoshikaYomaru/5762b8ddbc7fb949457c69821a2c6f7a to your computer and use it in GitHub Desktop.
Download ZIP
todolist + ajax + log + sqlite
Raw
index.php
<?php
require 'vendor/autoload.php';
use Monolog\Logger;
use Monolog\Handler\StreamHandler;
$db = new PDO('sqlite:todo.db');
$isAjaxRequest = !empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest';
// Create a log channel
$log = new Logger('todo');
$log->pushHandler(new StreamHandler('./test.log'));
session_start();
// Initialize the todo list
if (!isset($_SESSION['todos'])) {
$_SESSION['todos'] = [];
}
// Add a new todo item
if ($_SERVER["REQUEST_METHOD"] == "POST" && !empty($_POST['new_todo'])) {
$stmt = $db->prepare("INSERT INTO todos (task) VALUES (:task)");
$stmt->execute([':task' => $_POST['new_todo']]);
$log->info('New task added: ' . $_POST['new_todo']);
if ($isAjaxRequest) {
header('Content-Type: application/json');
echo json_encode(['success' => true]);
exit; // End the script execution for AJAX requests
}
}
// Toggle the done status
if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_GET['toggle'])) {
$stmt = $db->prepare("UPDATE todos SET done = NOT done WHERE id = :id");
$stmt->execute([':id' => $_GET['toggle']]);
}
// Remove a todo item
if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_GET['remove'])) {
$stmt = $db->prepare("DELETE FROM todos WHERE id = :id");
$stmt->execute([':id' => $_GET['remove']]);
}
$todos = $db->query("SELECT * FROM todos ORDER BY done, id DESC");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Simple To-Do List</title>
<link href="style.css" rel="stylesheet">
<script src="public/index.js"></script>
</head>
<body>
<h1>Simple To-Do List</h1>
<form id="todo-form">
<input type="text" id="new_todo" name="new_todo" required>
<button type="submit">Add</button>
</form>
<div id="todo-list">
<?php foreach ($todos as $todo) : ?>
<div class="todo-item">
<span class="<?= $todo['done'] ? 'strikethrough' : '' ?>">
<?= htmlspecialchars($todo['task']) ?>
</span>
<a href="?toggle=<?= $todo['id'] ?>">[<?= $todo['done'] ? 'Uncheck' : 'Check' ?>]</a>
<a href="?remove=<?= $todo['id'] ?>">[Remove]</a>
</div>
<?php endforeach; ?>
</div>
</body>
</html>
Raw
init_db.php
<?php
$db = new PDO('sqlite:todo.db');
// Create table
$db->exec("CREATE TABLE IF NOT EXISTS todos (
id INTEGER PRIMARY KEY AUTOINCREMENT,
task TEXT,
done INTEGER DEFAULT 0
)");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment