Пример #1
0
 /**
  * Adds a new news entry
  *
  * @param array $data Array with news data
  * 
  * @return boolean
  */
 function addNewsEntry($data)
 {
     $query = sprintf("\n            INSERT INTO\n                %sfaqnews\n            (id, datum, lang, header, artikel, author_name, author_email, date_start, date_end, active, comment,\n            link, linktitel, target)\n                VALUES\n            (%d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", SQLPREFIX, $this->db->nextID(SQLPREFIX . 'faqnews', 'id'), $data['date'], $data['lang'], $data['header'], $data['content'], $data['authorName'], $data['authorEmail'], $data['dateStart'], $data['dateEnd'], $data['active'], $data['comment'], $data['link'], $data['linkTitle'], $data['target']);
     if (!$this->db->query($query)) {
         return false;
     }
     return true;
 }
Пример #2
0
 /**
  * Inserts an item and definition into the database
  *
  * @param  string $item       Item
  * @param  string $definition Definition
  * @return boolean
  */
 public function addGlossaryItem($item, $definition)
 {
     $this->item = $this->db->escape_string($item);
     $this->definition = $this->db->escape_string($definition);
     $query = sprintf("\n            INSERT INTO\n                %sfaqglossary\n            (id, lang, item, definition)\n                VALUES\n            (%d, '%s', '%s', '%s')", SQLPREFIX, $this->db->nextID(SQLPREFIX . 'faqglossary', 'id'), $this->language, $this->db->escape_string($this->item), $this->db->escape_string($this->definition));
     if ($this->db->query($query)) {
         return true;
     }
     return false;
 }