query($sql);
$productIds = explode(',', $productId);
$nums = explode(',', $num);
$prices = explode(',', $price);
$conn->query("DELETE FROM price WHERE AreaId=$id");
for ($i = 0; $i < count($productIds); $i++) {
$numVal = empty($nums[$i]) ? 0 : intval($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 {
$sql = "INSERT INTO country (addtime) VALUES (NOW())";
$conn->query($sql);
$id = $conn->insert_id;
$productIds = explode(',', $productId);
$nums = explode(',', $num);
$prices = explode(',', $price);
for ($i = 0; $i < count($productIds); $i++) {
$numVal = empty($nums[$i]) ? 0 : intval($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";
?>