Trinity2017-Main/getevt.php at master · Infotech-DjTrinity/Trinity2017-Main · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<?php
include 'admin/event/connect.php';

						$cdate=date('Y-m-d');
						$id=$_GET['id'];
                                                $query="SELECT * FROM event WHERE id=".$id.";";
						$query_run=$conn->query($query);
						while($qdata=$query_run->fetch_assoc())
						{
							  $rstime=substr($qdata['stime'],0,strpos($qdata['stime'],':'));
							  $retime=substr($qdata['etime'],0,strpos($qdata['stime'],':'));
							  if($rstime>=12 || $retime>=12)
							  {
								 $sflag="am";
								 $eflag="am";
								 if($rstime>12)
								 {
								 $rstime=$rstime-12;
								 $sflag="pm";
							     }
								 if($retime>12)
							     {
  								 $retime=$retime-12;
								 $eflag="pm";
								 }
								 if($rstime==12)
									 $sflag="pm";
								 if($retime==12)
									 $eflag="pm";
								 $strtime=$rstime.':'.substr($qdata['stime'],3,2).$sflag.' ';
								 if($qdata['etime']!="00:00:00")
								  $strtime = $strtime.'to '.$retime.':'.substr($qdata['etime'],3,2).$eflag;
							  }
							   else
							   {
								 $strtime=$rstime.':'.substr($qdata['stime'],3,2).'am ';
								 if($qdata['etime']!="00:00:00")
								 $strtime= $strtime.'to '.$retime.':'.substr($qdata['etime'],3,2).'am</p>';
							   }
							   $date=date_create($qdata['evtdate']);
							   $evtdate=date_format($date,"dS-M-Y");
							 echo $qdata['id'].'~'.$qdata['title'].'~'.$qdata['descrip'].'~'.$qdata['venue'].'~'.$evtdate.'~'.$strtime.'~'.$qdata['price'].'~'.$qdata['coord'].' : <a href="tel:.'.$qdata['coord_no'].'"><span class="glyphicon glyphicon-earphone"></span> &nbsp'.$qdata['coord_no'].'</a>~'.$qdata['regurl'];
						}

?>