Is it recommended to separate database connection and query logic from the HTML output in PHP when populating form elements?

It is recommended to separate database connection and query logic from the HTML output in PHP when populating form elements to improve code organization, readability, and maintainability. By separating these concerns, it becomes easier to make changes to the database logic without affecting the HTML output, and vice versa. This also allows for better reusability of code and follows the principle of separation of concerns. 

<?php
// Separate database connection and query logic
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

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

$sql = "SELECT id, name FROM myTable";
$result = $conn->query($sql);

// Populate form elements with data fetched from the database
echo "<select name='mySelect'>";
while($row = $result->fetch_assoc()) {
    echo "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
}
echo "</select>";

$conn->close();
?>

Keywords

database connection query logic HTML output form elements PHP

Related Questions