next_record()) { $PK_Contact = $dbcontact->Record[PKcontact]; $FKSC = $dbcontact->Record[FKsecurite]; $FKtypeC = $dbcontact->Record[FKtypeContact]; $FKuser = $dbcontact->Record[FKuser]; $titreC = $dbcontact->Record[titreContact]; $desC = $dbcontact->Record[desContact]; $categC = $dbcontact->Record[categContact]; $adrC = $dbcontact->Record[adrContact]; $cpC = $dbcontact->Record[CPContact]; $villeC = $dbcontact->Record[villeContact]; $paysC = $dbcontact->Record[paysContact]; $melC = $dbcontact->Record[melContact]; $tel1C = $dbcontact->Record[tel1Contact]; $tel2C = $dbcontact->Record[tel2Contact]; $faxC = $dbcontact->Record[faxContact]; $sitewebC = $dbcontact->Record[sitewebContact]; $anneesortieC = $dbcontact->Record[anneesortieContact]; $nationaliteC = $dbcontact->Record[nationaliteContact]; $nationaliteAffichC = $dbcontact->Record[nationaliteAffich]; $adrAffichC = $dbcontact->Record[adrContactAffich]; $orgAffichC = $dbcontact->Record[orgAffich]; $tel1AffichC = $dbcontact->Record[tel1Affich]; $tel2AffichC = $dbcontact->Record[tel2Affich]; $faxAffichC = $dbcontact->Record[faxAffich]; $melAffichC = $dbcontact->Record[melAffich]; $sitewebAffichC = $dbcontact->Record[sitewebAffich]; $commentaireAudioC = $dbcontact->Record[commentaireAudioContact]; $commentaireAudioAffichC = $dbcontact->Record[commentaireAudioAffich]; $autreOeuvreC = $dbcontact->Record[autreOeuvreContact]; $autreOeuvreAffichC = $dbcontact->Record[autreOeuvreAffich]; $titreMemC = $dbcontact->Record[titreMemContact]; $titreMemAffichC = $dbcontact->Record[titreMemAffich]; $sqluser = "select * from user where PKuser = ".$_POST['pk_user']; $dbuser = new class_db($sqluser); if ($dbuser->next_record()) { $modif = 1; $FKSU = $dbuser->Record[Fksecurite]; $nomU = $dbuser->Record[nom]; $prenomU = $dbuser->Record[prenom]; $civiliteU = $dbuser->Record[civilite]; $loginU = $dbuser->Record[login]; $pswU = $dbuser->Record[psw]; $dateNaissanceU = $dbuser->Record[dateNaissance]; $dateNAffichU = $dbuser->Record[dateNAffich]; $civiliteAffichU = $dbuser->Record[civiliteAffich]; $sqlorg = "select organisme.PKorganisme, organisme.FKsecurite, organisme.raisonSOrg, organisme.desOrg, organisme.adrOrg, organisme.CPOrg, organisme.villeOrg, organisme.paysOrg, organisme.melOrg, organisme.tel1Org, organisme.tel2Org, organisme.faxOrg, organisme.sitewebOrg, organisme.securiteOrg, appartenance.adrAffich, appartenance.tel1Affich, appartenance.tel2Affich, appartenance.faxAffich, appartenance.melAffich from organisme, appartenance "; $sqlorg .= "where appartenance.FKcontact = ".$PK_Contact." and appartenance.FKorganisme = organisme.PKorganisme"; // and appartenance.isonlineApp = 1 and organisme.isonlineOrg = 1 and securiteApp <= ".$secure_id." and organisme.securiteOrg <= ".$secure_id; $dborg = new class_db($sqlorg); if ($dborg->next_record()) { $PKorganisme = $dborg->Record[PKorganisme]; $FKSO = $dborg->Record[FKsecurite]; $raisonSO = $dborg->Record[raisonSOrg]; $desO = $dborg->Record[desOrg]; $adrO = $dborg->Record[adrOrg]; $cpO = $dborg->Record[CPOrg]; $villeO = $dborg->Record[villeOrg]; $paysO = $dborg->Record[paysOrg]; $melO = $dborg->Record[melOrg]; $tel1O = $dborg->Record[tel1Org]; $tel2O = $dborg->Record[tel2Org]; $faxO = $dborg->Record[faxOrg]; $sitewebO = $dborg->Record[sitewebOrg]; $securiteO = $dborg->Record[securiteOrg]; $adrAffichO = $dborg->Record[adrAffich]; $tel1AffichO = $dborg->Record[tel1Affich]; $tel2AffichO = $dborg->Record[tel2Affich]; $faxAffichO = $dborg->Record[faxAffich]; $melAffichO = $dborg->Record[melAffich]; $IsCreaOrg = 0; } else { $sqlapp = "select PKorganisme from organisme, appartenance where appartenance.FKcontact = ".$PK_Contact." and appartenance.FKorganisme = organisme.PKorganisme"; $dbapp = new class_db($sqlapp); if ($dbapp->next_record()) { $IsCreaOrg = 0; }else{ $IsCreaOrg = 1; } } } else { $NonTrouve = 1; } } else { $NonTrouve = 1; } ?>
 
 
 

 
 
  

  
nationalit
ne le
"; }?>  "; }?> "; }?> "; }?> "; }?> "; }?> "; }?>
"; }?> "; }?>  "; }?> "; }?> "; }?> "; }?> "; }?> "; }?> "; }?>


 tudes
DEPARTEMENT
PROMOTION

mmoire :

num_rows(); if ($nbfilmcontact > 0) { while ($db->next_record()) { $fonctionC = $db->Record[fonction]; $titreF = $db->Record[titreFilm]; $anneeF = $db->Record[anneeFilm]; $typeexoF = $db->Record[typeexoFilm]; $genreF = $db->Record[genreFilm]; ?> ".$titreF." "; }?>

  num_rows(); if ($nbfilmcontact > 0) { $lenbfilm = 0; while ($db->next_record()) { $fonctionC = $db->Record[fonction]; $remunerationFilmC = $db->Record[remuneration]; $statutEmploiFilmC = $db->Record[statutEmploi]; $titreF = $db->Record[titreFilm]; $genreF = $db->Record[genreFilm]; $metragecineF = $db->Record[metragecineFilm]; $metragetvF = $db->Record[metragetvFilm]; $metrageautreF = $db->Record[metrageautreFilm]; $dureeF = $db->Record[dureeFilm]; $anneeF = $db->Record[anneeFilm]; $realisateurF = $db->Record[realisateurFilm]; $employeurF = $db->Record[employeurFilm]; if ($lenbfilm == 0) { echo ' filmographie
'; } ?> ".$titreF." - "; }?>


'; } if ($nbfilmcontact > 0) { $lenbfilm2 = 0; while ($dbfilm->next_record()) { $FKfilmC = $dbfilm->Record[FKfilm]; $titreF = $dbfilm->Record[titreFilm]; $sql3 = "select * from prixfilm where FKfilm = $FKfilmC ORDER BY anneePFilm DESC"; $db3 = new class_db($sql3); $nbprix = $db3->num_rows(); if ($nbprix > 0) { $lenbpx = 0; while ($db3->next_record()) { $FKprixfilm = $db3->Record[PKprixfilm]; $FKfestivalPFilm = $db3->Record[FKfestival]; $anneePF = $db3->Record[anneePFilm]; $prixPF = $db3->Record[prixPFilm]; $festivalPF = $db3->Record[festivalPFilm]; $affichPF='O'; $sql3bis = "select * from affichprixfilm where FKprixfilm = ".$FKprixfilm." AND FKcontact=".$PK_Contact; $db3bis = new class_db($sql3bis); while ($db3bis->next_record()) { $affichPF = $db3bis->Record[affichPF]; } if ($affichPF == 'O') { if ($lenbfilm2 == 0) { echo ' slections et prix
'; } if ($lenbpx == 0) { echo "".$titreF."
"; } //echo strtolower($prixPF); echo ucfirst($prixPF); if ($festivalPF != '') { echo " au ".ucfirst($festivalPF).", "; } else { echo ", "; } echo $anneePF."
"; $lenbpx++; $lenbfilm2++; } } } } } if ($lenbfilm2 != 0) { echo '


'; } //recup info emplois secteur cin $sql = "select * from emploi where FKcontact = ".$PK_Contact." AND liencineEmploi = 'O' AND affichEmploi = 'O' ORDER BY anneeDebutEmploi DESC"; $db = new class_db($sql); $nbemploi = $db->num_rows(); if (($nbemploi > 0) || (($autreOeuvreAffichC == 'O')&&($autreOeuvreC != '')) || (($commentaireAudioAffichC == 'O')&&($commentaireAudioC != ''))) { ?>  autres
next_record()) { $posteemploiC = $db->Record[posteEmploi]; $anneedebutemploiC = $db->Record[anneeDebutEmploi]; $anneefinemploiC = $db->Record[anneeFinEmploi]; $employeurC = $db->Record[employeurEmploi]; echo $posteemploiC; if ($employeurC != "") { echo " chez ".$employeurC; } if ($anneefinemploiC != "") { echo " de $anneedebutemploiC $anneefinemploiC"; }else{ echo " depuis $anneedebutemploiC"; } echo "
"; } } ?>
"; }?>
  Enregistrer la fiche               Imprimer la fiche