给定的PHP脚本将使用数据库中的数据填充HTML列表框（表的列）

<?php

$host = 'localhost';
$dbname = 'your_database_name';
$user = 'your_username';
$password = 'your_password';
$conn = pg_connect("host=$host dbname=$dbname user=$user password=$password");

// Check connection
if (!$conn) {
    die("Connection failed: " . pg_last_error());
}

// Fetch data ""ColumnOfYourChoice1" is like ID, ColumnOfYourChoice2" is like Value "from "YourTable"
$query = "SELECT "ColumnOfYourChoice1", "ColumnOfYourChoice2" FROM YourTable";
$result = pg_query($conn, $query);

if (!$result) {
    die("Query failed: " . pg_last_error());
}

// Create HTML list box
echo '<select name="YourTable">';

// Populate list box with YourTable data
while ($row = pg_fetch_assoc($result)) {
    $ColumnOfYourChoice1 = $row['ColumnOfYourChoice1'];
    $ColumnOfYourChoice2 = $row['ColumnOfYourChoice2'];
    echo "<option Value=\"$ColumnOfYourChoice1\">$ColumnOfYourChoice2</option>";
}

echo '</select>';

// Close PostgreSQL connection
pg_close($conn);

?>