' . LF; $list .= LF . '' . LF; $list .= ' ' . LF; $list .= ' ' . LF; $list .= ' ' . LF; $list .= ' ' . LF; $list .= ' ' . LF; $sql = "SELECT * FROM ".DB_PREPEND."phpwcms_keyword WHERE keyword_trash=0 ORDER BY keyword_name"; $keywords = _dbQuery($sql); $c = 0; foreach($keywords as $value) { // set alternating class name $aclass = ($c % 2) ? ' class="alternating"' : ''; $list .= ' ' . LF; $list .= ' ' . LF; $list .= ' ' . LF; $list .= ' ' .LF; $list .= ' ' . LF; $c++; } $list .= '

All	Keyword Name
	' . html_specialchars($value['keyword_name']) . '

' . LF; $list .= ''; $list .= ''; $list .= LF . '' . LF; return $list; } function backend_edit_keywords() { $list = ''; $keyword_id = empty($_POST['keyword_selected_id']) ? 0 : intval($_POST['keyword_selected_id']); // UPDATE keyword if(isset($_POST['send_update'])) { $update = backend_getKeywordPostValues(); if(empty($update['keyword_name'])) { // False, empty Keyword Name $list .= '

Proof your input. Keyword name had no value. Value was reset.

'; } else { $sql = "UPDATE ".DB_PREPEND."phpwcms_keyword SET "; $sql .= "keyword_name='" . aporeplace($update['keyword_name']) ."' "; $sql .= "WHERE keyword_id=".$keyword_id." "; $sql .= "AND keyword_name!='" . aporeplace($update['keyword_name']) ."' LIMIT 1"; $update['result'] = _dbQuery($sql, 'UPDATE'); } // INSERT keyword } elseif(isset($_POST['send_insert'])) { $insert = backend_getKeywordPostValues(); if(empty($insert['keyword_name'])) { // False, empty Keyword Name $list .= '

Proof your input. Keyword name had no value. Value was reset.

'; } else { // 1st check if keyword does not exist $sql = "SELECT * FROM ".DB_PREPEND."phpwcms_keyword "; $sql .= "WHERE keyword_trash=0 AND keyword_name='" . aporeplace($insert['keyword_name']) ."'"; $check = _dbQuery($sql); if(empty($check[0])) { $sql = "INSERT INTO ".DB_PREPEND."phpwcms_keyword SET "; $sql .= "keyword_name='" . aporeplace($insert['keyword_name']) ."'"; $insert['result'] = _dbQuery($sql, 'INSERT'); $keyword_id = $insert['result']['INSERT_ID']; } else { $list .= '

No new keyword created. Keyword name must be unique.

'; } } } $sql = "SELECT * FROM ".DB_PREPEND."phpwcms_keyword WHERE keyword_trash=0 AND keyword_id=" . $keyword_id." LIMIT 1"; $keyword = _dbQuery($sql); if(!$keyword) return '

No keyword could be found for the given ID

'; $list .= '' . LF; return $list; } function backend_getKeywordPostValues() { $value = array(); $value['keyword_name'] = isset($_POST['keyword_name']) ? clean_slweg($_POST['keyword_name']) : ''; return $value; } ?>