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> |
