real_escape_string($powername) . "' AND id != " . $id; $result = $conn->query($sql); if ($result->fetch_assoc()['count'] > 0) { echo ""; exit; } $sql = "UPDATE power SET powername = '" . $conn->real_escape_string($powername) . "', powercontent = '" . $conn->real_escape_string($powercontent) . "' WHERE id = " . $id; $conn->query($sql); } else { // Check if power name exists $sql = "SELECT COUNT(id) as count FROM power WHERE powername = '" . $conn->real_escape_string($powername) . "'"; $result = $conn->query($sql); if ($result->fetch_assoc()['count'] > 0) { echo ""; exit; } $sql = "INSERT INTO power (powername, powercontent, powerstate) VALUES ('" . $conn->real_escape_string($powername) . "', '" . $conn->real_escape_string($powercontent) . "', 1)"; $conn->query($sql); } header("Location: ?keys=$keys&Ord=$ord&Page=$page"); exit; } // Handle postchk action if ($act == "postchk") { if (isset($_POST['chkbox']) && is_array($_POST['chkbox'])) { $ids = array_map('intval', $_POST['chkbox']); $idList = implode(',', $ids); $chkact = $_POST['chkact'] ?? ''; if ($chkact == "0" || $chkact == "1") { $sql = "UPDATE power SET powerstate = " . (int)$chkact . " WHERE id IN (" . $idList . ")"; } else { $sql = "DELETE FROM power WHERE id IN (" . $idList . ")"; } $conn->query($sql); } header("Location: ?Keys=$keys&Ord=$ord&Page=$page"); exit; } // Now start HTML output ?>