function delete_item($id) { global $db; try { $idQuery = $db->prepare("SELECT itemId FROM agentLogins WHERE parent = :id"); $idQuery->execute(array(':id' => $id)); } catch (PDOException $e) { exit("error in query"); } while ($row = $idQuery->fetch(PDO::FETCH_ASSOC)) { agent_logins::delete_item($row['itemId']); } try { $deleteQuery = $db->prepare("DELETE FROM agentLogins WHERE itemId = :id"); $deleteQuery->execute(array(':id' => $id)); } catch (PDOException $e) { exit("error in query"); } }
agent_logins::add_parent($_POST['value']); } } else { if (isset($_POST['add_child'])) { if ($_POST['add_child']) { agent_logins::add_child($_POST['parent_id'], $_POST['label'], $_POST['value']); } } else { if (isset($_POST['edit_item'])) { if ($_POST['edit_item']) { agent_logins::edit_item($_POST['edit_itemId'], $_POST['label'], $_POST['value']); } } else { if (isset($_POST['delete'])) { if ($_POST['delete']) { agent_logins::delete_item($_POST['id']); } } } } } function add_tags($id, $parent, $contents) { global $auth; if ($auth > 1) { return "<li>{$contents}</li>"; } $open_tag = '<li> <a name="li_' . $id . '"> <span class="editable" onclick="edit_list_item(' . $id . ', ' . $parent . ');">'; $contents = $open_tag . $contents . '</span></a>