1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
| <?php
// connexion à la base
$Host = '***************';
$User = '***************';
$Password = '******';
$Database = '*************';
$idConnect = mysql_connect( $Host, $User, $Password) or die( "Connexion impossible.");
$db = mysql_select_db( $Database, $idConnect) or die( "Accès base impossible.");
// Requête SQL
$rqSql = 'SELECT player FROM travsync_x_world ORDER BY player';
// Exécution de la requête
$result = mysql_query( $rqSql, $idConnect) or die( "Exécution requête impossible.");
mysql_close( $idConnect);
// Construction de la chaîne de caractères qui fait la liste
$ld = "<SELECT NAME='joueur'>";
$ld .= "<OPTION VALUE=0>Choisissez</OPTION>";
// On boucle sur la table
while ( $row = mysql_fetch_array( $result)) {
$player = $row["player"];
if ( $player == $playerRecord) {
$s = "selected";
} else {
$s = "";
}
$ld .= "<OPTION VALUE='$player' $s >
$player</OPTION>";
}
$ld .= "</SELECT>";
print $ld;
?> |
