How can individual guestbook entries be loaded into a textarea for editing without displaying all entries at once in PHP?

To load individual guestbook entries into a textarea for editing without displaying all entries at once in PHP, you can use a form with a dropdown menu to select the entry to edit. When a specific entry is selected, its content can be retrieved from the database and displayed in the textarea for editing. 

<?php
// Assuming $db is the database connection

// Query to retrieve all guestbook entries
$query = "SELECT id, name FROM guestbook";
$result = mysqli_query($db, $query);

// Display dropdown menu with entry names
echo "<form method='post'>";
echo "<select name='entry_id'>";
while($row = mysqli_fetch_assoc($result)) {
    echo "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
}
echo "</select>";
echo "<textarea name='entry_content'></textarea>";
echo "<input type='submit' value='Edit Entry'>";
echo "</form>";

// Handle form submission
if(isset($_POST['entry_id'])) {
    $entry_id = $_POST['entry_id'];
    $query = "SELECT content FROM guestbook WHERE id = $entry_id";
    $result = mysqli_query($db, $query);
    $row = mysqli_fetch_assoc($result);
    $entry_content = $row['content'];
    echo "<script>document.getElementsByName('entry_content')[0].value = '$entry_content';</script>";
}
?>

Keywords

PHP guestbook textarea editing entries

Related Questions