protected static function convertData($data) { if (is_array($data)) { $keys = ''; $values = ''; if (self::$query != 'collection') { foreach ($data as $key => $value) { //if ($value != '') { $keys .= $key . ', '; $values .= "'" . DB::esc($value) . "',"; //} } $keys = substr(trim($keys), 0, -1); $values = substr(trim($values), 0, -1); self::$_data = array('keys' => $keys, 'values' => $values); } else { self::$_data = $data; } } else { self::$_data = DB::esc($data); } }
public function save() { DB::query("\n\t\t\tINSERT INTO chat (author, gravatar, text)\n\t\t\tVALUES (\n\t\t\t\t'" . DB::esc($this->author) . "',\n\t\t\t\t'" . DB::esc($this->gravatar) . "',\n\t\t\t\t'" . DB::esc($this->text) . "'\n\t\t)"); return DB::getMySQLiObject(); }