This repository has been archived by the owner on Sep 6, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
CV.php
93 lines (63 loc) · 3.01 KB
/
CV.php
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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php
session_start();
include('connexion_BDD.php');
include_once('cookieconnect.php');
require("tpl/Smarty.class.php");
$Smarty = new Smarty;
if (isset($_SESSION['ID_etu'])) {
$reponse = $bdd->prepare('SELECT * FROM etudiant WHERE ID_etu= ?');
$reponse->execute(array($_SESSION['ID_etu']));
$donnees = $reponse->fetch();
$Smarty->assign('nom',$donnees['nom']);
$Smarty->assign('prenom',$donnees['prenom']);
$Smarty->assign('email',$donnees['mail']);
$reponse = $bdd->prepare('SELECT * FROM contact WHERE ID_etu= ?');
$reponse->execute(array($_SESSION['ID_etu']));
$donnees = $reponse->fetch();
$Smarty->assign('adresse',$donnees['adresse']);
$Smarty->assign('telephone_fixe',$donnees['fixe']);
$Smarty->assign('telephone_portable',$donnees['portable']);
$reponse = $bdd->prepare('SELECT * FROM competences WHERE ID_etu= ?');
$reponse->execute(array($_SESSION['ID_etu']));
$donnees = $reponse->fetch();
$Smarty->assign('langues1',$donnees['langues1']);
$Smarty->assign('langues2',$donnees['langues2']);
$Smarty->assign('langues3',$donnees['langues3']);
$reponse = $bdd->prepare('SELECT * FROM associatif WHERE ID_etu= ?');
$reponse->execute(array($_SESSION['ID_etu']));
$donnees = $reponse->fetch();
$Smarty->assign('association',$donnees['association']);
$reponse = $bdd->prepare('SELECT * FROM divers WHERE ID_etu= ?');
$reponse->execute(array($_SESSION['ID_etu']));
$donnees = $reponse->fetch();
$Smarty->assign('divers',$donnees['divers']);
$reponse = $bdd->prepare('SELECT * FROM formations WHERE ID_etu= ?');
$reponse->execute(array($_SESSION['ID_etu']));
$donnees = $reponse->fetch();
$Smarty->assign('anneeform1',$donnees['annee_diplome1']);
$Smarty->assign('intituleform1',$donnees['intitule_formation1']);
$Smarty->assign('description1',$donnees['description_form1']);
$Smarty->assign('univ1',$donnees['universite1']);
$Smarty->assign('mention1',$donnees['mention1']);
$Smarty->assign('anneeform2',$donnees['annee_diplome2']);
$Smarty->assign('intituleform2',$donnees['intitule_formation2']);
$Smarty->assign('description2',$donnees['description_form2']);
$Smarty->assign('univ2',$donnees['universite2']);
$Smarty->assign('mention2',$donnees['mention2']);
$Smarty->assign('anneeform3',$donnees['annee_diplome3']);
$Smarty->assign('intituleform3',$donnees['intitule_formation3']);
$Smarty->assign('description3',$donnees['description_form3']);
$Smarty->assign('univ3',$donnees['universite3']);
$Smarty->assign('mention3',$donnees['mention3']);
$reponse = $bdd->prepare('SELECT * FROM experiences WHERE ID_etu= ?');
$reponse->execute(array($_SESSION['ID_etu']));
$donnees = $reponse->fetch();
$Smarty->assign('anneexp1',$donnees['annee_xp1']);
$Smarty->assign('description1',$donnees['description1']);
$Smarty->assign('anneexp2',$donnees['annee_xp2']);
$Smarty->assign('description2',$donnees['description2']);
$Smarty->assign('anneexp3',$donnees['annee_xp3']);
$Smarty->assign('description3',$donnees['description3']);
$Smarty->display('CV.tpl');
}
?>