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); }
// 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; // 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