// Templates if ($_GET['action'] == "list_templates") { displayAllTemplates(); } elseif ($_GET['action'] == "showTemplate") { displayTemplate(); } elseif ($_GET['action'] == "editTemplate") { if (isset($_POST['updateTemplate'])) { updateTemplate(); } else { editTemplate(); } } elseif ($_GET['action'] == "addTemplate") { if (isset($_POST['insertTemplate'])) { insertTemplate(); } else { addTemplate(); } } elseif ($_GET['action'] == "deleteTemplate") { deleteTemplate(); } elseif ($_GET['action'] == "list_checks") { displayAllChecks(); } elseif ($_GET['action'] == "showCheck") { displayCheck(); } elseif ($_GET['action'] == "editCheck") { if (isset($_POST['updateCheck'])) { updateCheck(); } else { editCheck(); } } elseif ($_GET['action'] == "addCheck") { if (isset($_POST['insertCheck'])) {
<?php require_once '../includes/db_connection.php'; function addTemplate() { global $connection; $id = 0; if (isset($_GET['name'])) { $name = $connection->real_escape_string($_GET['name']); $query = "INSERT INTO..."; if (!($result = $connection->query($query))) { return; } //get new id $query = "SELECT..."; if ($result = $connection->query($query)) { while ($row = $result->fetch_assoc()) { $id = $row['catid']; } } else { return; } } return $id; } echo addTemplate();