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
| <section id="contenu">
<?php
if($_SESSION['ident']=='etudiant')
{
$reponse=$bdd->prepare('SELECT nom_class FROM etudiant WHERE num_pers=:num_pers');
$reponse->execute(array('num_pers'=>$_SESSION['num_pers'])) OR
die(print_r($bdd->errorInfo()));
$classe=$reponse->fetch();
$reponse->closeCursor();
if($_SESSION['ident']=='etudiant' AND $_GET['type']=='collegues')
{
$reponse=$bdd->prepare('SELECT nom,prenom,date_naiss,e_mail FROM personne,etudiant WHERE
personne.num_pers=etudiant.num_pers AND
nom_class=:nom_class AND
personne.num_pers!=:num_pers');
$reponse->execute(array('nom_class'=>$classe['nom_class'], 'num_pers'=>$_SESSION['num_pers'])) OR
die(print_r($bdd->errorInfo()));
}
elseif($_SESSION['ident']=='etudiant' AND $_GET['type']=='enseignants')
{
$reponse=$bdd->prepare('SELECT nom,prenom,date_naiss,spec_ens,e_mail FROM personne,enseignant,enseigner WHERE personne.num_pers=enseignant.num_pers AND
personne.num_pers=enseigner.num_pers AND
nom_class=:nom_class');
$reponse->execute(array('nom_class'=>$classe['nom_class'])) OR
die(print_r($bdd->errorInfo()));
}
elseif($_SESSION['ident']=='enseignant')
{
if($_SESSION['ident']=='enseignant' AND $_GET['type']=='etudiants')
{
$reponse=$bdd->prepare('SELECT nom,prenom,date_naiss,e_mail FROM personne,etudiant WHERE
personne.num_pers=etudiant.num_pers AND
nom_class=:nom_class');
$reponse->execute(array('nom_class'=>$_GET['classe'])) OR
die(print_r($bdd->errorInfo()));
}
elseif($_SESSION['ident']=='enseignant' AND $_GET['type']=='collegues')
{
$reponse=$bdd->prepare('SELECT nom,prenom,date_naiss,spec_ens,e_mail FROM personne,enseigner,enseignant WHERE
personne.num_pers=enseignant.num_pers AND
personne.num_pers=enseigner.num_pers AND
personne.num_pers!=:num_pers AND
nom_class=:nom_class');
$reponse->execute(array('nom_class'=>$_GET['classe'], 'num_pers'=>$_SESSION['num_pers'])) OR
die(print_r($bdd->errorInfo()));
}
}
?>
<table>
<thead>
<tr>
<th>Nom</th>
<th>Prenom</th>
<th>Date naissance</th>
<th>E-mail</th>
<?php
if($_GET['type']=='enseignants' OR ($_SESSION['ident']=='enseignant' AND $_GET['type']=='collegues'))
echo '<th>Matiére</th>';
?>
</tr>
</thead>
<tbody>
<?php
while($donnees=$reponse->fetch())
{
echo '<tr><td>'.strip_tags($donnees['nom']).'</td>
<td>'.strip_tags($donnees['prenom']).'</td>
<td>'.strip_tags($donnees['date_naiss']).'</td>
<td><a href="mailto:'.strip_tags($donnees['e_mail']).'">'.strip_tags($donnees['e_mail']).'</td>';
if($_GET['type']=='enseignants' OR ($_SESSION['ident']=='enseignant' AND $_GET['type']=='collegues'))
echo '<td>'.strip_tags($donnees['spec_ens']).'</td>'
?>
</tr>
<?php
}
$reponse->closeCursor();
?>
</tbody>
</table>
</section> |
Partager