<?php
session_start();

$return = "false";
if(isset($_POST['email'])){
	$email = $_POST['email'];
}
if(isset($_POST['prenom'])){
	$prenom = $_POST['prenom'];
}
if(isset($_POST['nom'])){
    $nom = $_POST['nom'];
}
if(isset($_POST['datenaissance'])){
	$naissance = $_POST['datenaissance'];
	$naissancetab = explode("/", $naissance);
	$datenaissance = $naissancetab[2]."-".$naissancetab[1]."-".$naissancetab[0];
}
if (isset($_POST['telephone'])) {
    $telephone = trim($_POST['telephone']);
    $telephone = str_replace(' ', '', $telephone);
    $telephone = preg_replace('/\s+/', '', $telephone);
}
if (isset($_POST['telephone']) && isset($_POST['prefixe']) && $_POST['prefixe']!='33' && is_numeric($_POST['prefixe']) ) {
    $telephone = '00'.$_POST['prefixe'].substr( $telephone, 1 );
}
if(isset($_POST['signe'])){
	$signe = $_POST['signe'];
}
if(isset($_POST['sexe'])){
    $sexe = $_POST['sexe'];
}
if(isset($_POST['question'])){
    $question = $_POST['question'];
}
//$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']))
{	
	
	$host = '81.255.133.42';
	$user = 'omega';
	$passwd = '58v5XSKLNHzpbGX';
	$bdd = 'voyance';
	$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')");


	$return = "true";
    //$return = json_encode($post_data);

}
else{
	$return = "false";
}

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

?>