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);
}
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;
// set key name as variable, save value to this variable
${$key} = $value;
// INSERT INTO `event_calendar`.`rec_repeats` (`parent_id`, `repeat_startdate`, `repeat_enddate`, `repeat_day`, `repeat_freq`, `repeat_until`, `repeat_until_date`, `repeat_until_num`)
// VALUES ('4000', '2015-08-19 00:00:00', '2015-08-19 12:00:00', 'MO,TU,WE', 'WEEKLY', '1', '2015-11-19 00:00:00', ''),
// ('5000', '2015-08-21 09:00:00', '2015-08-21 17:00:00', 'MO,TU,WE,TH,FR', 'WEEKLY', '1', '2016-08-21 00:00:00', '')
// repeat options
if ($key == 'repeat_day') {
foreach ($value as $dow) {
$weekdays[] = $dow;
}
