How can PHP handle form data retention after successful database entry, especially when dealing with reset buttons?

To handle form data retention after successful database entry, you can store the form data in PHP session variables and then repopulate the form fields with the session data. This way, even if the form is reset using a reset button, the data will still be available for the user to see.

<?php
session_start();

// Check if form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Process form data and insert into database

    // Store form data in session variables
    $_SESSION['name'] = $_POST['name'];
    $_SESSION['email'] = $_POST['email'];
    // Add more fields as needed
}

// Populate form fields with session data
$name = isset($_SESSION['name']) ? $_SESSION['name'] : '';
$email = isset($_SESSION['email']) ? $_SESSION['email'] : '';
// Add more fields as needed
?>

<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <input type="text" name="name" value="<?php echo $name; ?>" placeholder="Name">
    <input type="email" name="email" value="<?php echo $email; ?>" placeholder="Email">
    <!-- Add more fields as needed -->
    <input type="submit" value="Submit">
    <input type="reset" value="Reset">
</form>