<?php
$page_id=15;
$mysqli=new sqlite3('admin_lgos/bdd_lgos.sq3');
include ('config.php');
include ('html1.php');
include ('topbar.php');
include ('navbar.php');
include ('header2.php');
echo"$page11";
$s=1;
if(!isset($_POST["nom"])){
$email="";
$noma="";
$sexe="";
$annea="";
$telephonea="";
$adresse="";
$observations="";
}else{
$noma=$_POST["nom"];
$sexe=$_POST["sexe"];
$annea=$_POST["annee"];
$telephonea=$_POST["telephone"];
$email=$_POST["email"];
$adresse=$_POST["adresse"];
$observations=$_POST["observations"];
$noma=addslashes($noma);
$email=strtolower($email);
$s=0;
if($noma==""){$s=1;
$noteko="$Please_enter_your_name!<br>";
}
if($email==""){
$noteko="$noteko <br>$Please_enter_your_email!";
}
if($email!=""){$sde=vemail($email);
if($sde==0){$s=1;
$noteko="$noteko <br>$Please_enter_correctly_your_email!";
}}
if($s==0){
$articles=$mysqli->query("SELECT id FROM $table_utilisateurs WHERE email='$email'");
$nbre=nbre($articles);
if($nbre!=0){$s=1;
$noteko="Changez l'adresse e-mail!";
}else{
$passt=md5($temps);
//Insertion du message
$requete="INSERT INTO $table_utilisateurs (`temps`, `nom`,`sexe`,`annee`, `telephone`, `email`,`adresse`,`pass`,`pouvoir`,`observations`) 
VALUES ('$temps','$noma','$sexe','$annea','$telephonea','$email','$adresse','$passt','4','$observations');";
$resultat=$mysqli->query($requete);
//envoi_mail
$message_mail="Salut!
<br>On vient de s'enregistrer dans le site $titre_site!
<br>Nom: $noma, E-mail : $email, Langue : $languem";
$sujet_mail="$tph[7]";
include ('f_email.php');
$destinataire_mail="$email";
$message_mail="$noma,
$messager";
include ('f_email.php');
$noteok="$Merci_pour_votre_enregistrement! <br>$Voirtonemail!";
$redir="login.php?&l=$l";
refresh2($redir,$tempsrr);
}}
}
$sexefm=sexe(1,2); $chkm=selected(1,$sexe);
$sexeff=sexe(2,2);$chkf=selected(2,$sexe);
include ('oko.php');
if($s==1){
//Formulaire
echo"<div class='container-fluid my-5'>
<div class='container'>
<div class='row align-items-center'>
<div class='col-lg-12 py-5 py-lg-0'>
<h6 class='text-primary text-uppercase font-weight-bold'>$tph[7]</h6>
<h1 class='mb-4'>$tp[15]</h1>
<p class='mb-4'></p>
<form method='POST' action='?l=$l'>
<div class='row'>
<div class='col-md-6'>
<label for='nom'>$Your_name : $obligatoire
<input class='form-control' type='text' name='nom' required value='$noma'></label>
</div>
<div class='col-md-3'>
<label for='sexe'>$Sexe : 
<SELECT class='form-control' NAME='sexe' style=\"width:100%\">
<option value=''>$Selectionnez</option>
<option value='1' $chkm>$sexefm</option>
<option value='2' $chkf>$sexeff</option>
</SELECT></label>
</div>
<div class='col-md-3'>
<label for='annee'>$Annee_de_naissance : 
<SELECT class='form-control' NAME='annee' style=\"width:100%\">
<option value=''>$Selectionnez</option>";
$acdl=$ac-80;$acfl=$ac-20;
for($x=$acdl;$x<=$acfl ;$x++){
$chk=selected($annea,$x);
echo"<option value='$x' $chk>$x</option>";	
}
echo"</SELECT></label>
</div>
<div class='col-md-6'>
<label for='telephone'>$Telephone : 
<input class='form-control' type='text' name='telephone' value='$telephonea'></label>
</div>
<div class='col-md-6'>
<label for='email'>Email : $obligatoire
<input class='form-control' type='email' name='email' value='$email' required></label>
</div>
<div class='col-md-12'>$Adresse :
<textarea class='form-control' name='adresse'>$adresse</textarea></div>
<div class='col-md-12'>Observations :
<textarea class='form-control form-group' name='observations'>$observations</textarea></div>
<div class='col-md-12'>$BEnvoyer</div></div></form>
</div>
</div>
</div>
</div>";
}
echo"$page12";
include ('footer.php');
unset($mysqli);
include ('html2.php');
?>