What is the best way to display data from a database in a form using PHP?

To display data from a database in a form using PHP, you can retrieve the data from the database using SQL queries and then populate the form fields with the retrieved data. You can use PHP to connect to the database, fetch the data, and then echo the data into the form fields. 

<?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);
}

// Fetch data from the database
$sql = "SELECT * FROM table_name WHERE id = 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo '<input type="text" name="field1" value="' . $row["column1"] . '"><br>';
        echo '<input type="text" name="field2" value="' . $row["column2"] . '"><br>';
        // Add more input fields as needed
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

PHP database form display data

Related Questions