process.php

<?php
session_start();
include 'db.php';

if (isset($_POST['register'])) {
    $fname = $_POST['first_name'];
    $lname = $_POST['last_name'];
    $dept = $_POST['department'];
    $gender = $_POST['gender'] ?? 'Not Specified';
    $others = $_POST['others'];
    
    // Convert hobbies array to a single string
    $hobbies = isset($_POST['hobbies']) ? implode(", ", $_POST['hobbies']) : "None";

    $sql = "INSERT INTO users (first_name, last_name, department, gender, hobbies, others) 
            VALUES (?, ?, ?, ?, ?, ?)";
    
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ssssss", $fname, $lname, $dept, $gender, $hobbies, $others);

    if ($stmt->execute()) {
        $_SESSION['message'] = "Registration Successful!";
    } else {
        $_SESSION['message'] = "Error: " . $conn->error;
    }

    $stmt->close();
    header("Location: index.php");
    exit();
}
?>