prepare("SELECT id, first_name, last_name FROM users WHERE email = ?"); $stmt->bind_param("s", $user_email); $stmt->execute(); $result = $stmt->get_result(); $user = $result->fetch_assoc(); $user_id = $user['id']; $stmt->close(); // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $blood_type = $_POST['blood_type']; $availability = $_POST['availability']; $last_donation_date = $_POST['last_donation_date']; // Validate inputs if (empty($blood_type) || empty($availability) || empty($last_donation_date)) { $error_message = "All fields are required."; } else { // Insert donor profile into the database $stmt = $conn->prepare("INSERT INTO blood_donors (donor_id, blood_type, availability, last_donation_date) VALUES (?, ?, ?, ?)"); $stmt->bind_param("isss", $user_id, $blood_type, $availability, $last_donation_date); if ($stmt->execute()) { $success_message = "Your donor profile has been created successfully."; } else { $error_message = "Failed to create your donor profile. Please try again."; } $stmt->close(); } } ?> Donor Profile

Create Donor Profile