Is it on? Or is it not on?

Dayboro Events.

On the back of the CoVid-19, we are figuring out what to do and how to go from here. This website,, is no exception.

Do you have any idea how hard it is to gather all the events, and then try to ensure they are correctly listed?

Things change day-by-day it is hard work.

Removing events that are postponed or cancelled is not a good thing as it creates havoc with the webpage and sites that link back to this website. Dayboro and Surrounds Business Directory, for example, is linking back to this site, as it is part of the Lions Dayboro Directory online. 

How to inform people about the Things to do in Dayboro.

We are making this site as informative as we can, without cluttering it too much. We noticed that the Dayboro Community board, that electrical one, is getting “clogged up”. Not so much with community notices, more so with commercials. 

The challenge we face is to keep the data on this site as up to date as we possibly can. For some events we have no idea if they are getting out of CoVid-19 hibernation or not, we cannot ring around every day and hassle folks about their activity. For sure everybody has better things to do. 

For that reason, we included tags and pointers as part of the events. 

Your guess is as good as mine.

Your guess is as good as mine when it comes to some events, but we will have a good crack at it to get you the best possible information on #whatisonindayboro. When we are made aware of an event, a few things happen (but more on that later) we let you know if the event is postponed or if it “is a go”. 

Events in Dayboro can change quickly; it all depends on the organisers, who as previously mentioned, are busy and have better things to do than to update us on the stats. To make it all a bit easier, we introduced a new “Tag” if you like. It is “Check with Organiser”.

Check with Dayboro Event Organiser

What does that mean? In simple terms… “We have NO IDEA if this event is on or not”. The backend of this site and the content is maintained by HELP4BIS, we simply do not have the time or resources follow up. Needless to say that we do all of this for FREE, there is NO cost to the Lions what so ever. 

To keep things “reasonable” the TAG “Check with Organiser” is our way to say, “we do not know for sure” so you should hassle the organiser on the status. 

If it is on or if it is not on. 

What about the other status options?

As part of the CoVid-19 initiative, we added the option to set a status for an event quickly. Setting status in one place is especially is handy for repeating events.

  • Scheduled, this means it is on. 
  • Rescheduled, this means it is happening on another date. 
  • Postponed, this means the event is planned, but we do not know when it is going to happen. A typical scenario, like this, where we would add the “Check with Organiser” tag. 
  • Moved Online, a lot of events have moved online due to the CoVid-19 restrictions. 
  • Cancelled, precisely that, this does not mean the event will never be back on. It just means it is not going to happen shortly. 
As with all articles on this website (Dayboro Events) they are the views and updates provided by the webmaster. These views are not necessarily to align with the views of the Dayboro Lions or Lions in general.
Dayboro EVents page logo
Web Master

Step 1 Dayboro Events Data extraction

The Dayboro Events Data extraction Plan.

We want to promote the Dayboro Events to a broader community, this means we have to get our “hands” on the Dayboro Events Data which is stored in the database.

To post to social media we have two options, one is to visit the event post and publish it to social media. That is fun for the first few but it becomes boring very quickly. Needless to say that this will take up a lot of our time every day so it is time to automate a few things. 

The second option is to automate it. First, we have to understand that we have no “Coders” in the office. All coding is self-thought and will look like a bunch of “rubbish” in the eyes of more experienced coders. The plan is to make it as simple as possible, use as many “already existing” code and applications (plugins) to make this happen. We need to take into consideration that this automation needs to be as user friendly in the “backend” as possible. 

Now we got that out of the way, here we go

The Code

We are no coders, nor do we claim we are. Feel free to comment and to provide pointers, all help is welcome. 


// Connect to database server to write clean the table and write new entries.
echo “<br />”;
echo “<br />”;
$temp = “truncate todaysevents;”;
if(!$result = $con->query($temp)){
die(‘There was an error running the query [‘ . $con->error . ‘]’);
echo “Done ” .$temp;
echo “<br />”;
echo “<br />”;
echo “<br />”;

// now the Database is empty it is time to get the info. We use today plus 2 days.
// that should get tomorrows events.
$startDate = date(‘Y-m-d’);
$addTimeToDate = date(‘Y-m-d’,strtotime(‘+2 day’,strtotime($startDate)));
$endDate = $addTimeToDate;
echo $startDate;
echo “<br />”;
echo $endDate;
echo “<br />”;

// use the API/JSON to collect the data.
// the dates are variables created above..
$jsonlink = “”.$startDate.”/”.$endDate;

echo $jsonlink;
echo “<br />”;
echo “<br />”;

// Read JSON file
$json = file_get_contents($jsonlink);

//Decode JSON
$json_data = json_decode($json,true);

// Loop through the json file to find all the events.
// We then get the Event?Status and the Eventlink to put into our database.
foreach($json_data as $elem) {
( $elem[‘data’]);
foreach ($elem[‘events’] as $events ) {
$EventStatus = ($events[‘event_status’]);
echo “Event Status “.$EventStatus;

$permalink = ($events[‘permalink’]);
echo ” this is the permalink “.$permalink;
echo(“<br/>”) ;

// database fields values are the values taken from the $filename content that is converted in the above section.
$sql = “INSERT INTO `todaysevents`(EventStatus, EventLink)
(‘$EventStatus’, ‘$permalink’)”;
echo “Start Running Query”;
if(!$result = $con->query($sql)){
die(‘There was an error running the query [‘ . $con->error . ‘]’);




We have stuff in the DB.

Pretty excited, we now have Dayboro Events in our database. We have extracted from the plugin Database. 

The plugin Stachethemes Event Calendar is written pretty cleverly, from what we see it does not pollute the DataBase will include entries etc. On the other hand, that is what creates our “problem” to find the data in the back end. 

Thanks to the quick response cooperation from the plugin Author we can use their API and some of our “code” to retrieve the records we want in the format we want. 

Sure we could write the information to a TXT file. We decided just to put it in a separate database table. We are more familiar with that. 

This is what we are at, for now. 

Having this data in a database now gives us a few paths we can follow, we can use the data to pop-up in the Dayboro Directory on the Dayboro Weather site or even other areas like mail merge etc. 

As it so happens we just received an email from the Author of StacheThemes with an update API, we will incorporate the new API as it makes our code above a lot easier… Thanks GUYS. 

We do like to thank the Author(s) of the Stachethemes Event Calendar plugin, their support is fantastic and their response is very quick. 

They send us an email last night they made changes to the API, especially for us to incorporate our “requirements”. That is fantastic you do not get any of that with the big commercial “guys”. 

Dayboro Events Calendar for mobile phones

Updated the Events Calendar to be more responsive. Some users mentioned that the monthly calendar is a bit small, and it is. When you use the Dayboro Events calendar on the phone it will default to an agenda view.  You can scroll through the view (see video) select the item you are interested etc etc.

Dayboro Directory all the information at your fingertips…. and then some.


Dayboro Events Responsive

Dayboro Events linked back to Directory.

Dayboro events linked to #whatsondayboro

Your Dayboro events now part of YOUR directory listing

Dayboro Events linked back to your directory listing is just something we came up with today. We continuously trying to improve the Lions Dayboro & District Business Directory.

Why don't we link the Dayboro Events back to the organisers that are listed in the Dayboro Directory? #whatsondayboro