[(#REM) Contenu principal : contenu de l'article ] close(); } function get_titreSem($ids) { $link= mysqli_connect('db652428842.db.1and1.com','dbo652428842','ifr4800PHP','db652428842'); $query="SELECT * FROM extra_seminaires WHERE id = '".$ids."'"; $result = mysqli_query($link,$query); $myrow = mysqli_fetch_array($result); return html_entity_decode($myrow['TITRE']); $link->close(); } $dblink= mysqli_connect('db652428842.db.1and1.com','dbo652428842','ifr4800PHP','db652428842'); $query="SELECT * FROM extra_seminaires WHERE actif > 0 AND DATE_SEM >='".date('Y-m-d')."' AND id >1 ORDER BY DATE_SEM DESC"; $result = mysqli_query($dblink,$query); //print 'query '.$query; echo "

Prochaines conférences de l'UPCHO :

"; echo ""; while ($myrow = mysqli_fetch_array($result)) { if (! inscrit($_SESSION['ID'],$myrow['id'])) { echo ""; echo ""; echo ""; echo ""; } } echo "

	".utf8_encode(get_titreSem($myrow['id']))." (".substr($myrow['DUREE'],0,5).")		".($myrow['DATE_SEM'])."

---

"; /*-------------inscription aux prochaines conférences-------------*/ $query="SELECT COUNT(ids) AS NUMB FROM extra_inscrits WHERE idm ='".$_SESSION['ID']."' AND DATE_SEM >= '".date('Y-m-d')."'"; $result = mysqli_query($dblink,$query); $myrow = mysqli_fetch_array($result); $var= $myrow['NUMB']; if ($var >0) { print "

Vous êtes inscrit aux conférences:

"; $query="SELECT * FROM extra_inscrits WHERE idm ='".$_SESSION['ID']."' AND DATE_SEM >= '".date('Y-m-d')."'"; $result = mysqli_query($dblink,$query); echo ""; while ($myrow = mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; } echo "

	".utf8_encode(get_titreSem($myrow['ids']))." (".substr($myrow['DUREE'],0,5).")	".($myrow['DATE_SEM'])."

---

"; } else { print "

Vous n'êtes pas inscrit aux prochaines conférences

---

"; } //-----------fin -------inscription aux prochaines conférences--- //------------conférences déja suivies------------- $query="SELECT COUNT(ids) AS NUMB FROM extra_inscrits WHERE idm ='".$_SESSION['ID']."' AND PRESENT > 0"; $result = mysqli_query($dblink,$query); $myrow = mysqli_fetch_array($result); $var= $myrow['NUMB']; if ($var >0) { print "

Vous avez suivi les conférences:

"; $query="SELECT * FROM extra_inscrits WHERE idm ='".$_SESSION['ID']."' AND PRESENT > '0' ORDER BY DATE_SEM DESC"; $result = mysqli_query($dblink,$query); echo ""; while ($myrow = mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; } echo "

	".utf8_encode(get_titreSem($myrow['ids'])) ." (".substr($myrow['DUREE'],0,5).")	".($myrow['DATE_SEM'])."

"; } else { print "

Vous n'avez suivi aucune conférence pour cette année académique.

"; } $dblink->close(); ?>