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
|
<?php
if(!empty($_POST['nom']) && !empty($_POST['civilite'] ) && !empty($_POST['email']) ){//à toi de voir les données requises
$nom=$_POST['nom'];
$civilite=$_POST['civilite'];
$formation=$_POST['list_formations'];
$tel=$_POST['tel'];
$email=$_POST['email'];
$prenom=$_POST['prenom'];
$code_postal=$_POST['code_postal'];
$condition=$_POST['condition'];
$date_naissance=$_POST['date_naissance'];
$niveau=$_POST['niveau'];
$situation=$_POST['situation'];
$motivation=$_POST['motivation'];
$adresse=$_POST['adresse'];
$ville=$_POST['ville'];
$pays=$_POST['pays'];
include("cnx.php");
mysql_query("SET NAMES UTF8") ;
$sql1="insert into educatelWP_prospect (civilite,nom,prenom,tel,email,code_postal,date_naissance,situation_professionnelle,motivation,adresse,pays,ville,niveau) values('".$civilite."','".$nom."','".$prenom."','".$tel."','".$email."','".$code_postal."','".$date_naissance."','".$situation."','".$motivation."','".$adresse."','".$pays."','".$ville."','".$niveau."') ";
$req1 = mysql_query($sql1) or die(mysql_error());
$id_procpet=mysql_insert_id();
$sql2="insert into educatelWP_demande_documentation(date_demande,etat,id_formation,id_procpet) values(now(),'Documentation demandee',".$formation.",".$id_procpet.")";
$req2 = mysql_query($sql2) or die(mysql_error());
if($req2)
{mysql_close(); ?>
<SCRIPT LANGUAGE="JavaScript">
document.location.href="http://www.educatel.ma/?page_id=310"
</SCRIPT>
<?php
}
}else
echo "renseignez tous les champs";
?> |
Partager