ÿØÿà JFIF ` ` ÿþxØ
| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/calendar/ |
Upload File : |
<? php include("../includes/config.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Gestion de calendrier | Evenement</title>
<link rel="stylesheet" type="text/css" href="design/calendrier.css" media="screen" />
</head>
<body>
<?php
$typeDate = "#^[0-3]?[0-9]/[01]?[0-9]/[0-9]{4}$#";
if(isset($_GET['d']) && preg_match($typeDate, $_GET['d'])) {
// Traitement de l'affichage
$date = htmlentities($_GET['d']);
$tabDate = explode('/', $date);
// $req = "SELECT * FROM evenements WHERE id_evenement IN (SELECT id_evenement FROM calendrier WHERE jour_evenement=".$tabDate[0]." AND mois_evenement=".$tabDate[1]." AND annee_evenement=".$tabDate[2].")";
$req = $GLOBALS['bdd']->prepare('SELECT * FROM evenements WHERE id_evenement
IN (SELECT id_evenement FROM calendrier WHERE jour_evenement='.$tabDate[0].' AND mois_evenement='.$tabDate[1].' AND annee_evenement='.$tabDate[2].')');
$req ->execute();
$evenements = $req ->fetchAll();
if(rows($evenements)) {
while($evenement = mysql_fetch_array($evenements)) {
echo '
<table>
<tr>
<th>'.$evenement['titre_evenement'].'</th>
</tr>
<tr>
<td>'.$evenement['contenu_evenement'].'</td>
</tr>
</table>
<br/><br/>
';
}
} else {
echo '<p>Il n\'y a aucun événement pour cette date.</p>';
}
mysql_close();
}
echo '<p class="centre"><a href="calendrier.php">Revenir au calendrier</a></p>'
?>
</body>
</html>