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 72 73 74 75 76 77
| /construction de la req SQL
$req_sql2 ='SELECT DATE_FORMAT(date,\'%d/%m/%Y\') date,nom, prenom, DATE_FORMAT(date_naiss,\'%d/%m/%Y\') date_naiss, adresse, mail, niveau, tel_port, tel_pro, tel_fixe, dossier, remun_souhait, commentaire, cooptation, detail_port, DATE_FORMAT(date_rdv,\'%d/%m/%Y\') date_rdv, DATE_FORMAT(date_rdv2,\'%d/%m/%Y\') date_rdv2, DATE_FORMAT(date_rdv3,\'%d/%m/%Y\') date_rdv3, com1,com2,com3,ville_residence, d.denomination dpt1, t.denomination dpt2, e.denomination etat, ville_souh1, ville_souh2, x.denomination exp_pro, p.denomination poste, g.denomination delegation, f.denomination portefeuille, a.denomination adressea, b.denomination adressea2,i.denomination adressea3,o.id profil1,q.id profil2, r.id profil3, s.denomination suivis, com_suivi, profil, compte_rendu
FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN dpt t
ON (c.dpt_souhait2=t.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN exp_pro x
ON (c.id_exp_pro=x.id)
JOIN poste p
ON (c.id_poste=p.id)
JOIN delegation g
ON (c.id_delegation_ratache=g.id)
JOIN portefeuille f
ON (c.id_portefeuille=f.id)
JOIN adressea a
ON (c.id_adressea1=a.id)
JOIN adressea b
ON (c.id_adressea2=b.id)
JOIN adressea i
ON (c.id_adressea3=i.id)
JOIN profil o
ON (c.profil1=o.id)
JOIN profil q
ON (c.profil2=q.id)
JOIN profil r
ON (c.profil3=r.id)
JOIN suivis s
ON (c.id_suivis=s.id)
where nom=\''.$nom_candidat.'\'';
//execution de la requete
$result = mysql_query($req_sql2) or die(mysql_error());
//récupération des valeurs ligne par ligne (pour chaque utlisateur)
while($data = mysql_fetch_array($result))
{
?>
<form action="modification.php" method="POST">
<?php
//récupération des variables
?>
<table class="petit_tableau" style="width :600px;">
<tr class ="table_titre">
<th width="20%"><span class="Style2">Réception dossier</span></th>
</tr>
<tr>
<?php
echo '<td ><input type="text" name="date[]" style="width :100px;" value="'.$data['date'].'"align="center"/></td>';
?>
</tr>
<tr>
<!--nom prenom datenaiss et mail a enregistrer-->
<th width="20%"><span class="Style2">Nom</span></th>
<th width="20%"><span class="Style2">Prénom</span></th>
</tr>
<tr>
<?php
echo '<td><input type="text" name="nom[]" style="width :100px;" value="'.$data['nom'].'"align="center"/></td>
<td><input type="text" name="prenom[]" style="width :100px;" value="'.$data['prenom'].'" align="center"/></td>';
?>
</tr>
<tr>
<th width="20%"><span class="Style2">Date de naissance</span></th>
<th width="20%"><span class="Style2">Mail</span></th>
</tr>
<tr>
<?php
echo '<td><input type="text" name="date_naiss[]" style="width :100px;" value="'.$data['date_naiss'].'" align="center"/></td>';
echo '<td><input type="text" name="mail[]" style="width :100px;" value="'.$data['mail'].'" align="center"/></td>';
?>
</tr> |
Partager