prepare("SELECT p.page_ID, p.page_title, p.page_content FROM bnb_pages AS p JOIN bnb_page_statuses AS s ON p.page_status = s.status_ID WHERE (s.status_name = 'published' AND p.page_alias = ? ) OR (s.status_name = 'planned' AND p.page_alias = ? AND p.publication_date <= NOW() ) ") ; $q->bind_param('ss', $filepath, $filepath); $q->execute(); $q->store_result(); // echo $q->num_rows; if ($q->num_rows > 0) { $q->bind_result($id, $title, $content); $q->fetch(); $q->close(); $u_agent = $_SERVER['HTTP_USER_AGENT']; if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip = $_SERVER['HTTP_CLIENT_IP']; } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip = $_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip = $_SERVER['REMOTE_ADDR']; } $browser = 'Unknown'; $platform = 'Unknown'; $java_bot = false; //First get the platform? if (preg_match('/Java/i', $u_agent) || preg_match('/bot/i', $u_agent) || preg_match('/Bot/i', $u_agent) || preg_match('/API/i', $u_agent) || preg_match('/api/i', $u_agent)) { $javabot = true; } else if (preg_match('/Android/i', $u_agent)) { $platform = 'Android'; } else if (preg_match('/iPhone/i', $u_agent)) { $platform = 'iOS'; } else if (preg_match('/linux/i', $u_agent)) { $platform = 'Linux'; } elseif (preg_match('/macintosh|mac os x/i', $u_agent)) { $platform = 'macOS'; } elseif (preg_match('/windows|win32/i', $u_agent)) { $platform = 'Windows'; } // Next get the name of the useragent yes seperately and for good reason if(preg_match('/MSIE/i',$u_agent) && !preg_match('/Opera/i',$u_agent)) { $browser = 'Internet Explorer'; $ub = "MSIE"; } elseif(preg_match('/Firefox/i',$u_agent)) { $browser = 'Mozilla Firefox'; $ub = "Firefox"; } elseif(preg_match('/Chrome/i',$u_agent)) { $browser = 'Google Chrome'; $ub = "Chrome"; } elseif(preg_match('/Safari/i',$u_agent)) { $browser = 'Apple Safari'; $ub = "Safari"; } elseif(preg_match('/Opera/i',$u_agent)) { $browser = 'Opera'; $ub = "Opera"; } elseif(preg_match('/Netscape/i',$u_agent)) { $browser = 'Netscape'; $ub = "Netscape"; } if(preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i',$u_agent)||preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i',substr($u_agent,0,4))) { $mobile = 1; } else { $mobile = 0; } $datetime = date('Y-m-d H:i:s'); $timediff = '00:05:00'; $has_visited = $mysqli->prepare("SELECT count_ID FROM bnb_page_view_count WHERE ip_address = ? AND page_ID = ? AND view_datetime > DATE_SUB(NOW(), INTERVAL 5 MINUTE)"); $has_visited->bind_param('si', $ip, $id); $has_visited->execute(); $has_visited->store_result(); if ($has_visited->num_rows < 1 && !$java_bot) { $count = $mysqli->prepare("INSERT INTO bnb_page_view_count (page_ID, user_agent, user_platform, user_browser, ip_address, mobile_request, view_datetime) VALUES (?, ?, ?, ?, ?, ?, ?)"); $count->bind_param('issssis', $id, $u_agent, $platform, $browser, $ip, $mobile, $datetime); $count->execute(); $count->close(); } } ?> Muziekvereniging Ons Genoegen Kapelle
prepare("SELECT event_ID, event_title, event_start_date, event_performer, event_location, event_excerpt FROM bnb_events WHERE event_start_date > NOW() ORDER BY event_start_date ASC LIMIT 1"); $events_q->execute(); $events_q->bind_result($id, $title, $start_date, $performer, $location, $excerpt); while($event = $events_q->fetch()) { echo "

Op de agenda: ".$title."

"; echo "

".strftime("%e %B %Y",strtotime($start_date))."

"; echo '

'.$location.'

'; echo '

'.$performer.'

'; echo '

'.$excerpt.'

'; echo '

Meer informatie

'; } $events_q->close(); ?>

JEUGD

Ons Genoegen is een vereniging met veel jeugd. De jongste leerlingen beginnen dikwijls in de blokfluitgroepen. Nadat ze een instrument kiezen, stromen ze door naar de samenspelgroepen. Hier maken de leerlingen al in een heus orkest samen muziek. Later stromen leerlingen door naar het opleidingsorkest om daarna mee te gaan spelen in het harmonieorkest. Naast de blaasinstrumenten bestaat ook de slagwerkgroep voor een groot deel uit jonge leerlingen.

AGENDA

    prepare("SELECT event_ID, event_title, event_start_date FROM bnb_events WHERE event_start_date >= CURDATE() ORDER BY event_start_date ASC LIMIT 5"); $events_q->execute(); $events_q->bind_result($id, $title, $start_date); while($event = $events_q->fetch()) { echo "
  • ".$title." (".strftime("%e %B",strtotime($start_date)).")
  • "; } $events_q->close(); ?>

Meer bekijken

LID WORDEN

Nieuwe, enthousiaste muzikanten zijn altijd welkom bij Ons Genoegen! We zijn in het bijzonder op zoek naar hoornisten en trombonisten, maar andere muzikanten kunnen zich natuurlijk ook bij ons aansluiten.

Ben jij jong en muzikaal óf
heb je vroeger gespeeld en wil je weer muziek delen met anderen?

Word lid

NIEUWS

prepare("SELECT p.post_ID, p.post_title, p.post_modified_date, p.post_excerpt, m.media_url FROM bnb_posts AS p INNER JOIN bnb_media AS m ON m.media_ID = p.media_ID ORDER BY post_modified_date DESC LIMIT 8"); $posts_q->execute(); $posts_q->bind_result($id, $title, $date, $excerpt, $media_url); while($post = $posts_q->fetch()) { echo '

'.$title.'

'.strftime("%e %B",strtotime($date)).'

'.$excerpt.'

Lees verder
'; } ?>