function updateTags($link, $view) { if ($view == 'location') { unset($_POST['btnUpdateLocation']); $name = $_POST['name']; $id = $_POST['id']; $isDowntown = $_POST['campus_' . $id]; $active = $_POST['active']; $query = "UPDATE tbl_locations SET name = '{$name}', is_downtown = '{$isDowntown}', active = '{$active}' WHERE id = '{$id}'"; echo $query; } else { unset($_POST['btnUpdateTag']); $queryString = array(); foreach ($_POST as $key => $value) { // sanitize values $value = sanitizeValues($value, $link); if ($key == 'id') { $id = $value; unset($_POST['id']); } else { // 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}'"; } } // get string from elements of queryString array $implodedArray = implode(', ', $queryString); $query = "UPDATE tbl_categories SET {$implodedArray} WHERE id = '{$id}'"; } $result = mysqli_query($link, $query) or trigger_error(mysqli_error()); return $result; mysqli_close($link); }
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); }
Please correct the following fields: <ul>'; foreach ($errors as $error) { $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; }