<?php
session_start();

$return = "false";
if(isset($_POST['email'])){
	$email = $_POST['email'];
}
if(isset($_POST['prenom'])){
	$prenom = $_POST['prenom'];
}
if(isset($_POST['datenaissance'])){
	$naissance = $_POST['datenaissance'];
	$naissancetab = explode("/", $naissance);
	$datenaissance = $naissancetab[2]."-".$naissancetab[1]."-".$naissancetab[0];
}
if(isset($_POST['telephone'])){
	$telephone = $_POST['telephone'];
}
if(isset($_POST['signe'])){
	$signe = $_POST['signe'];
}
//$adresse_ip = $REMOTE_ADDR;
$adresse_ip = $_SERVER['REMOTE_ADDR'];
//$web = 2;
//$captcha = $_POST['captcha'];
//$captcha = $_SESSION['qaptcha_key'];
//$_SESSION['qaptcha_key'] = $captcha;
//var_dump($_SESSION['qaptcha_key']);
if(isset($_SESSION['qaptcha_key']) && !empty($_SESSION['qaptcha_key']))
{
	$captcha = $_SESSION['qaptcha_key'];
	
	$host = 'sylvaineey1.mysql.db';
	$user = 'sylvaineey1';
	$passwd = 'oMegsylv1';
	$bdd = 'sylvaineey1';
	$date_now = new DateTime();
	$date_inscription = date_format($date_now, 'Y-m-d H:i:s');
	mysql_connect($host, $user,$passwd) or die("erreur de connexion au serveur");

	mysql_select_db($bdd) or die("erreur de connexion a la base de donnees");
	mysql_query("INSERT INTO membres VALUES('','','','$email','','$prenom','$datenaissance','','','','$adresse_ip','$date_inscription','$signe','','','$telephone','8')");
	
	//mysql_query("INSERT INTO membres VALUES('','','','$email','','$prenom','$datenaissance','','','','','','$signe','','','$telephone','2')");
	//$query = "insert into membres(email,prenom,date_naissance,signe,portable,website_id)
              //    values('$email','$prenom','$datenaissance','$signe','$telephone','2')";

	
     //$result = $this->query($query);

	//while ($donnee = mysqli_fetch_array($req)){
		//echo $donnee["email"];
	//}
	//if($query){
	$return = "true";
	//}
}
else{
	$return = "false";
}

echo $return;
unset($_SESSION['qaptcha_key']);

?>