<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$data = array(); 
// echo "<pre>" ; 
// print_r($_SESSION) ; 
// echo "<pre>" ; 
// exit() ; 
$user_id_selectionnee =$_SESSION['user_id_selectionnee'] ; 
$q = dbi_query("SELECT * FROM events   WHERE user_id = $user_id_selectionnee  ORDER BY id");

	while($row = dbi_fetch_row($q))
{	

$user_id = $row["user_cree"];
$event_type = $row["event_type"];
// echo " SELECT color FROM events_type where events_type  = $event_type";
// $row2["user_prenom"] = $user_id;
$row2 = dbi_fetch_row(dbi_query(" SELECT * FROM users where user_id = $user_id"));
$events_type = dbi_fetch_row(dbi_query(" SELECT colorcode FROM events_type where events_type_id   = $event_type"));
$color = $events_type['colorcode'];
// $row = dbi_fetch_row($q);
 $data[] = array(
  'id'   => $row["id"],
  'title'   => strtolower($row2["user_prenom"].' - ('.$row["title"].') - '.$row["description"]),
  'start'   => $row["start_event"],
  'end'   => $row["end_event"],
  'borderColor'   => $color ,
  'backgroundColor'   => $color 
  // 'backgroundColor'  => '#ffffff'
  
  
  										   // $data[$i]['backgroundColor']   = '#ffffff';
										   // $data[$i]['borderColor']   = '#007bf';
										   // $data[$i]['textColor']   = '#007bf';	
  
 );
}
echo json_encode($data);

?>