File "data.php"

Full Path: /home/asmplong/www/asm/js/data.php
File size: 2.15 KB
MIME-type: text/x-php
Charset: utf-8

<?php
session_start();
header("Content-type: text/javascript");
include('../inc.conec.php');
include('../inc.fonctions.php');
include('../inc.config.php');
?>
var codropsEvents = {
<?php
	$req_events = mysql_query("SELECT *,  DATE_FORMAT(event_date, '%Y-%m-%d') AS eventDate FROM ".$db_prefixe."events WHERE YEAR(event_date) >=  (YEAR(CURDATE()) - 1) GROUP BY YEAR(event_date), MONTH(event_date), DAY(event_date) ORDER BY eventDate DESC LIMIT 50");
	
	while($data_events = mysql_fetch_array($req_events))
	{
		$req_events_infos = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE DATE_FORMAT(event_date, '%Y-%m-%d')='".$data_events['eventDate']."'");
		
		echo '\''.changedateuscal($data_events['event_date']).'\' :\'';

		while($data_events_infos = mysql_fetch_array($req_events_infos))
		{
		
		$req_type = mysql_query("SELECT * FROM ".$db_prefixe."types_events WHERE type_id = '".$data_events_infos['event_type']."'");
		$data_type = mysql_fetch_array($req_type);

		$req_dp = mysql_query("SELECT * FROM ".$db_prefixe."membres WHERE membre_id = '".$data_events_infos['event_id_dp']."'");
		$data_dp = mysql_fetch_array($req_dp);

		$req_inscrit = mysql_query("SELECT * FROM ".$db_prefixe."inscriptions WHERE inscription_id_membre = '".$_SESSION['user_id']."' AND inscription_id_event = '".$data_events_infos['event_id']."'");
		$data_inscrit = mysql_fetch_array($req_inscrit);
		
		if(mysql_num_rows($req_inscrit) != 0) { $title = "Vous êtes inscrit à cet évènement"; $class = ' class="register"'; } else { $title = ""; $class = ''; }
		
		
		$req_event = mysql_query("SELECT * FROM ".$db_prefixe."events WHERE event_id='".$data_events_infos['event_id']."' AND event_type = '8'");
		$data_event = mysql_fetch_array($req_event);
		if($data_event['event_titre'] != '') { $event_titre = '  : <strong>'.addslashes($data_event['event_titre']).'</strong>'; } else { $event_titre = '';  }
		
		echo '<a href="event_detail.php?id='.$data_events_infos['event_id'].'" title="'.$title.'" '.$class.'>'.utf8_encode($data_type['type_nom']).''; echo $event_titre;  echo '<span> | organisé(e) par '.$data_dp['membre_prenom'].' '.$data_dp['membre_nom'].'</span></a>';	
		
		}
		
		echo '\',
		';
	}
?>
};