How can one efficiently handle data retrieval and editing from a database using PHP forms?

To efficiently handle data retrieval and editing from a database using PHP forms, you can create a form that allows users to input data, submit it to a PHP script that retrieves the data from the database, populates the form fields with the retrieved data for editing, and then updates the database with the edited data upon submission. 

<?php
// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve data from the database based on a specific ID
$id = $_GET['id'];
$sql = "SELECT * FROM table_name WHERE id = $id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    // Populate form fields with retrieved data for editing
    $field1 = $row['field1'];
    $field2 = $row['field2'];
    // Add more fields as needed

    // Display the form
    ?>
    <form method="post" action="update.php">
        <input type="hidden" name="id" value="<?php echo $id; ?>">
        <input type="text" name="field1" value="<?php echo $field1; ?>">
        <input type="text" name="field2" value="<?php echo $field2; ?>">
        <!-- Add more fields as needed -->
        <input type="submit" value="Update">
    </form>
    <?php
} else {
    echo "No data found";
}

// Close the connection
$conn->close();
?>

Keywords

PHP database data retrieval data editing forms

Related Questions