prepare($sql); $stmt->bindParam(':table', $table); $stmt->execute(); if ($stmt->rowCount() == 0) { echo ""; exit(); } // Prepare SQL to insert into the correct department table $sql = "INSERT INTO $table (name, email, register_number, password, department) VALUES (:name, :email, :register_number, :password, :department)"; $stmt = $conn->prepare($sql); // Bind parameters $stmt->bindParam(':name', $name); $stmt->bindParam(':email', $email); $stmt->bindParam(':register_number', $register_number); $stmt->bindParam(':password', $hashed_password); $stmt->bindParam(':department', $department); // Execute the statement $stmt->execute(); // Redirect to login page or any other page as needed header('Location: StudentLS.html'); exit(); } catch (PDOException $e) { // Show an alert for duplicate entry header("Location:dublication_error.html"); } } ?>

Create Your Account

hi