select option multiple et mysql
Bonsoir
svp comment inserer des valeurs dans mysql a partir d'une select option dans le code php
ma table dans mysql :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| --
-- Table structure for table `etuditable`
--
CREATE TABLE IF NOT EXISTS `etuditable` (
`id_etu` int(11) NOT NULL AUTO_INCREMENT,
`id_users` int(11) NOT NULL,
`cne` int(10) NOT NULL,
`module1` varchar(50) NOT NULL,
`module2` varchar(50) NOT NULL,
`module3` varchar(50) NOT NULL,
`module4` varchar(50) NOT NULL,
`module5` varchar(50) NOT NULL,
`module6` varchar(50) NOT NULL,
PRIMARY KEY (`id_etu`),
UNIQUE KEY `id_users` (`id_users`),
UNIQUE KEY `cne` (`cne`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; |
et mon formulaire pour selectioner les module :
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
25
26
27
28
29
30
31
32
33
34
35
|
<form method="POST" class="form-signin" action="register1.php">
<?php if($_SESSION['statut']=="etudiant"){ ?>
<input type="text" name="cne" placeholder="CNE" class="form-control" required/>
<?php if (isset($cne_error)) echo $cne_error; if (isset($cne_er1)) echo $cne_er1; ?>
<Select id="semestre" class="form-control" name="module" required>
<option value="" disabled selected hidden>---Semestre---</option>
<option value="aut">Semestre d'automne</option>
<option value="prin">Semestre de printemps</option>
</Select>
<div id="aut" class="sem" style="display:none">
<select class="form-control" name="module[]" multiple required>
<option value="" disabled selected hidden>Please Choose...</option>
<?php
$result=$bd->query("SELECT nom_cat FROM category WHERE semestre=1 ORDER BY nom_cat ASC;");
while($row = $result->fetch(PDO::FETCH_ASSOC)){
echo "<option value='".$row['nom_cat']."'>".$row['nom_cat']."</option>";
}
?>
</select>
</div>
<div id="prin" class="sem" style="display:none" >
<select class="form-control" name="module[]" multiple required>
<option value="" disabled selected hidden>Please Choose...</option>
<?php
$result=$bd->query("SELECT nom_cat FROM category WHERE semestre=2 ORDER BY nom_cat ASC;");
while($row = $result->fetch(PDO::FETCH_ASSOC)){
echo "<option value='".$row['nom_cat']."'>".$row['nom_cat']."</option>";
}
?>
</select>
</div>
<?php } ?>
<input type="submit" name="inscri" value="Inscrire" class="btn btn-success" style="width:100%;">
</form> |
mon prblm est comment recupere les valeurs choisi dans "select option" et insere dans la table
