Ejemplo n.º 1
0
 public function saveMovies(cw_medias_movies $status)
 {
     $query = $status->getId() ? 'UPDATE cw_medias_movies
                                SET title         = :title,
                                    titleOriginal = :titleOriginal,
                                    realisator    = :realisator,
                                    plot          = :plot,
                                    actors        = :actors,
                                    country       = :country,
                                    type          = :type,
                                    genre         = :genre,
                                    releaseDate   = :releaseDate,
                                    runningTime   = :runningTime,
                                    production    = :production,
                                    distribution  = :distribution,
                                    language      = :language,
                                    warning       = :warning,
                                    archive       = :archive,
                                    addedThe      = :addedThe
                                WHERE id = :id' : 'INSERT INTO cw_medias_movies
                                   (
                                    id,
                                    title,
                                    titleOriginal,
                                    realisator,
                                    plot,
                                    actors,
                                    country,
                                    type,
                                    genre,
                                    releaseDate,
                                    runningTime,
                                    production,
                                    distribution,
                                    language,
                                    warning,
                                    archive,
                                    addedThe
                                   )
                                VALUES
                                   (
                                    :id,
                                    :title,
                                    :titleOriginal,
                                    :realisator,
                                    :plot,
                                    :actors,
                                    :country,
                                    :type,
                                    :genre,
                                    :releaseDate,
                                    :runningTime,
                                    :production,
                                    :distribution,
                                    :language,
                                    :warning,
                                    :archive,
                                    :addedThe
                                  )';
     $query = $this->db->prepare($query);
     $query->execute(['id' => $status->getId(), 'title' => $status->getTitle(), 'titleOriginal' => $status->getTitleOriginal(), 'realisator' => $status->getRealisator(), 'plot' => $status->getPlot(), 'actors' => $status->getActors(), 'country' => $status->getCountry(), 'type' => $status->getType(), 'genre' => $status->getGenre(), 'releaseDate' => $status->getReleaseDate(), 'runningTime' => $status->getRunningTime(), 'production' => $status->getProduction(), 'distribution' => $status->getDistribution(), 'language' => $status->getLanguage(), 'warning' => $status->getWarning(), 'archive' => $status->getArchive(), 'addedThe' => $status->getAddedThe()]);
     return $this->db->lastInsertId();
 }