What is the best way to create an HTML page with PHP that can be dynamically named based on database information?

When creating an HTML page with PHP that needs to be dynamically named based on database information, you can use a combination of PHP and SQL to retrieve the necessary data and then use that data to generate the page name dynamically. One way to achieve this is by querying the database for the relevant information and then using that information to set the page name using PHP. 

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

// Query the database for the necessary information
$sql = "SELECT page_name FROM pages WHERE id = 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        $page_name = $row["page_name"];
    }
} else {
    echo "0 results";
}

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

// Set the page name dynamically
$page_title = "My Website - " . $page_name;

// Output the HTML page with the dynamically named title
echo "<!DOCTYPE html>
<html>
<head>
<title>$page_title</title>
</head>
<body>
<h1>Welcome to $page_name</h1>
<p>This is the content of the page.</p>
</body>
</html>";
?>

Keywords

PHP HTML database dynamic naming web development

Related Questions