How can PHP code be structured to automatically determine whether to prefill form fields with database values based on the URL?

When a form is loaded, PHP can check the URL parameters to determine if specific fields should be pre-filled with database values. This can be achieved by extracting the necessary data from the URL and then querying the database to fetch the corresponding values. Finally, the PHP code can populate the form fields with the retrieved values based on the URL parameters. 

<?php
// Assuming the URL structure is like: form.php?id=123
if(isset($_GET['id'])) {
    $id = $_GET['id'];
    // Query the database to retrieve the values based on the ID
    // Replace this with your database connection and query logic
    $sql = "SELECT * FROM your_table WHERE id = $id";
    $result = mysqli_query($connection, $sql);
    $row = mysqli_fetch_assoc($result);

    // Assign the retrieved values to variables for pre-filling the form fields
    $field1 = $row['field1'];
    $field2 = $row['field2'];
}

// In your HTML form, use the variables to pre-fill the form fields
?>
<form action="submit.php" method="post">
    <input type="text" name="field1" value="<?php echo isset($field1) ? $field1 : ''; ?>">
    <input type="text" name="field2" value="<?php echo isset($field2) ? $field2 : ''; ?>">
    <!-- Add more form fields as needed -->
    <button type="submit">Submit</button>
</form>

Keywords

PHP form fields database values URL prefill

Related Questions