birth_registration.php
prepare($check_query);
$stmt->bind_param("ssss", $child_name, $date_of_birth, $father_name, $mother_name);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
// ❌ Duplicate entry found, show error message
$existing_record = $result->fetch_assoc();
$existing_ref = $existing_record['reference_number'];
echo "";
exit;
} else {
// ✅ Proceed with inserting new birth record
$stmt = $conn->prepare("INSERT INTO birth_records (child_name, child_name_marathi, date_of_birth) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $child_name, $child_name_marathi, $date_of_birth);
$stmt->execute();
$child_id = $stmt->insert_id;
$stmt->close();
// Generate a unique reference number (GP-KEKATPANGARI-YYYYMMDD-XXXX)
$reference_number = "GP-KEKATPANGARI-" . date("Ymd") . "-" . str_pad($child_id, 4, "0", STR_PAD_LEFT);
// Update the reference number in the birth record
$stmt = $conn->prepare("UPDATE birth_records SET reference_number = ? WHERE id = ?");
$stmt->bind_param("si", $reference_number, $child_id);
$stmt->execute();
$stmt->close();
// Insert parents' information
$stmt = $conn->prepare("INSERT INTO parents (child_id, father_name, mother_name) VALUES (?, ?, ?)");
$stmt->bind_param("iss", $child_id, $father_name, $mother_name);
$stmt->execute();
$stmt->close();
// ✅ Successfully registered, redirect to the receipt page
header("Location: birth_receipt.php?ref=" . urlencode($reference_number));
exit;
}
}
?>