Nous sommes d'accord mais il semblerait que les popups n'accepte pas les $_POST donc du coup je n'en utilise pas.
et le code pour récupéré est celui ci
if (isset($_SESSION['choix']))
{
//--------------- le traitement à faire pour une checkbox cochée ---------------//
$id = $_SESSION['choix'];
$_SESSION['id'] = $id;
$sql = " SELECT *
FROM ARRET_CHAINE
WHERE NUMERO_ARRET_CHAINE = $id" ;
$req = odbc_exec($conn,$sql) or die('Erreur SQL : <br />'.$sql);
while (odbc_fetch_row($req))
{
$TYPE=odbc_result($req,"TYPE");
$DEBUT=odbc_result($req,"HEURE_DEBUT");
$FIN=odbc_result($req,"HEURE_FIN");
$CONSTAT=odbc_result($req,"CONSTAT");
$DEMANDE=odbc_result($req,"DEMANDE");
$CAUSE=odbc_result($req,"CAUSE");
$INFO=odbc_result($req,"COMPLEMENT_INFORMATION");
$IMPUTATION=odbc_result($req,"IMPUTATION");
}
$sql = "SELECT DESIGNATION
FROM TYPE";
$req = odbc_exec($conn,$sql) or die('Erreur SQL : <br />'.$sql);
echo "<select name= 'TYPE' >";
while($data = odbc_fetch_array($req))
{
echo "\n <option value=\"".$data["DESIGNATION"]."\" selected>".$data["DESIGNATION"]."</option>\n\n";
}
if (isset($TYPE))
{
echo "<option value='$TYPE' selected='selected'>$TYPE</option>";
echo '</select>';
}
else
{
echo "<option value='type' selected='selected'>Type</option>";
echo '</select>';
}
?>
<!------------------ Saisie Dates ------------------>
<br><br><br>
Heure début :
<input name="HEURE_DEBUT" value="<?php
if (isset($DEBUT))
{
echo $DEBUT;
}
?>" maxlength="8" size="6" type="time">
Heure fin :
<input name="HEURE_FIN" value="<?php
if (isset($FIN))
{
echo $FIN;
}
?>" maxlength="8" size="6" type="time">
<!------------------ Choix CONSTAT ------------------>
<br><br><br>
<?php
$sql = "SELECT DESIGNATION
FROM CONSTAT";
$req = odbc_exec($conn,$sql) or die('Erreur SQL : <br />'.$sql);
echo '<select name="CONSTAT" >';
while($data = odbc_fetch_array($req))
{
echo "\n <option value=\"".$data["DESIGNATION"]."\" selected>".$data["DESIGNATION"]."</option>\n\n";
}
if (isset($CONSTAT))
{
echo "<option value='$CONSTAT' selected='selected'>$CONSTAT</option>";
echo '</select>';
}
else
{
echo "<option value='constat' selected='selected'>Constat</option>";
echo '</select>';
}
?>
<!------------------ Choix DEMANDE ------------------>
<br><br>
<?php
$sql = "SELECT DESIGNATION
FROM DEMANDE";
$req = odbc_exec($conn,$sql) or die('Erreur SQL : <br />'.$sql);
echo '<select name="DEMANDE" >';
while($data = odbc_fetch_array($req))
{
echo "\n <option value=\"".$data["DESIGNATION"]."\" selected>".$data["DESIGNATION"]."</option>\n\n";
}
if (isset($DEMANDE))
{
echo "<option value='$DEMANDE' selected='selected'>$DEMANDE</option>";
echo '</select>';
}
else
{
echo "<option value='demande' selected='selected'>Demande</option>";
echo '</select>';
}
?>
<!------------------ Choix CAUSE ------------------>
<br><br>
<?php
$sql = "SELECT DESIGNATION
FROM CAUSE";
$req = odbc_exec($conn,$sql) or die('Erreur SQL : <br />'.$sql);
echo '<select name="CAUSE" >';
while($data = odbc_fetch_array($req))
{
echo "\n <option value=\"".$data["DESIGNATION"]."\" selected>".$data["DESIGNATION"]."</option>\n\n";
}
if (isset($CAUSE))
{
echo "<option value='$CAUSE' selected='selected'>$CAUSE</option>";
echo '</select>';
}
else
{
echo "<option value='cause' selected='selected'>Cause</option>";
echo '</select>';
}
?>
<!------------------ Saisie complement d'information------------------>
<br><br><br><br>
Complément d'information :
<input name="COMPLEMENT" value="<?php
if (isset($INFO))
{
echo $INFO;
}
?>" maxlength="50" size="50" type="text">
<!------------------ Choix IMPUTATION ------------------>
<br><br><br>
<?php
$sql = "SELECT DESIGNATION
FROM IMPUTATION";
$req = odbc_exec($conn,$sql) or die('Erreur SQL : <br />'.$sql);
echo '<select name="IMPUTATION" >';
while($data = odbc_fetch_array($req))
{
echo "\n <option value=\"".$data["DESIGNATION"]."\" selected>".$data["DESIGNATION"]."</option>\n\n";
}
if (isset($IMPUTATION))
{
echo "<option value='$IMPUTATION' selected='selected'>$IMPUTATION</option>";
echo '</select>';
}
else
{
echo "<option value='imputation' selected='selected'>Imputation</option>";
echo '</select>';
}
/*------------------ Boutton ------------------*/
echo "<br><br><br><br>";
echo "<div style=\"text-align: center;\">";
echo "<input value=\"Valider\" onclick=\"self.close()\" name=\"Modif\" type=\"submit\">";
}
/*------------------ Sinon message d'erreur ------------------*/
else
{
echo"<br><br><br>";
echo "<center>Vous n'avez pas coché d'arrêt chaînes</center>";
}
?>
