<?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'];
}
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']))
{

    $url = 'http://www.orianna-voyance.com/ws_qgratuite/';
    $post_data = array(
        "action" => "addQuestion",
        "token" => md5($email."cosmoqgratuite".$prenom),
        "question" => array(
            "firstname" => $prenom,
            "lastname" => $prenom,
            "sexe" => '',
            //m pour homme,
            // f pour femme
            "phone_number" => $telephone,
            // tout accroché, avec le 0 initial pour la france, ou avec l'indicatif au format 00xx pour l'international
            "question" => $question,
            "email" => $email,
            "birthday" => $datenaissance,
            "site" => 19
        )
    );
    //$return = json_encode($post_data);

    $curl = curl_init($url);
    curl_setopt($curl, CURLOPT_POST, true);
    curl_setopt($curl, CURLOPT_POSTFIELDS, http_build_query($post_data));
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    $response = json_decode(curl_exec($curl));
    curl_close($curl);

    if (isset($response->error)) echo "<script>console.log( 'Debug Willl: OK > ');</script>";


    $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']);

?>