Sommaire

?>

include("connexion.php");

// insertion dans la base

$date = date("d-m-Y");


$sql2 = "SELECT * FROM T_Cv WHERE (T_Cv_Nom) LIKE ('$form_nom') AND (T_Cv_Prenom) LIKE ('$form_prenom')";

//on envoie la requete
$req2 = mysql_query($sql2) or die("Erreur SQL !<br>".$sql."<br>".mysql_error());
$num_rows = mysql_num_rows($req2);

if(!$num_rows)

{
$insertion = "INSERT INTO T_Cv(T_Cv_Nom,T_Cv_Prenom,T_Cv_Adresse,T_Cv_Cp,T_Cv_Pass,T_Cv_Ville,T_Cv_Tel,T_Cv_Mobile,T_Cv_Email,T_Cv_Val,"
."T_Cv_Age,T_Cv_Nationalite,T_Cv_Permis,"
."T_Cv_Poste_R,T_Cv_Fonction_R,T_Cv_Secteur,T_Cv_Emploi,T_Cv_Disponibilite,"
."T_Cv_Formation_ICD,T_Cv_Specialisation_ICD,"
."T_Cv_Annee_D1,T_Cv_Type_D1,T_Cv_Etabli_D1,T_Cv_Ville_D1,"
."T_Cv_Annee_D2,T_Cv_Type_D2,T_Cv_Etabli_D2,T_Cv_Ville_D2,"
."T_Cv_Annee_Bac,T_Cv_Bac,"
."T_Cv_Annee_Exp1,T_Cv_Entreprise_Exp1,T_Cv_Secteur_Exp1,T_Cv_Duree_Exp1,T_Cv_Mission_Exp1,"
."T_Cv_Annee_Exp2,T_Cv_Entreprise_Exp2,T_Cv_Secteur_Exp2,T_Cv_Duree_Exp2,T_Cv_Mission_Exp2,"
."T_Cv_Annee_Exp3,T_Cv_Entreprise_Exp3,T_Cv_Secteur_Exp3,T_Cv_Duree_Exp3,T_Cv_Mission_Exp3,"
."T_Cv_Langue1,T_Cv_N1,"
."T_Cv_Langue2,T_Cv_N2,"
."T_Cv_Langue3,T_Cv_N3,"
."T_Cv_Info,"
."T_Cv_Sport,T_Cv_Asso,T_Cv_Loisir,T_Cv_Enligne)"
." VALUES ('$form_nom','$form_prenom','$form_adresse','$form_cp','$form_pass','$form_ville','$form_tel','$form_mobile','$form_email','$form_val',"
."'$form_age','$form_nationalite','$form_permis',"
."'$form_poste_r','$form_fonction_r','$form_secteur','$form_emploi','$form_disponibilite',"
."'$form_formation_icd','$form_specialisation_icd',"
."'$form_annee_d1','$form_type_d1','$form_etabli_d1','$form_ville_d1',"
."'$form_annee_d2','$form_type_d2','$form_etabli_d2','$form_ville_d2',"
."'$form_annee_bac','$form_bac',"
."'$form_annee_exp1','$form_entreprise_exp1','$form_secteur_exp1','$form_duree_exp1','$form_mission_exp1',"
."'$form_annee_exp2','$form_entreprise_exp2','$form_secteur_exp2','$form_duree_exp2','$form_mission_exp2',"
."'$form_annee_exp3','$form_entreprise_exp3','$form_secteur_exp3','$form_duree_exp3','$form_mission_exp3',"
."'$form_langue1','$form_n1',"
."'$form_langue2','$form_n2',"
."'$form_langue3','$form_n3',"
."'$form_informatique',"
."'$form_sport','$form_asso','$form_loisir','$form_enligne')";

// echo $insertion;

mysql_query($insertion) or die("Erreur SQL !<br>".$insertion."<br>".mysql_error());

//requete pour afficher le resultat
$sql1 = "SELECT * FROM T_Cv WHERE (T_Cv_Nom) LIKE ('$form_nom') AND (T_Cv_Prenom) LIKE ('$form_prenom') AND (T_Cv_Pass) LIKE ('$form_pass')";

// on envoie la requete
$req1 = mysql_query($sql1) or die("Erreur SQL !<br>".$sql."<br>".mysql_error());

$val=mysql_fetch_array($req1);

// envoi email
$prenom = $val['T_Cv_Prenom'];
$email = $val['T_Cv_Email'];

$message3 = "Bonjour $prenom,\n\n Votre CV a été enregistré: \n\n Merci \n\n Cordialement\n\n stratus";
$objet = "Enregistrement de votre CV dans la base de donnée de ICD";
$headers = "From: <dev2_intranet@hotmail.com>\n";
$headers .= "Reply-To: dev2_intranet@hotmail.com\n";
$headers .= "X-Mailer: PHP/" . phpversion();
$headers .= "X-Sender: <dev2_intranet@hotmail.com\n";
$headers .= "X-Priority: 1\n";
$headers .= "X-MSMail-Priority: High\n";
$headers .= "Return-Path: <dev2_intranet@hotmail.com>\n";
$headers .= "Errors-To: <dev2_intranet@hotmail.com>\n";
$headers .= "Content-Type: text/plain; charset=iso-8859-1\n";
mail($email,$objet,$message3,$headers);

//et on referme la connexion
mysql_close();
}
else
{
//et on referme la connexion
mysql_close();
header("location:refuse.php");
}
?>