コード例 #1
0
 private static function insert(Gallery $model)
 {
     $db = Database::getInstance('app');
     $query = "INSERT INTO gallery (source,carousel,title,description,post_date,titleBG,descriptionBG) VALUES (:source, :carousel, :title, :description, :post_date, :titleBG, :descriptionBG);";
     $result = $db->prepare($query);
     $result->execute([':source' => $model->getSource(), ':carousel' => $model->getCarousel(), ':title' => $model->getTitle(), ':description' => $model->getDescription(), ':post_date' => $model->getPost_date(), ':titleBG' => $model->getTitleBG(), ':descriptionBG' => $model->getDescriptionBG()]);
     $model->setId($db->lastId());
 }
コード例 #2
0
 /**
  * Creates gallery and saves it to database.
  * @param Gallery $gallery
  */
 public static function addGallery(Gallery $gallery)
 {
     $db = Database::getInstance();
     $query = $db->prepare('INSERT INTO gallery (userid,title,tag,created) VALUES (?, ?, ?, ?)');
     $query->execute([$gallery->getUserID(), $gallery->getTitle(), $gallery->getTag(), $gallery->getCreated()]);
 }