recuperer champs et insert en php
bonjour,
J'aimerais obtenir votre aide pour la recuperation d'un formulaire checkbox et inséré toutes ces valeurs cochés dans la base sql.
le formulaire:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<input type="checkbox" name="episode" value="The Mystery of the Mummy" />The Mystery of the Mummy
</p>
<p>
<input type="checkbox" name="episode" value="The Silver Earring" />The Silver Earring
</p>
<p>
<input type="checkbox" name="episode" value="The Awakened" />The Awakened
</p>
<p>
<input type="checkbox" name="episode" value="Sherlock Holmes versus Arsene Lupin" />Sherlock Holmes versus Arsene Lupin
</p>
<p>
<input type="checkbox" name="episode" value="The Awakened' (remastered edition)" />The Awakened' (remastered edition)
</p>
<p>
<input type="checkbox" name="episode" value="None" />None |
insert into:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
if(isset($_POST['name']) and isset($_POST['birth']) and isset($_POST['mail']) and isset($_POST['configuration'])and isset($_POST['internet']) and isset($_POST['last']) and isset($_POST['episode']) and isset ($_POST['finished']) and isset($_POST['adventure']) and isset($_POST['adventure_game']) and isset($_POST['beta_test'] ) )
{
$resultats = mysql_real_escape_string($_POST["name"]);
$resultats1 = mysql_real_escape_string($_POST["birth"]);
$resultats2 = mysql_real_escape_string($_POST["mail"]);
$resultats3 = mysql_real_escape_string($_POST["configuration"]);
$resultats4 = mysql_real_escape_string($_POST["internet"]);
$resultats5 = mysql_real_escape_string($_POST["last"]);
$resultats6 = mysql_real_escape_string($_POST["episode"]);
$resultats7 = mysql_real_escape_string($_POST["finished"]);
$resultats8 = mysql_real_escape_string($_POST["adventure"]);
$resultats9 = mysql_real_escape_string($_POST["adventure_game"]);
$resultats10 = mysql_real_escape_string($_POST["beta_test"]);
$sql = "INSERT INTO formulaire_sherlock (name, birth, mail, configuration, internet, last, episode, finished,adventure, adventure_game, beta_test) VALUES ('$resultats', '$resultats1', '$resultats2','$resultats3', '$resultats4', '$resultats5', '$resultats6', '$resultats7', '$resultats8', '$resultats9','$resultats10')";
mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
} |
toujours le dernier resultat qui s'inserer, comment faire pour recuperer toutes les valeurs coché et inserer please
merci beaucoup
