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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
|
<fieldset>
<legend>Validation convocations:</legend>
<form method="post" name="validation_convocation_form" action="admin.php?option=validation_convocation">
<table border="1" name="tableau_valid_convok">
<tr>
<?php
$categorie = $_SESSION['categorie'];
$req_valid_convok = "SELECT * FROM calendrier cal
INNER JOIN convocation conv ON cal.id_calendrier = conv.id_match_convok
LEFT JOIN donnees_perso d_p ON d_p.id = conv.joueurs
WHERE categorie_convok = '".$categorie."'";
$query_valid_convok = mysql_query($req_valid_convok);
$tableau_id = array();
while($valid = mysql_fetch_array($query_valid_convok))
{
$id_joueur = $valid['joueurs'];
$tableau_id[] = $id_joueur ;
echo "<td>".$id_joueur."</td>";
echo "<td>".$valid['nom']." ".$valid['prenom']."</td>";
echo "<td>";
echo "<select name='".$id_joueur."/oui_non'>";
echo "<option value='1'>oui</option>";
echo "<option value='0'>non</option>";
echo "</select>";
echo "</td>";
echo "</tr>";
}
?>
</td>
</tr>
<tr>
<td colspan=3>
<input type='submit' value='Validez' name='valid_convok'>
</td>
</tr>
</table>
</form>
<?php
if(!empty($_POST['valid_convok']))
{
$categorie_lettre = substr($_SESSION['categorie'], -1);
$req_match_joue = "INSERT INTO $table_8 VALUES";
for($i=0; $i<sizeof($tableau_id) ;$i++)
{
$oui_non[$i] = $_POST[$tableau_id[$i].'/oui_non'];
$tableau = array($tableau_id[$i]=>$oui_non[$i]);
foreach($tableau as $value=>$key)
{
$req_match_joue .= "('', '".$value."', '".$categorie_lettre."', 0, 0, '".$key."', 0, 0, NOW())
ON DUPLICATE KEY UPDATE nbr_match_joué = nbr_match_joué + ".$key." ,";
}
}
$query_match_joue = mysql_query($req_match_joue) or die (mysql_error()); |
Partager