How can PHP be used to automatically generate links to individual member pages based on database entries?

To automatically generate links to individual member pages based on database entries, you can use PHP to query the database for member information and dynamically create links for each member. By looping through the database results, you can generate a unique link for each member's page. 

<?php
// Connect to 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 database for member information
$sql = "SELECT id, name FROM members";
$result = $conn->query($sql);

// Generate links for each member
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $member_id = $row["id"];
        $member_name = $row["name"];
        echo "<a href='member.php?id=$member_id'>$member_name</a><br>";
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

PHP database link generation member pages automation

Related Questions