/** * / * @param Record $record [description] * @return [type] [description] */ public function update(Record $record) { $id = $record->get('id'); $record->remove('id'); $language = $record->get('language'); $record->remove('language'); $sql = "UPDATE collections SET parent_id=:parent_id, modified=NOW() WHERE id=:id"; $result = $this->db->run($sql, array('id' => $id, 'parent_id' => $record->get('parent_id'))); $record->remove('parent_id'); $record->remove('type_id'); $values = $record->getUpdateValueString(); $sql = "UPDATE translations SET {$values}\n WHERE item_id=:id \n AND language=:language\n AND item_name=:item_name"; $record->set('language', $language); $record->set('item_name', 'collection'); $record->set('id', $id); $result = $this->db->run($sql, $record->toArray()); return $result; }
/** * / * @param Record $record [description] * @return [type] [description] */ public function update(Record $record) { $id = $record->get('id'); $record->remove('id'); $language = $record->get('language'); $record->remove('language'); $sql = "UPDATE resources SET modified=NOW() WHERE id=:id"; $result = $this->db->run($sql, array('id' => $id)); $record->remove('type_id'); $record->remove('url'); $record->remove('filepath'); $record->remove('filename'); $record->remove('extension'); $record->remove('embed'); $record->remove('mimetype'); $values = $record->getUpdateValueString(); $sql = "UPDATE translations \n SET {$values} \n WHERE item_id=:id \n AND language=:language\n AND item_name=:item_name"; $record->set('language', $language); $record->set('item_name', 'term'); $record->set('id', $id); $result = $this->db->run($sql, $record->toArray()); return $result; }
/** * / * @param Record $record [description] * @return [type] [description] */ public function update(Record $record) { $sql = "UPDATE types SET name=:name, item_name=:item_name WHERE id=:id"; $result = $this->db->run($sql, array('item_name' => $record->get('item_name'), 'name' => $record->get('name'), 'id' => $record->get('id'))); $record->remove('name'); $sql = "UPDATE translations SET user_id=:user_id, language=:language, slug=:slug, title=:title\n WHERE item_id=:id AND item_name=:item_name"; $result = $this->db->run($sql, $record->toArray()); return $result; }
/** * / * @param Record $record [description] * @return [type] [description] */ public function update(Record $record) { $id = $record->get('id'); $record->remove('id'); $values = $record->getUpdateValueString(); $sql = "UPDATE users \n SET {$values}, modified=NOW() WHERE id=:id"; $record->set('id', $id); $result = $this->db->run($sql, $record->toArray()); return $result; }
/** * / * @return [type] [description] */ public function handlePostRequest() { // try to get $_POST $body = $this->app->request->post(); // if $_POST is empty, try to get json request body instead if (empty($body)) { $json = $app->request->getBody(); $body = json_decode($json, true); } $record = new Record($body); if (!$record->has('nonce') || !$this->app->nonce->verify($record->get('nonce'))) { $this->errorForbidden(); } $record->remove('nonce'); return $record; }