From 6c7a859fcf9691023c418366a62ece2f19cf4c9f Mon Sep 17 00:00:00 2001 From: William Harrington Date: Mon, 12 Mar 2018 15:51:42 -0500 Subject: Initial commit for project. --- delete.php | 77 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 77 insertions(+) create mode 100644 delete.php (limited to 'delete.php') diff --git a/delete.php b/delete.php new file mode 100644 index 0000000..26ced0c --- /dev/null +++ b/delete.php @@ -0,0 +1,77 @@ + + + + + + + +Delete ID + + +'; +//var_dump($_SESSION); +?> +

+Delete Record +
+prepare($sql); + $stmt->execute(['id' => $id]); + } catch (PDOException $e) { + echo '
Have a big problem
'; + throw $e; + } + header("location:list.php"); + } + + $sql = 'SELECT id, seq, name, version, configure, build, install, setup, notes, url FROM PKG, PKG_CFG, PKG_BLD, PKG_NST, PKG_SET, PKG_NOT, PKG_URL WHERE PKG_CFG.pkg_id=PKG.id AND PKG_BLD.pkg_id=PKG.id AND PKG_NST.pkg_id=PKG.id AND PKG_SET.pkg_id = PKG.id AND PKG_NOT.pkg_id=PKG.id AND PKG_URL.pkg_id=id AND PKG.id=:id'; + try { + + $stmt = $pdo->prepare($sql); + $stmt->execute(['id' => $id]); + } catch (PDOException $e) { + echo '
Have a big problem
'; + throw $e; + } + + $row = $stmt->fetch(PDO::FETCH_ASSOC) +?> +
+ +
+ +
+ +

+

+

+

+

+

+

+
+
+ +
+
No ID given to delete!
'; +} +?> +
+ + -- cgit v1.2.3-54-g00ecf