prepare($sql);
$stmt->execute([$id]);
if ($stmt->rowCount() > 0) {
$sql = "UPDATE allowIp SET IPAddress = ? WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->execute([$IPAddress, $id]);
} else {
$sql = "INSERT INTO allowIp (IPAddress) VALUES (?)";
$stmt = $conn->prepare($sql);
$stmt->execute([$IPAddress]);
}
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');
$ord = urlencode($_GET['Ord'] ?? '');
header("Location: ?keys=$keys&Ord=$ord&Page=$page");
exit;
} else {
$sql = "INSERT INTO allowIp (IPAddress) VALUES (?)";
$stmt = $conn->prepare($sql);
$stmt->execute([$IPAddress]);
header("Location: ?");
exit;
}
}
if ($act == "add" || $act == "edit") {
$id = $_GET['id'] ?? '';
$isedit = false;
$IPAddress = '';
if ($id != "" && is_numeric($id)) {
$isedit = true;
$sql = "SELECT * FROM allowIp WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->execute([$id]);
if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$IPAddress = textUncode($row['IPAddress']);
} else {
$isedit = false;
}
}
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');
$ord = urlencode($_GET['Ord'] ?? '');
$hrefstr = "?keys=$keys&Ord=$ord&Page=$page";
?>