1xtodo

ToDo List project as I could not find one that works like I want it to work.

This project is just started and does not do much atm.

Features

• ✨Little to no documentation! x3
• ✨Can Write to a txt file. (If you dont want the hassle with seting up a MySQL database... Use the version in the folder: "txt-based" that comes with incredibly limmited options! AMAZING! )
• ✨Uses MySQL if you are serious, not Sirius!
• ✨Missing option to delete or complete tasks :D
• ✨Has other options!
• ⚠️WARNING: This code has yet to be perfected before being runned on a publicly available server. One of the BIG amazing feutures is that sql injection seem higly possible at current state. Use at own risk.

Installlation instuctions...

DB queries:

CREATE TABLE log (
  id INT AUTO_INCREMENT PRIMARY KEY,
  task_id INT NOT NULL,
  event VARCHAR(2048) NOT NULL,
  timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE tasks (
  id INT AUTO_INCREMENT PRIMARY KEY,
  task VARCHAR(2048) NOT NULL,
  status ENUM('incomplete', 'completed') NOT NULL DEFAULT 'incomplete'
);

Sample of 1xtodo-dbcon.php is referenced to but not in the repository for a milion reasons that shoul be out of reach from public.

<?php
$servername = "localhost";
$username = "somethingusernamish";
$password = "somethingpasswordy-notpassword123!";
$dbname = "somethingdatabasenameish";

Screenshot