real_escape_string($countryName) . "',
countryCode = '" . $conn->real_escape_string($countryCode) . "',
addtime = NOW()
WHERE id = $id";
$conn->query($sql);
// Delete all existing prices for this area
$conn->query("DELETE FROM price WHERE AreaId=$id");
// Only process if we have product IDs
if (!empty($productIds) && is_array($productIds)) {
for ($i = 0; $i < count($productIds); $i++) {
if (isset($nums[$i]) && isset($prices[$i])) {
$numVal = empty($nums[$i]) ? 0 : floatval($nums[$i]);
$priceVal = empty($prices[$i]) ? 0 : $conn->real_escape_string($prices[$i]);
$productId = intval($productIds[$i]);
if ($productId > 0) {
$sql = "INSERT INTO price (productId, AreaId, num, price) VALUES ($productId, $id, $numVal, '$priceVal')";
$conn->query($sql);
}
}
}
}
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');
$ord = urlencode($_GET['Ord'] ?? '');
header("Location: ?keys=$keys&Ord=$ord&Page=$page");
exit;
} else {
// For new country, include countryName and countryCode
$sql = "INSERT INTO country (countryName, countryCode, addtime) VALUES (
'" . $conn->real_escape_string($countryName) . "',
'" . $conn->real_escape_string($countryCode) . "',
NOW()
)";
$conn->query($sql);
$id = $conn->insert_id;
// Only process if we have product IDs
if (!empty($productIds) && is_array($productIds)) {
for ($i = 0; $i < count($productIds); $i++) {
if (isset($nums[$i]) && isset($prices[$i])) {
$numVal = empty($nums[$i]) ? 0 : floatval($nums[$i]);
$priceVal = empty($prices[$i]) ? 0 : $conn->real_escape_string($prices[$i]);
$productId = intval($productIds[$i]);
if ($productId > 0) {
$sql = "INSERT INTO price (productId, AreaId, num, price) VALUES ($productId, $id, $numVal, '$priceVal')";
$conn->query($sql);
}
}
}
}
header("Location: ?");
exit;
}
}
if ($act == "add" || $act == "edit") {
$id = $_GET['id'] ?? '';
$isedit = false;
$countryCode = '';
$countryName = '';
$addtime = '';
if ($id != "" && is_numeric($id)) {
$isedit = true;
$sql = "SELECT * FROM country WHERE id = $id";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
if ($row) {
$countryCode = $row['countryCode'];
$countryName = $row['countryName'];
$addtime = $row['addtime'];
} else {
$isedit = false;
}
}
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');
$ord = urlencode($_GET['Ord'] ?? '');
$hrefstr = "?keys=$keys&Ord=$ord&Page=$page";
?>