"; $yyyy = substr($params,5,strpos($params,"&")-5); $params = substr($params,5+strlen($yyyy)+1); $mm = substr($params,3,strpos($params,"&")-3); $params = substr($params,3+strlen($mm)+1); $dd = substr($params,3,strpos($params,"&")-3); $params = substr($params,3+strlen($dd)+1); $starttime = substr($params,10,strpos($params,"&")-10); $params = substr($params,10+strlen($starttime)+1); $startampm = ""; $hh = substr($starttime,0,2); $min = substr($starttime,3,2); if($hh>12){ $hh -= 12; $startampm = "PM"; if($hh<10){ $hh = "0".$hh; } $starttime = $hh.":".$min; }else{ $startampm = "AM"; } $endtime = substr($params,8,strpos($params,"&")-8); $params = substr($params,8+strlen($endtime)+1); $endampm = ""; $hh = substr($endtime,0,2); $min = substr($endtime,3,2); if($hh>12){ $hh -= 12; $endampm = "PM"; if($hh<10){ $hh = "0".$hh; } $endtime = $hh.":".$min; }else{ $endampm = "AM"; } $category = substr($params,9,strpos($params,"&")-9); $params = substr($params,9+strlen($category)+1); $venue = substr($params,6,strpos($params,"&")-6); $params = substr($params,6+strlen($venue)+1); $parish = substr($params,7,strpos($params,"&")-7); $params = substr($params,7+strlen($parish)+1); $rating = substr($params,7); /* echo "$yyyy
$mm
$dd
$starttime
$startampm
$endtime
$endampm
$category
$venue
"; echo "$parish
$rating
"; */ ?>
Search Events
Event Date: - - Category:
Starting Time (hh:mm): Rating:
Ending Time (hh:mm): Parish:

NOW() and "; if(isset($_POST['yyyy']) || isset($_POST['mm']) || isset($_POST['dd'])){ $query = substr($query, 0, strlen($query)-26); } $yyyy=$_POST['yyyy']; if(isset($yyyy)){ if($yyyy != 0){ $query.="EventDate like \"%$yyyy%\" and "; } } $mm=$_POST['mm']; if(isset($mm)){ if($mm != 0){ $query.="EventDate like \"%$mm%\" and "; } } $dd=$_POST['dd']; if(isset($dd)){ if($dd != 0){ $query.="EventDate like \"%$dd%\" and "; } } $starttime=$_POST['starttime']; $startampm=$_POST['startampm']; if(isset($starttime)){ if(strlen(trim($starttime))!=0){ if($startampm=="PM"){ $hh=substr($starttime,0,2); $min=substr($starttime,3,2); $hh=$hh+12; $starttime=$hh.":".$min.":00"; } $query.="EventStartTime = '$starttime' and "; } } $endtime=$_POST['endtime']; $endampm=$_POST['endampm']; if(isset($endtime)){ if(strlen(trim($endtime))!=0){ if($endampm=="PM"){ $hh=substr($endtime,0,2); $min=substr($endtime,3,2); $hh=$hh+12; $endtime=$hh.":".$min.":00"; } $query.="EventEndTime = '$endtime' and "; } } $category=$_POST['category']; if(isset($category)){ if($category != 0){ $query.="event.CategoryID=$category and "; } } $venue=$_POST['venue']; if(isset($venue)){ if(strcmp($venue,"0")!=0){ $query.="EventVenue='$venue' and "; } } $parish=$_POST['parish']; if(isset($parish)){ if($parish != 0){ $query.="event.ParishID=$parish and "; } } $rating=$_POST['rating']; if(isset($rating)){ if($rating != 0){ $query.="event.RatingID=$rating and "; } } $orderby=$_GET['orderby']; $dir=$_GET['d']; if(!isset($dir)){ $dir = "ASC"; } if(strcmp($dir,"ASC")!=0 and strcmp($dir,"DESC")!=0){ $dir = "ASC"; } if(isset($_GET['offset'])){ $offset=$_GET['offset']; } if(!isset($offset)){ $offset=1; } if(!isset($orderby)){ $orderby="EventDate"; $query=substr($query,0,strlen($query)-5); }else{ $query=$_SESSION['querystring']; $query=substr($query,0,strlen($query)-(strlen($query)-strpos($query,"order"))); } $params="yyyy=$yyyy&mm=$mm&dd=$dd&starttime=$starttime&endtime=$endtime&"; $params.="category=$category&venue=$venue&parish=$parish&rating=$rating"; $_SESSION['params']=$params; $query.=" order by $orderby $dir"; $_SESSION['querystring']=$query; $result=mysql_db_query ($db,$query)or die ("Invalid Request Found!! Please Click Back"); $numrows = mysql_num_rows($result); //if display rows is more than the number of rows available, //display the available number of rows if($DISPLAY_ROWS>$numrows){ $DISPLAY_ROWS = $numrows; } //calculates the start index of retrieving the records $temp=($offset*$DISPLAY_ROWS)-$DISPLAY_ROWS; $query.=" limit $temp,$DISPLAY_ROWS"; $result=mysql_db_query ($db,$query)or die ("Invalid Request Found!! Please Click Back"); if(strcmp($dir,"ASC")==0){ $dir = "DESC"; }else{ $dir = "ASC"; } // $fqr="select * from event where Status='Show' and EventDate>NOW()"; $fqr="SELECT * FROM event WHERE EventDateEventID; } $eid=rand(0,count($ids)-1); $eid=$ids[$eid]; if($eid > 0){ $fq="select * from event,category,parish,rating where event.CategoryID=category.CategoryID and "; $fq.="event.ParishID=parish.ParishID and rating.RatingID=event.RatingID and event.EventID=$eid"; $fr=mysql_db_query ($db,$fq)or die ("Invalid query 2"); $frrow = mysql_fetch_object($fr); $eventtitle=$frrow->EventTitle; $eventdesc=$frrow->EventDescription; $eventvenue=$frrow->EventVenue; $eventdate=$frrow->EventDate; $eventyyyy=substr($eventdate,0,4); $eventmm=substr($eventdate,5,2); $eventdd=substr($eventdate,8,2); $eventdate=date ("l F d, Y",mktime(0,0,0,$eventmm,$eventdd,$eventyyyy)); $eventfreq=$frrow->EventFrequency; $eventstarttime=$frrow->EventStartTime; $hh = substr($eventstarttime,0,2); $mm = substr($eventstarttime,3,2); if($hh>12){ $hh -= 12; $eventstarttime=$hh.":".$mm." PM"; }else{ $eventstarttime=$hh.":".$mm." AM"; } $eventendtime=$frrow->EventEndTime; $hh = substr($eventendtime,0,2); $mm = substr($eventendtime,3,2); if($hh>12){ $hh -= 12; $eventendtime=$hh.":".$mm." PM"; }else{ $eventendtime=$hh.":".$mm." AM"; } $catname=$frrow->CategoryName; $parishname=$frrow->ParishName; $ratingname=$frrow->RatingName; $iq="select * from photo where EventID=$eid limit 1"; $ir = mysql_db_query ($db,$iq)or die ("Invalid query"); $irrow = mysql_fetch_object($ir); $imgpath = $irrow->PhotoPath; /* if(strlen(trim($imgpath))<2){ $imgpath = "nophoto.jpg"; }*/ $PUT_LISTING_HERE="

Featured Event

"; $PUT_LISTING_HERE.="$eventtitle"; $PUT_LISTING_HERE.=""; $PUT_LISTING_HERE.=""; if(strlen(trim($imgpath))>2){ $PUT_LISTING_HERE.=""; } $PUT_LISTING_HERE.=""; $PUT_LISTING_HERE.=""; $PUT_LISTING_HERE.=""; $PUT_LISTING_HERE.=""; $PUT_LISTING_HERE.=""; $PUT_LISTING_HERE.="
Category:$catname
When:$eventdate
Time:$eventstarttime to $eventendtime
Where:$eventvenue, $parishname
Rating:$ratingname
"; } if(mysql_num_rows($result)==0){ $PUT_LISTING_HERE.="

No Events Found!!

"; }else{ $PUT_LISTING_HERE.="

Events Listing

\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n\n\n\n"; while ($row = mysql_fetch_object($result)){ $eventid=$row->EventID; $eventtitle=$row->EventTitle; $eventdesc=$row->EventDescription; $eventvenue=$row->EventVenue; $eventdate=$row->EventDate; $eventyyyy=substr($eventdate,0,4); $eventmm=substr($eventdate,5,2); $eventdd=substr($eventdate,8,2); $eventdate=date ("l F d, Y",mktime(0,0,0,$eventmm,$eventdd,$eventyyyy)); $eventfreq=$row->EventFrequency; $eventstarttime=$row->EventStartTime; $hh = substr($eventstarttime,0,2); $mm = substr($eventstarttime,3,2); if($hh>12){ $hh -= 12; $eventstarttime=$hh.":".$mm." PM"; }else{ $eventstarttime=$hh.":".$mm." AM"; } $eventendtime=$row->EventEndTime; $hh = substr($eventendtime,0,2); $mm = substr($eventendtime,3,2); if($hh>12){ $hh -= 12; $eventendtime=$hh.":".$mm." PM"; }else{ $eventendtime=$hh.":".$mm." AM"; } $catname=$row->CategoryName; $parishname=$row->ParishName; $ratingname=$row->RatingName; $PUT_LISTING_HERE.="\n\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; } } $PUT_LISTING_HERE.="
\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.=""; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="\n"; $PUT_LISTING_HERE.="
$catname$eventtitle$eventvenue$parishname$eventdate at $eventstarttime to $eventendtime
"; $PAGE_SCROLLER=""; if($DISPLAY_ROWS < $numrows){ $i=0; //calculate how many pages are required to display all rows if($numrows % $DISPLAY_ROWS==0){ $numrows=(int)($numrows/$DISPLAY_ROWS); }else{ $numrows=(int)(($numrows/$DISPLAY_ROWS)+1); } $PAGE_SCROLLER.="
"; while($i<$numrows){ $pNum=$i+1; //display pages - current page is not a link where as other pages are. if($pNum == $offset){ $PAGE_SCROLLER.="[$pNum]"; }else{ $PAGE_SCROLLER.=" $pNum "; } $i++; } $PAGE_SCROLLER.="
"; } $PUT_LISTING_HERE.=$PAGE_SCROLLER; echo $PUT_LISTING_HERE; include("tpl_bottom.php"); ?>