Gestion Membre

$(document).ready(function(){
							<?php if (isset ($_REQUEST['action']) AND  $_REQUEST['action'] == 'edit') { ?>//Affiche formulaire pour modification
							$('#formulaire input,select').attr('disabled', '');
							$('#formulaire input[name=action]').attr('value','modifier');
							<?php  } ?>
							<?php if (isset ($_GET['voir']) AND  $_GET['voir'] == 'fiche') { ?>//Affiche formulaire pour voir sans modification
							$('#formulaire input,select').attr('disabled', 'disabled');//les champs en grisés
							$('#formulaire input[name=action]').attr('value', '');							
							$('#formulaire input[type=submit]').hide();//cache l'input de type submit
							$('#formulaire input[type=button]').hide();//cache l'input de type button
							$('#formulaire img[type=image]').hide();//cache l'image de type image
							<?php  } ?>

			$sql = ("SELECT tba.*, tbs.nom_statut, GROUP_CONCAT(tbg.nom_gestion SEPARATOR ', ') nom_gestion
FROM tb_adherent tba
    LEFT OUTER JOIN tb_adherent_statut tbas
        ON tbas.rid_adherent = tba.id_adherent
	LEFT OUTER JOIN tb_statut tbs
        ON tbs.id_statut = tbas.rid_statut

	LEFT OUTER JOIN tb_adherent_gestion tbag
        ON tbag.rid_adherent = tba.id_adherent
	LEFT OUTER JOIN tb_gestion tbg
        ON tbg.id_gestion = tbag.rid_gestion
					WHERE id_adherent='" . $PARAM['ID_ADHERENT'] . "'
					ORDER BY nom ASC");			

$PARAM

'RID_GESTION' => isset($_POST['rid_gestion'])?$_POST['rid_gestion']:array()
 /* ... */

$PARAM['RID_GESTION']

foreach($PARAM['RID_GESTION'] as $rid_gestion)
{
   $sql = "UPDATE tb_adherent_gestion SET rid_adherent=:rid_adherent, id_gestion=:rid_gestion";
   $requete = $bdd->prepare($sql);
   $requete->bindParam(':rid_adherent', $PARAM['RID_ADHERENT']);
   $requete->bindParam(':rid_gestion', $rid_gestion);		
   $requete->execute();
}

$PARAM['RID_GESTION']

$PARAM['NOM_GESTION']

($PARAM['RID_GESTION']

($PARAM['NOM_GESTION']

		'RID_ADHERENT'				=> isset($_POST['rid_adherent']) ? $_POST['rid_adherent'] : '',
		'RID_GESTION'				=> isset($_POST['rid_gestion']) ? $_POST['rid_gestion'] :array(),

		'ID_GESTION'				=> isset($_REQUEST['id_gestion']) ? $_REQUEST['id_gestion'] : '',
		'NOM_GESTION'				=> isset($_POST['nom_gestion']) ? $_POST['nom_gestion'] : '',

foreach($PARAM['RID_GESTION'] as $rid_gestion)
{
   $sql = "UPDATE tb_adherent_gestion SET rid_adherent=:rid_adherent, id_gestion=:rid_gestion";
   $requete = $bdd->prepare($sql);
   $requete->bindParam(':rid_adherent', $PARAM['RID_ADHERENT']);
   $requete->bindParam(':rid_gestion', $rid_gestion);		
   $requete->execute();
}

		case 'edit':			
			$sql = ("SELECT tba.*, tbs.nom_statut,
					GROUP_CONCAT(tbg.nom_gestion SEPARATOR ', ') nom_gestion
					FROM tb_adherent tba
					LEFT OUTER JOIN tb_adherent_statut tbas
					ON tbas.rid_adherent = tba.id_adherent
					LEFT OUTER JOIN tb_statut tbs
					ON tbs.id_statut = tbas.rid_statut
					LEFT OUTER JOIN tb_adherent_gestion tbag
					ON tbag.rid_adherent = tba.id_adherent
					LEFT OUTER JOIN tb_gestion tbg
					ON tbg.id_gestion = tbag.rid_gestion
					WHERE id_adherent='" . $PARAM['ID_ADHERENT'] . "'
					ORDER BY nom ASC");	

	$sql = "SELECT
		tb_gestion.nom_gestion,
		tb_gestion.id_gestion,
		NOT(tb_adherent_gestion.rid_adherent IS NULL) checked
		FROM tb_gestion
	    LEFT JOIN tb_adherent_gestion
        ON tb_adherent_gestion.rid_gestion = tb_gestion.id_gestion
        AND tb_adherent_gestion.rid_adherent ='".$PARAM['ID_ADHERENT']."'
		ORDER BY tb_gestion.id_gestion";
	$requete1 = $bdd->prepare($sql);							
	$requete1->execute();
		while ($donnees = $requete1->fetch(PDO::FETCH_ASSOC))
		{
			echo "<tr>";
			echo "<td width='5%'><input type='checkbox' name='nom_gestion[]' value='".$donnees['id_gestion']."'". ($donnees['checked'] ? ' checked="checked"':'') . "></td>";
			echo "<td width='20%'>".$donnees['nom_gestion']."</td>";

			//echo"<tr>";
			//echo"<td width='20%'><input id='checkbox_gestion' class='css-checkbox' type='checkbox' name='nom_gestion[]' value='".$donnees['id_gestion']."'". ($donnees['checked'] ? ' checked="checked"':'') . ">";
			//echo"<label for='checkbox_gestion' class='css-label'>".$donnees['nom_gestion']."</label></td>";
		}
	$requete1->closeCursor();

$sql = "DELETE FROM tb_adherent_gestion WHERE rid_adherent = '" . $PARAM['ID_ADHERENT'] . "'";
// execute ici la requête contenu dans $sql

foreach($PARAM['NOM_GESTION'] as $rid_gestion)
{
   $sql = "INSERT ..."; // requête d'insertion des droits de l'utilisateur
   $requete = $bdd->prepare($sql);
   $requete->bindParam(':rid_adherent', $PARAM['RID_ADHERENT']);
   $requete->bindParam(':rid_gestion', $rid_gestion);		
   $requete->execute();
}

'NOM_GESTION' => isset($_POST['nom_gestion']) ? $_POST['nom_gestion'] : array()

$sql = "DELETE FROM tb_adherent_gestion WHERE rid_adherent = '" . $PARAM['ID_ADHERENT'] . "'";
// execute ici la requête contenu dans $sql

foreach($PARAM['NOM_GESTION'] as $rid_gestion)
{
   $sql = 'INSERT INTO tb_adherent_gestion (rid_adherent, rid_gestion) VALUES ("'.$PARAM['ID_ADHERENT'].'", "'.$rid_gestion.'")';
   $requete = $bdd->prepare($sql);
   $requete->execute();
}