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 } ?>