1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
|
function ajoutEntreprise($nom_ent,$tel_ent,$adr_ent,$resum_ent_fr,$resum_ent_en,$desc_ent_fr,$desc_ent_en,$tel_contact_ent,$email_contact_ent,$url_site_ent,$num_com_phot,$engagement_ent,$adr_ip_ent,$valide_ent,$ville_ent,$date_ent,$num_loc,$num_act,$url_phot){
$bdd=getBdd();
$sql="Insert into entreprises(nom_ent,tel_ent,adr_ent,resum_ent_fr,resum_ent_en,desc_ent_fr,desc_ent_en,tel_contact_ent,email_contact_ent,url_site_ent,num_com_phot,engagement_ent,adr_ip_ent,valide_ent,ville_ent,date_ent,num_loc,num_act) values(:nom_ent,:tel_ent,:adr_ent,:resum_ent_fr,:resum_ent_en,:desc_ent_fr,:desc_ent_en,:tel_contact_ent,:email_contact_ent,:url_site_ent,:num_com_phot,:engagement_ent,:adr_ip_ent,:valide_ent,:ville_ent,:date_ent,:num_loc,:num_act)";
try{
$trait = $bdd->prepare($sql);
$retour = $trait->execute(array('nom_ent'=>$nom_ent,'tel_ent'=>$tel_ent,'adr_ent'=>$adr_ent,'resum_ent_fr'=>$resum_ent_fr,'resum_ent_en'=>$resum_ent_en,'desc_ent_fr'=>$desc_ent_fr,'desc_ent_en'=>$desc_ent_en,'tel_contact_ent'=>$tel_contact_ent,'email_contact_ent'=>$email_contact_ent,'url_site_ent'=>$url_site_ent,'num_com_phot'=>$num_com_phot,'engagement_ent'=>$engagement_ent,'adr_ip_ent'=>$adr_ip_ent,'valide_ent'=>$valide_ent,'ville_ent'=>$ville_ent,'date_ent'=>$date_ent,'num_loc'=>$num_loc,'num_act'=>$num_act));
}catch(PDOException $e){
echo "ERREUR INSERTION ENTREPRISE EN BASE: ajoutEntreprise()" .$e->getMessage() ."</br>";
}
//--insertion photo
$sql1="Insert into photos(num_com_phot, type_phot,titre_phot_fr, titre_phot_en, url_phot, valid_phot) values(:num_com_phot, :type_phot,:titre_phot_fr, :titre_phot_en, :url_phot, :valid_phot)";
$type_phot="ENTREPRISE";
$val_phot="NON";
try{
$ltrait=$bdd->prepare($sql1);
$retour1=$ltrait->execute(array('num_com_phot'=>$num_com_phot, 'type_phot'=>$type_phot,'titre_phot_fr'=>$nom_ent, 'titre_phot_en'=>$nom_ent, 'url_phot'=>$url_phot, 'valid_phot'=>$val_phot));
}catch(PDOException $e){
echo "ERREUR INSERTION PHOTOS BASE: ajoutEntreprise() " .$e->getMessage() ."</br>";
}
//-- comment savoir que les insertions se sont bien passées pour affecter 1 à $ltrait ici ?
$ltrait=1;
return $ltrait;
if($bdd){
$bdd = NULL;
}
}
function ajoutDe($titre_dal_fr,$titre_dal_en, $resum_dal_fr, $resum_dal_en, $desc_dal_fr,$desc_dal_en,$num_com_phot,$date_debut_dal,$date_fin_dal,$adr_ip_dal,$date_enr_dal,$valide_dal,$num_ent,$num_cat_dal,$url_phot){
$bdd=getBdd();
$sql="Insert into deal(titre_dal_fr,titre_dal_en, resum_dal_fr, resum_dal_en, desc_dal_fr,desc_dal_en,num_com_phot,date_debut_dal,date_fin_dal,adr_ip_dal,date_enr_dal,valide_dal,num_ent,num_cat_dal ) values(:titre_dal_fr,:titre_dal_en, :resum_dal_fr, :resum_dal_en, :desc_dal_fr,:desc_dal_en,:num_com_phot,:date_debut_dal,:date_fin_dal,:adr_ip_dal,:date_enr_dal,:valide_dal,:num_ent,:num_cat_dal )";
try{
$trait = $bdd->prepare($sql);
$retour = $trait->execute(array('titre_dal_fr'=>$titre_dal_fr,'titre_dal_en'=>$titre_dal_en, 'resum_dal_fr'=>$resum_dal_fr, 'resum_dal_en'=>$resum_dal_en, 'desc_dal_fr'=>$desc_dal_fr,'desc_dal_en'=>$desc_dal_en,'num_com_phot'=>$num_com_phot,'date_debut_dal'=>$date_debut_dal,'date_fin_dal'=>$date_fin_dal,'adr_ip_dal'=>$adr_ip_dal,'date_enr_dal'=>$date_enr_dal,'valide_dal'=>$valide_dal,'num_ent'=>$num_ent,'num_cat_dal'=>$num_cat_dal ));
}catch(PDOException $e){
echo "ERREUR INSERTION DEAL EN BASE: ajoutDeal()" .$e->getMessage() ."</br>";
}
//--insertion photo
$sql1="Insert into photos(num_com_phot, type_phot, titre_phot_fr, titre_phot_en, url_phot, valid_phot) values(:num_com_phot, :type_phot, :titre_phot_fr, :titre_phot_en, :url_phot, :valid_phot)";
$type_phot="DEL";
$val_phot="NON";
try{
$ltrait=$bdd->prepare($sql1);
$retour1=$ltrait->execute(array('num_com_phot'=>$num_com_phot, 'type_phot'=>$type_phot,'titre_phot_fr'=>$titre_dal_fr, 'titre_phot_en'=>$titre_dal_en, 'url_phot'=>$url_phot, 'valid_phot'=>$val_phot));
}catch(PDOException $e){
echo "ERREUR INSERTION PHOTOS BASE: ajoutDe() " .$e->getMessage() ."</br>";
}
//-- comment savoir que les insertions se sont bien passées pour affecter 1 à $ltrait ici ?
$ltrait=1;
return $ltrait;
if($bdd){
$bdd = NULL;
}
} |
Partager