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