function updateEntry($link)
{
unset($_POST['btnUpdateEntry']);
$queryString = array();
foreach ($_POST as $key => $value) {
// sanitize values
$value = sanitizeValues($value, $link);
// format values
if ($key == 'contact_phonenumber') {
$value = formatPhoneNumber($value);
}
if ($key == 'event_tags' || $key == 'event_categories' || $key == 'open_to') {
$value = formatArray($value);
}
if ($key == 'event_startdate') {
$value = formatStartDate($value);
}
if ($key == 'event_enddate') {
$value = formatEndDate($value);
}
// save values to session variables
$_SESSION[$key] = "";
$_SESSION[$key] = $value;
// set key name as variable, save value to this variable
${$key} = $value;
//echo "$key - $value<br>";
// add key (element/column name) and value to queryString array
$queryString[] = "{$key} = '{$value}'";
//var_dump($queryString);
}
// get string from elements of queryString array
$implodedArray = implode(', ', $queryString);
$query = "UPDATE tbl_entries SET {$implodedArray} WHERE id = {$_SESSION['event_id']}";
//print_r($query);
$result = mysqli_query($link, $query) or trigger_error(mysqli_error());
return $result;
mysqli_close($link);
}
$result .= "<li>{$error}</li>";
}
$result .= '</ul>';
} else {
// 2.a. Process post values
// - - - - - - - - - - - - - - - - - - - - - - - - -
// create db query string array
$queryString = array();
$queryStringRpt = array();
$weekdays = array();
foreach ($_POST as $key => $value) {
// sanitize values
$value = sanitizeValues($value, $link);
// format values
if ($key == 'contact_phonenumber') {
$value = formatPhoneNumber($value);
}
if ($key == 'event_tags' || $key == 'event_categories' || $key == 'open_to') {
$value = formatArray($value);
}
if ($key == 'event_startdate' && $value) {
$value = formatStartDate($value);
$queryStringRpt[] = $value;
}
if ($key == 'event_enddate' && $value) {
$value = formatEndDate($value);
$queryStringRpt[] = $value;
}
// save values to session variables
$_SESSION[$key] = "";
$_SESSION[$key] = $value;
<?php
get_header();
the_post();
// Update click stats
$impressions = get_field('poi-impressions', $post->ID);
$impressions++;
update_field('poi-impressions', $impressions, $post->ID);
//Get the image
$imageUrl = get_post_meta($post->ID, 'poi-image', true);
//Get avabile data (filter out all blank data)
$sidebar_data = array_filter(array('adress' => get_post_meta($post->ID, 'poi-address', true), 'postal_city' => str_replace(" ", "", get_post_meta($post->ID, 'poi-postalcode', true)) . " " . strtoupper(get_post_meta($post->ID, 'poi-city', true)), 'phone' => formatPhoneNumber(get_post_meta($post->ID, 'poi-phone', true)), 'url' => str_replace("http://", "", str_replace("www.", "", get_post_meta($post->ID, 'poi-website', true)))));
//Get position
$latitude = get_post_meta($post->ID, 'poi-latitude', true);
$longitude = get_post_meta($post->ID, 'poi-longitude', true);
?>
<aside>
<div class="inner">
<?php
if (!filter_var($imageUrl, FILTER_VALIDATE_URL) === false) {
?>
<div class="image-max-height">
<img src="<?php
echo $imageUrl;
?>
" style="width: 100%;" />
</div>
<?php
}
?>
