Bonjour,
j'ai des checkbox alimenter par une table, et je veux quand je coche le checkbox et je click sur le boutton resultat ça affiche le nombre et le total dans une tableau.
voici mon code
<html>
<head>
<script src="jquery.js"></script>
</head>
<body>
</br><h3>Liste des regions</h3><br>
<form action="recupmateriel_elevage.php" name="form" method="post" >
<select name="region" id="id_region" onchange='tester();'>
<OPTION>---Choisissez une region---</OPTION>";
<?php
include('connectBDD.php');
$reponse = $bdd->query('SELECT * FROM region');
while ($donnees = $reponse->fetch())
{
echo'<option value="'.$donnees['id_region'].'">'.$donnees['Nom_region'].'</option>';
}
?>
</select>
<div class="district">
</div>
<br><h3>Liste des materiels</h3><br>
<h4>Gros materiels</h4><br>
<?php
include('connectBDD.php');
$reponse = $bdd->query('SELECT * FROM materiels where Types="gros" group by Nom');
while ($elevage1 = $reponse->fetch())
{
echo'<input type="checkbox" name="gros[]" value="'.$elevage1['Nom'].'" checked>'.$elevage1['Nom'].'<br>';
}
?>
<br><h4> Petit materiels</h4><br>
<?php
include('connectBDD.php');
$reponse = $bdd->query('SELECT * FROM materiels where Types="petit" group by Nom');
while ($elevage2 = $reponse->fetch())
{
echo'<input type="checkbox" name="petit[]" value="'.$elevage2['Nom'].'" checked>'.$elevage2['Nom'].'<br>';
}
?>
</select>
<br><input type="submit" name="valider" value="Resultat"/>
</form>
</body>
<script>
function tester(){
var select = document.getElementById('id_region');
var valeur= select.options[select.selectedIndex].value;
if(valeur==0){
$reponse = $bdd->query('SELECT * FROM materiels where Types="gros" group by Nom');
while ($elevage1 = $reponse->fetch())
{
echo'<td><center>'.$elevage1['Nom'].'</center></td>';
}
}
}
if(isset($_POST['petit'])){
foreach($_POST['petit'] as $elevage2){
echo'<tr><th>'.$elevage2.' </th>';
foreach($_POST['district'] as $district){
$id=$district;
$requete=$bdd->query('SELECT * FROM materiels where id_district='.$id.' and Nom=\''.$elevage2.'\'');
while ($elevage=$requete->fetch())
{
