index.php

Go to the documentation of this file.

<?php
/* @var $this ScheduleController */

$this->breadcrumbs=array(
    'Schedule',
);
?>

<?php

Connect_DatabaseController::connect();  

$confid = $_GET['confid'];

$room = mysql_query("SELECT * FROM conference WHERE conferenceid=$confid");

$roo = "";

$roomnum=0;
while($row = mysql_fetch_array($room))
{
    $roo = $roo . $row['rooms'];
    $begindate = $row['conf_date_begin'];
    $enddate = $row['conf_date_end'];
    $begintime = $row['startTime'];
    $endtime = $row['endTime'];
    

}

//get room names separated by commas
$rooms = explode(',', $roo);

foreach($rooms as $ro)
{
    echo $ro . "<br>";
    $roomnum++;
}

echo "room number : " . $roomnum . "<br><br>";

   $dStart = new DateTime(date($begindate));
   $dEnd  = new DateTime(date($enddate));
   $dDiff = $dStart->diff($dEnd);
   //echo $dDiff->format('%R'); // use for point out relation: smaller/greater
   echo "gun farki : " . $dDiff->days . "<br>";
   $daynum = $dDiff->days;
   
   $to_time = strtotime($endtime);
   $from_time = strtotime($begintime);
   echo round(abs($to_time - $from_time) / 3600). " hours<br>";
   $timedif = round(abs($to_time - $from_time) / 3600);
   
   $papers = mysql_query("SELECT * FROM paper WHERE id IN
                        (SELECT paperid FROM conference_paper WHERE conferenceid=$confid)");
   
   $i = 0;
   
   while($row2 = mysql_fetch_array($papers))
   {
       $papid[$i+1] = $row2['id'];
       $papname[$i+1] = $row2['paper_name'];
 
      $i++; 
   }
   echo "paper sayisi : " . $i . "<br>";

   
   
       echo "<table>";   
/*
for($b=0;$b<$timedif;$b++)
{
   for($a=0;$a<$daynum; $a++)
   {

       if($b==0) echo ("<th><h3>Day " . ($a+1) . "</h3></th>");
      // else echo ("<th></th>");
       $hours = $timedif;

   }
   echo "</tr>";

echo "<th>" . $begintime . "</th>";
           
}*/
  
       
   for($a=0;$a<$daynum; $a++)
   {

       echo ("<tr><th><h3>Day " . ($a+1) . "</h3></th>");
      // else echo ("<th></th>");
       $hours = $timedif;
       
        for($b=0;$b<$timedif;$b++)
        {
        echo "</tr>";
        echo "<th>" . $begintime . "</th>";

        }


         echo "<th></th>";  
         echo "<th></th>";  

}


   echo "</table>";
?>