ARFNET CSTIMS

From 3b86297c2ddcd691842efd22426fc301f6927ffa Mon Sep 17 00:00:00 2001 From: arf20 Date: Mon, 18 Mar 2024 02:44:40 +0100 Subject: Fix manageusers, create manageservices --- dbinit.sql | 2 +- manageservices.php | 132 +++++++++++++++++++++++++++++++++++++++++++++++++++++ manageusers.php | 34 ++++++++++---- 3 files changed, 159 insertions(+), 9 deletions(-) create mode 100644 manageservices.php diff --git a/dbinit.sql b/dbinit.sql index d9220d1..bbff3c7 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -16,7 +16,7 @@ CREATE TABLE `arfnet2`.`services` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `type` ENUM('free','standard','premium') NOT NULL , - `billing` DECIMAL NOT NULL , + `billing` TEXT NOT NULL , `description` TEXT NOT NULL , PRIMARY KEY (`id`) ); diff --git a/manageservices.php b/manageservices.php new file mode 100644 index 0000000..c8a17ed --- /dev/null +++ b/manageservices.php @@ -0,0 +1,132 @@ +fetch_all(MYSQLI_ASSOC); + +// GET actions +// delete entry +if (isset($_GET["del"])) { + $sql = "DELETE FROM services WHERE id = ?"; + $stmt = mysqli_prepare($link, $sql); + mysqli_stmt_bind_param($stmt, "s", $param_id); + $param_id = $_GET["del"]; + if (!mysqli_stmt_execute($stmt) || mysqli_stmt_affected_rows($stmt) != 1) { + echo "SQL error."; + } else header("location: ".$_SERVER['SCRIPT_NAME']); +} + +// POST actions +if ($_SERVER["REQUEST_METHOD"] == "POST") { + // add entry + if (isset($_POST["add"])) { + $sql = "INSERT INTO services (name, type, billing, description) VALUES (?, ?, ?, ?)"; + $stmt = mysqli_prepare($link, $sql); + mysqli_stmt_bind_param($stmt, "ssss", $param_name, $param_type, $param_billing, $param_description); + $param_name = $_POST["name"]; + $param_type= $_POST["type"]; + $param_billing = $_POST["billing"]; + $param_description = $_POST["description"]; + + if (!mysqli_stmt_execute($stmt) || (mysqli_stmt_affected_rows($stmt) != 1)) { + echo "SQL error."; + } else header("location: ".$_SERVER['SCRIPT_NAME']); + } +} + +function getservicebyid($id) { + global $services; + foreach ($services as $service) { + if ($service["id"] == $id) { + return $service; + } + } +} + +?> + + + + + + + ARFNET CSTIMS + + +

+