 |
|||
 |
 |
||
|
Jesters Bar - Live
Entertainment and Regular FUTURE EVENTS PLANNED AS FOLLOWS :- '214166625320313', 'secret' => '6c5dd3165865aa68ac7315c59b38f201', )); //just a heading echo " ";
echo "This event list is synchronized with our Facebook Fan Page ";
echo "";
echo "Jesters Costa Teguise Events ";
//query the events
//we will select name, pic, start_time, end_time, location, description this time
//but there are other data that you can get on the event table
//as you've noticed, we have TWO select statement here
//since we can't just do "WHERE creator = your_fan_page_id".
//only eid is indexable in the event table, sow we have to retrieve
//list of events by eids
//and this was achieved by selecting all eid from
//event_member table where the uid is the id of your fanpage.
//*yes, you fanpage automatically becomes an event_member
//once it creates an event
$fql = "SELECT name, pic, start_time, end_time, location, description
FROM event WHERE eid IN ( SELECT eid FROM event_member WHERE uid = 195107546575 ) AND start_time > now()
ORDER BY start_time desc";
$param = array(
'method' => 'fql.query',
'query' => $fql,
'callback' => ''
);
$fqlResult = $facebook->api($param);
//looping through retrieved data
foreach( $fqlResult as $keys => $values ){
//see here for the date format I used
//The pattern string I used 'l, F d, Y g:i a'
//will output something like this: July 30, 2015 6:30 pm
//getting 'start' and 'end' date,
//'l, F d, Y' pattern string will give us
//something like: Thursday, July 30, 2015
$start_date = date( 'l, F d, Y', $values['start_time'] );
$end_date = date( 'l, F d, Y', $values['end_time'] );
//getting 'start' and 'end' time
//'g:i a' will give us something
//like 6:30 pm
$start_time = date( 'g:i a', $values['start_time'] );
$end_time = date( 'g:i a', $values['end_time'] );
//printing the data
echo "";
echo " ";
}
?>
";
echo " ";
echo "";
echo " ";
echo "";
echo "{$values['name']} ";
if( $start_date == $end_date ){
//if $start_date and $end_date is the same
//it means the event will happen on the same day
//so we will have a format something like:
//July 30, 2015 - 6:30 pm to 9:30 pm
echo "on {$start_date} - {$start_time} to {$end_time} ";
}else{
//else if $start_date and $end_date is NOT the equal
//it means that the event will will be
//extended to another day
//so we will have a format something like:
//July 30, 2013 9:00 pm to Wednesday, July 31, 2013 at 1:00 am
echo "on {$start_date} {$start_time} to {$end_date} at {$end_time} ";
}
echo "Location: " . $values['location'] . " ";
echo "More Info: " . $values['description'] . " ";
echo " |
|||
| (C) 2011 Jesters Bar - The BEST Late Night Karaoke Bar | Jesters Bar, CC Tandarena 20/21, Upstairs off Pueblo Marinero (Main Square), Avendida del Canarias, Costa Teguise, Lanzarote 35508 | E-mail: info@jesters-bar.com Telephone: (+34) 928592155 | |||
TAXI Fare Refunded (up to €3.00) from the following Hotels /Apartments with Receipt: Santa Rosa, Playa Bastian, El Trebol, Coronas Playa, Tuscan, Los Ficus, Sands Beach, Los Zocos, Lanzarote Bay, Timanfaya Golf |
|||