public function insert(Advice $advice) { $advice->setAdviceId(null); $advice->setCreatedAt(new DateTime()); $sql = 'insert into ' . $this->tableName . '(adviceId, content,createdBy,createdAt) ' . 'values( :adviceId, :content, :createdBy, :createdAt)'; return $this->execute($sql, $advice); //$statement = $this->getDb()->prepare($sql); // $data = AdviceMapper::getParams($advice); //echo $data[':content']; //$statement->execute($data); // echo date_format($advice->getCreatedAt(), 'Y-m-d H:i:s'); }
public static function map(Advice $advice, array $properties) { if (array_key_exists('adviceId', $properties)) { $advice->setAdviceId($properties['adviceId']); } if (array_key_exists('content', $properties)) { $advice->setContent($properties['content']); } if (array_key_exists('createdBy', $properties)) { $advice->setCreatedBy($properties['createdBy']); } if (array_key_exists('createdAt', $properties)) { $createdAt = DateTransform::createDateTime($properties['createdAt']); if ($createdAt) { $advice->setCreatedAt($createdAt); } } }