1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| public function ajoutDemandes(demandes $demandes, frequences $frequences) {
$sql = "INSERT INTO eur_demandes(id, ref_demande, nat_demande, descrip_demande, freq_demande, statut_demande, date_demande, date_upload, date_download, prix, url) VALUES (:id, :ref_demande, :nat_demande, :descrip_demande, :freq_demande, :statut_demande, :date_demande, :date_upload, :date_download, :prix, :url);";
$stmt = $this->dbh->prepare($sql);
$stmt->bindParam(':id', $demandes->getId());
$stmt->bindParam(':ref_demande', $demandes->getRef_demande());
$stmt->bindParam(':nat_demande', $demandes->getNat_demande());
$stmt->bindParam(':descrip_demande', $demandes->getDescrip_demande());
$stmt->bindParam(':freq_demande', $frequences->getNom());
$stmt->bindParam(':statut_demande', $demandes->getStatut_demande());
$stmt->bindParam(':date_demande', $demandes->getDate_demande()->format('c'));
$stmt->bindParam(':date_upload', $demandes->getDate_upload()->format('c'));
$stmt->bindParam(':date_download', $demandes->getDate_download()->format('c'));
$stmt->bindParam(':prix', $demandes->getPrix());
$stmt->bindParam(':url', $demandes->getUrl());
$stmt->execute();
} |
Partager