Source de LieuForm.php
<?php
require('biblimsm.php');
$connexion = mysql_connect(SERVEUR,UTILISATEUR,MOTDEPASSE);
mysql_select_db(NOMBASE,$connexion);
DebutPage('Nouvel endroit dans Lille');
?>
<FORM ACTION="SauveLieu.php" METHOD="post">
<TABLE>
<TR>
<TD>Nom</TD>
<TD><INPUT TYPE="text" NAME="nom" SIZE="60"></TD>
</TR>
<TR>
<TD>Type</TD>
<TD>
<SELECT NAME="type">
<?php
$requete = "SELECT * FROM types_lieux ORDER BY intitule_type";
$resultat = mysql_query($requete,$connexion);
while ($type = mysql_fetch_array($resultat)) {
echo '<OPTION VALUE="';
echo $type['id'];
echo '"> ';
echo $type['intitule_type'];
echo "\n";
}
?>
</SELECT>
</TD>
</TR>
<TR>
<TD>Quartier</TD>
<TD>
<SELECT NAME="quartier">
<?php
$requete = "SELECT * FROM quartiers ORDER BY nom_quartier";
$resultat = mysql_query($requete,$connexion);
while ($quartier = mysql_fetch_array($resultat)) {
echo '<OPTION VALUE="';
echo $quartier['id'];
echo '"> ';
echo $quartier['nom_quartier'];
echo "\n";
}
?>
</SELECT>
</TD>
</TR>
<TR>
<TD>Adresse</TD>
<TD><INPUT TYPE="text" NAME="adresse" SIZE="60"></TD>
</TR>
<TR>
<TD>Adresse web</TD>
<TD><INPUT TYPE="text" NAME="url" SIZE="60"></TD>
</TR>
<TR>
<TD>Métro le plus proche</TD>
<TD>
<SELECT NAME="metro">
<?php
$requete = "SELECT * FROM stations ORDER BY nom_station";
$resultat = mysql_query($requete,$connexion);
while ($station = mysql_fetch_array($resultat)) {
echo '<OPTION VALUE="';
echo $station['id'];
echo '"> ';
echo $station['nom_station'];
echo "\n";
}
?>
</SELECT>
</TD>
</TR>
<TR>
<TD>Description</TD>
<TD>
<TEXTAREA NAME="description" COLS="60" ROWS="10">
</TEXTAREA>
</TD>
</TR>
<TR>
<TD COLSPAN="2">
<INPUT TYPE="submit" VALUE="enregistrer">
</TD>
</TR>
</TABLE>
</FORM>
<?php
mysql_close($connexion);
PiedPage();
?>