j ai une page de formulaire qui se compose de 3 parties (en fait plus, mais le principe est toujours le meme donc je pars sur ces 3 elements)
- 1 deux selects
- 2 une entree de donnee avec insertion des donnees dans la base quand on presse sur le bouton ajouter qui s affiche apres apres envoi
- 3 une deuxieme entree du meme type que la precedente
1 lorsque j ajoute les donnees 2 pour les entrer dans la table et les afficher, la selection des select ne se reaffiche pas.
2 comment faire pour entrer en dernier lieu dans la table les valeurs des selects ?
je vous mets le code allege ci dessous, si quelqu un voit comment faire...
<?php
session_start();
include ("connexion/mysql.inc.php");
$id=$_SESSION['id'];
if(isset($_POST['conversational'])) $conversational=$_POST['conversational']; else $conversational="";
$_SESSION['conversational'] = (isset($_POST['conversational'])) ? $_POST['conversational'] : "";
if(isset($_POST['written'])) $written=$_POST['written']; else $written="";
$_SESSION['written'] = (isset($_POST['written'])) ? $_POST['written'] : "";
if(isset($_POST['testname'])) $testname=$_POST['testname']; else $testname="";
if(isset($_POST['testscore'])) $testscore=$_POST['testscore']; else $testscore="";
if(isset($_POST['testmonth'])) $testmonth=$_POST['testmonth']; else $testmonth="";
if(isset($_POST['testyear'])) $testyear=$_POST['testyear']; else $testyear="";
if(isset($_POST['otherlang'])) $otherlang=$_POST['otherlang']; else $otherlang="";
if(isset($_POST['otherlanglevel'])) $otherlanglevel=$_POST['otherlanglevel']; else $otherlanglevel="";
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="css/style.css" rel="stylesheet" title="style" type="text/css"/>
<title>staff data base </title>
</head>
<body>
<h1>anglais</h1>
<p>
(1) oral
<form name="eng" method="post" action="lang.php">
<select name="conversational">
<option value="<?php echo $_SESSION['conversational']; ?>" selected="selected"><?php echo $_SESSION['conversational']; ?></option>
<option value="je suis une bille">je suis une bille</option>
<option value="ca peut aller">ca peut aller</option>
</select>
</p>
<p>
(2) comphrehension ecrite
<select name="written" >
<option value="<?php echo $written; ?>" selected="selected"><?php echo $written; ?></option>
<option value="je suis une bille">je suis une bille</option>
<option value="ca peut aller">ca peut aller</option>
</select>
</p>
<p>
(3) test
<input type="text" name="testname" value="<?php echo $testname;?>" size="20" style="ime-mode: active;"> score:<input type="text" name="testscore" value="<?php echo $testscore;?>" size="10" style="ime-mode: disabled;">
annee d obtention :
<select name="testyear">
<option value="<?php echo $testyear; ?>" selected="selected"><?php echo $testyear; ?></option>
<option value="1930">1930</option>
<option value="2006">2006</option>
</select>
<input type="submit" name="nom" value="ajouter">
<input type="hidden" name="eng">
</form>
<?php
include ("connexion/mysql.inc.php");
if (isset($_POST['eng']))
{
// on insère les informations du formulaire dans la table
$sql = "INSERT INTO VALUES";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
echo "<meta http-equiv='refresh' content='0; url=lang.php? ".session_id()."'>";
}
//on affiche les resultats rentrees dans la table des que le bouton submit est appuye
$sql2 = mysql_query("SELECT * FROM WHERE id=$id ORDER BY DESC");
$total = mysql_num_rows($sql2);
if ($total >0)
{
echo "<form name=\"delete\" method=\"post\" action=\"lang.php\">";
echo"<tr>";
echo"<td colspan=\"6\" class=\"submessage\">";
echo" ";
echo" </td>";
echo" </tr>";
echo"<tr>";
echo"<td class=\"header\" align=\"center\"></td>";
echo" <td class=\"header\" align=\"center\"></td>";
echo" <td class=\"header\" align=\"center\" width=\"80%\"></td>";
echo" <td class=\"header\" align=\"center\" width=\"10%\"><br/></td>";
echo" <td class=\"header\" align=\"center\" width=\"10%\"><br/></td>";
echo"</tr>";
while ($donnees = mysql_fetch_array($sql2) )
{
echo" <tr>";
echo" <td class=\"input1\">";
echo $donnees[''];
echo " </td>";
echo" <td class=\"input1\">";
echo $donnees[''];
echo" </td>";
echo" <td class=\"input1\">";
echo $donnees[''];
echo" </td>";
echo" <td class=\"input1\">";
echo $donnees[''];
echo" </td>";
echo" <td class=\"input1\">";
echo $donnees[''];
echo" </td>";
echo" <td class=\"input1\" align=\"center\">";
echo" <input type=\"checkbox\" name=\"aeffacer[]\" value=\"".$donnees['auto']."\" >";
echo" </td>";
echo" </tr>";
}
$effacer = (isset($_POST['aeffacer'])) ? $_POST['aeffacer']:null;
if (!empty($effacer))
{
foreach($effacer as $valeur)
{
$sql2 = "DELETE FROM WHERE auto=".$valeur."";
$sql2=mysql_query($sql2);
}
echo "<meta http-equiv='refresh' content='0; url=lang.php? ".session_id()."'>";
}
echo"<tr>";
echo"<td align=\"center\"></td>";
echo" <td align=\"center\"></td>";
echo" <td align=\"center\" width=\"80%\"></td>";
echo" <td align=\"center\" width=\"10%\"><br/></td>";
echo" <td align=\"center\" width=\"10%\"><br/></td>";
echo" <td align=\"center\">";
echo" <input type=\"submit\" name=\"nom\" value=\"削除\">";
echo" </td>";
echo"</form>";
echo" </tr>";
}
?>
<h1>autre langues</h1>
<form name="autrelang" method="post" action="Education.php">
langue :<input type="text" name="otherlang" value="<?php echo $otherlang; ?>" size="20"style="ime-mode: active;">
niveau:
<select name="otherlanglevel">
<option value="<?php echo $otherlanglevel; ?>" selected="selected"><?php echo $otherlanglevel; ?></option>
<option value="debutant" >debutant</option>
<option value="bilingue">bilingue</option>
</select>
<input type="submit" name="nom" value="ajouter">
<input type="hidden" name="autrelang">
</form>
<p>
<form name="confirmation" method="post" action="Education.php">
<input type="submit" name="nom" value="envoyer">
<input type="hidden" name="final">
</form></p>
</body>
</html>
)
