//Smarty $oCat = $_SESSION['cat']; // Ajout d'une nouvelle categorie if (isset($_POST['state']) && $_POST['state'] == 1 && isset($_POST['id_cat']) && isset($_POST['name_cat'])) { extract($_POST); $query = "INSERT INTO categories VALUES ('','{$name_cat}','{$id_cat}', '{$color_cat}')"; $mysql->query($query); $oCat = new Categorie($mysql); $_SESSION['cat'] = $oCat; $debug = $query; } // Suppression d'une catégorie if (isset($_POST['state']) && $_POST['state'] == 3 && isset($_POST['id_cat'])) { extract($_POST); //$query = "DELETE FROM categories WHERE id='$id_cat'"; $oCat->remove($id_cat, $mysql); $debug = "La catégorie {$id_cat} a été supprimée."; //$mysql->query($query); $oCat = new Categorie($mysql); $_SESSION['cat'] = $oCat; } // Modification d'une catégorie if (isset($_POST['state']) && $_POST['state'] == 2) { extract($_POST); $query = "UPDATE categories SET name='{$name_cat}', color='{$color_cat}' WHERE id={$id_cat}"; $mysql->query($query); $oCat = new Categorie($mysql); $_SESSION['cat'] = $oCat; } $oSmarty->assign('TEST', $oCat->getTreeJs()); $oSmarty->assign('DEBUG', $debug);