<?php
$ucpname = $_POST['ucpname'];
$charname = $_POST['charname'];
$charstory = $_POST['charstory'];
$age = (int) $_POST['age']; // age as integer
$dogumyeri = $_POST['dogumyeri'];
$tenrengi = (int) $_POST['tenrengi'];
$cinsiyet = (int) $_POST['cinsiyet'];
$sifre = $_POST['sifre'];
$frage1 = $_POST['frage1'];
$frage2 = $_POST['frage2'];
$frage3 = $_POST['frage3'];
$frage4 = $_POST['frage4'];
$frage5 = $_POST['frage5'];
$frage6 = $_POST['frage6'];
$frage7 = $_POST['frage7'];
$frage8 = $_POST['frage8'];
$frage9 = $_POST['frage9'];
$frage10 = $_POST['frage10'];
$frage11 = $_POST['frage11'];
$frage12 = $_POST['frage12'];

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$stmt = $conn->prepare("INSERT INTO xucp_whitelist (ucpname, charname, charstory, age, dogumyeri, tenrengi, cinsiyet, sifre, frage1, frage2, frage3, frage4, frage5, frage6, frage7, frage8, frage9, frage10, frage11, frage12) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->bind_param("sssisiissssssssssss", $ucpname, $charname, $charstory, $age, $dogumyeri, $tenrengi, $cinsiyet, $sifre, $frage1, $frage2, $frage3, $frage4, $frage5, $frage6, $frage7, $frage8, $frage9, $frage10, $frage11, $frage12);

if ($stmt->execute()) {
    echo "Yeni kayıt başarıyla oluşturuldu";
} else {
    echo "Hata: " . $stmt->error;
}

$stmt->close();
$conn->close();
?>