break;
case "updateword":
$wid = isset($_POST["id"]) ? $_POST["id"] : "";
$word = isset($_POST["word"]) ? $_POST["word"] : "";
$wordBase = isset($_POST["wordbase"]) ? $_POST["wordbase"] : "";
$translation = isset($_POST["translation"]) ? $_POST["translation"] : "";
$description = isset($_POST["description"]) ? $_POST["description"] : "";
$message["status"] = updateWord($conn, $userID, $wid, $word, $translation, $description, $wordBase);
break;
case "deleteword":
$wid = isset($_POST["id"]) ? $_POST["id"] : "";
$message["status"] = deleteWord($conn, $userID, $wid);
break;
case "insertlist":
$list = $_POST["list"];
$message = insertList($conn, $userID, $list);
break;
case "listlist":
$message["results"] = getListList($conn, $userID, $_GET["first"], $_GET["last"]);
$message["success"] = true;
break;
case "sharelistuser":
$message["status"] = shareListUser($conn, $userID, $_POST["user"], $_POST["list"]);
break;
case "renamelist":
$message["status"] = renameList($conn, $userID, $_POST["id"], $_POST["name"]);
break;
case "deletelist":
$message["status"] = deleteList($conn, $userID, $_POST["id"]);
break;
}
deleteList($_GET['deleteList']);
}
// Insert list into DataBase
$insertionListVerif;
function insertList($list)
{
if ($connexion = mysqli_connect('localhost', 'root', '', 'samirello')) {
$requete = "INSERT INTO lists(`id`,`listname`) VALUES (NULL, '{$list}')";
$resultat = mysqli_query($connexion, $requete);
$insertionListVerif = "resultat : " . ($resultat ? 'ok' : 'false');
} else {
$insertionListVerif = "erreur BDD !";
}
}
if (isset($_GET['addedList'])) {
insertList($_GET['addedList']);
}
// Insert item into DataBase
$insertionVerif;
function insert($list, $name, $date, $task)
{
if ($connexion = mysqli_connect('localhost', 'root', '', 'samirello')) {
$requete = "INSERT INTO users(`id`,`listname`,`name`,`date`, `task`) VALUES (NULL,'{$list}', '{$name}','{$date}', '{$task}')";
$resultat = mysqli_query($connexion, $requete);
$insertionVerif = "resultat : " . ($resultat ? 'ok' : 'false');
} else {
$insertionVerif = "erreur BDD !";
}
}
if (isset($_GET['list']) && isset($_GET['name']) && isset($_GET['date']) && isset($_GET['task'])) {
insert($_GET['list'], $_GET['name'], $_GET['date'], $_GET['task']);
