exec("CREATE TABLE IF NOT EXISTS templates (id INTEGER PRIMARY KEY, name TEXT UNIQUE, content TEXT)");
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$action = $_POST['action'] ?? '';
if ($action === 'save') {
$name = $_POST['name'] ?? '';
$content = $_POST['content'] ?? '';
if ($name && $content) {
$stmt = $db->prepare("INSERT OR REPLACE INTO templates (name, content) VALUES (:name, :content)");
$stmt->bindValue(':name', $name, SQLITE3_TEXT);
$stmt->bindValue(':content', $content, SQLITE3_TEXT);
$stmt->execute();
}
} elseif ($action === 'delete') {
$name = $_POST['name'] ?? '';
if ($name) {
$stmt = $db->prepare("DELETE FROM templates WHERE name = :name");
$stmt->bindValue(':name', $name, SQLITE3_TEXT);
$stmt->execute();
}
}
}
$templates = $db->query("SELECT name FROM templates");
$templateList = [];
while ($row = $templates->fetchArray(SQLITE3_ASSOC)) {
$templateList[] = $row['name'];
}
?>
Générateur et Éditeur de Signatures Outlook
Générateur et Éditeur de Signatures Outlook