<?php
header('Access-Control-Allow-Origin: *');

$servername = "localhost";
$username = "root";
$password = "";
if(isset($_POST['reponse'])) {
    $osf16 = "question16";
    $osf18 = "question18";
    $osf19 = "question19";
    $osf21 = "question21";
    $osf24 = "question24";
    $osf33 = "question33";
    $osf46 = "question46";
    $osf30 = "question30";
    $osf34 = "question34";
    $osf38 = "question38";
    $osf36 = "question36";

    $question16 = "";
    $question18 = "";
    $question19 = "";
    $question21 = "";
    $question24 = "";
    $question33 = "";
    $question46 = "";
    $question30 = "";
    $question34 = "";
    $question36 = "";
    $question38 = "";


    $json1 = $_POST['reponse'];
    $jsonQu = json_decode($json1);
    $question3 = $jsonQu->question3;
    $question4 = $jsonQu->question4;
    $question5 = $jsonQu->question5;
    $question6 = $jsonQu->question6;
    $question7 = $jsonQu->question7;
    $question8 = $jsonQu->question8;
    $question9 = $jsonQu->question9;
    $question10 = $jsonQu->question10;
    $question12 = $jsonQu->question12;
    $question13 = $jsonQu->question13;
    $question14 = $jsonQu->question14;
    $question15 = $jsonQu->question15;
    foreach($jsonQu->question16 as $key16 => $data16)
    {
        if(strstr($key16,$osf16))
        {
            $question16 .= $data16.",";
        }

    }
    foreach($jsonQu->question18 as $key18 => $data18)
    {
        if(strstr($key18,$osf18))
        {
            $question18 .= $data18.",";
        }

    }
    foreach($jsonQu->question19 as $key19 => $data19)
    {
        if(strstr($key19,$osf19))
        {
            $question19 .= $data19.",";
        }

    }
    $question20 = $jsonQu->question20;
    foreach($jsonQu->question21 as $key => $data)
    {
        if(strstr($key,$osf21))
        {
            $question21 .= $data.",";
        }
    }
    foreach($jsonQu->question24 as $key24 => $data24)
    {
        if(strstr($key24,$osf24))
        {
            $question24 .= $data24.",";
        }

    }
    $question25 = $jsonQu->question25;
//$question28 = $jsonQu->question28;
    $question29 = $jsonQu->question29;
    foreach($jsonQu->question30 as $key30 => $data30)
    {
        if(strstr($key30,$osf30))
        {
            $question30 .= $data30.",";
        }
    }
    $question32 = $jsonQu->question32;
    foreach($jsonQu->question33 as $key33 => $data33)
    {
        if(strstr($key33,$osf33))
        {
            $question33 .= $data33.",";
        }
    }
    foreach($jsonQu->question34 as $key34 => $data34)
    {
        if(strstr($key34,$osf34))
        {
            $question34 .= $data34.",";
        }
    }
    foreach($jsonQu->question36 as $key36 => $data36)
    {
        if(strstr($key36,$osf36))
        {
            $question36 .= $data36.",";
        }
    }
    foreach($jsonQu->question38 as $key38 => $data38)
    {
        if(strstr($key38,$osf38))
        {
            $question38 .= $data38.",";
        }
    }
    $question39 = $jsonQu->question39;
    $question40 = $jsonQu->question40;
    $question42 = $jsonQu->question42;
    $question43 = $jsonQu->question43;

    foreach($jsonQu->question46 as $key46 => $data46)
    {
        if(strstr($key46,$osf46))
        {
            $question46 .= $data46.",";
        }
    }
    $question47 = $jsonQu->question47;

    $question49 = $jsonQu->question49;
    $question50 = $jsonQu->question50;
    $question51 = $jsonQu->question51;
}

if(isset($_POST['sliderDiversity'])) {
    $json = $_POST['sliderDiversity'];
    $jsonTab = json_decode($json);
    $question17 = $jsonTab->question17HF.",". $jsonTab->question17JEUNES .",". $jsonTab->question17AMATEURS.",".$jsonTab->question17SIMILAIRE;
    $question23 = $jsonTab->question23FLUIDE.",".$jsonTab->question23SACADEE.",".$jsonTab->question23RELACHEE.",".$jsonTab->question23TONIQUE.",".$jsonTab->question23FLOTTANTE.",".$jsonTab->question23LENTE.",".$jsonTab->question23RAPIDE;
    $question27 = $jsonTab->question27RED.",".$jsonTab->question27GREEN.",".$jsonTab->question27BLUE;
    $question35 = $jsonTab->question35DOUCE.",".$jsonTab->question35RYTHMEE.",".$jsonTab->question35ENVELOPPANTE.",".$jsonTab->question35AGGRESIVE.",".$jsonTab->question35ANGOISSANTE.",".$jsonTab->question35ENTRAINANTE.",".$jsonTab->question35EMOUVANTE;
    $question48 = $jsonTab->question48JOIE.",".$jsonTab->question48PLAISIR.",".$jsonTab->question48COLERE.",".$jsonTab->question48DEGOUT.",".$jsonTab->question48SURPRISE.",".$jsonTab->question48PEUR.",".$jsonTab->question48EXCITATION.",".$jsonTab->question48FRISSON.",".$jsonTab->question48ENNUI.",".$jsonTab->question48TRISTESSE.",".$jsonTab->question48EMERVEILLEMENT.",".$jsonTab->question48FRUSTRATION.",".$jsonTab->question48EMPATHIE.",".$jsonTab->question48LARMES;
}

try {
    $conn = new PDO("mysql:host=$servername;dbname=datadanse", $username, $password);
// set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = $conn->prepare("INSERT INTO reponsequestion(question3,question4,question5,question6,question7,question8,question9,question10,question12,question13,question14,question15,question16,question17,question18,question19,question20,question21,question23,question24,question25,question27,question29,question30,question32,question33,question34,question35,question36,question38,question39,question40,question42,question43,question46,question47,question48,question49,question50,question51)
VALUES ('$question3','$question4','$question5','$question6','$question7','$question8','$question9','$question10','$question12','$question13','$question14','$question15','$question16','$question17','$question18','$question19','$question20','$question21','$question23','$question24','$question25','$question27','$question29','$question30','$question32','$question33','$question34','$question35','$question36','$question38','$question39','$question40','$question42','$question43','$question46','$question47','$question48','$question49','$question50','$question51')");
    $sql->execute();
    $userID = $conn->lastInsertId();
    $id= array();
    $id['id'] = $userID;
    echo(json_encode($id));
    $conn->exec("set names utf8");

    echo "Connected successfully";
}
catch(PDOException $e)
{
    echo "Connection failed: " . $e->getMessage();
}
//var_dump($_POST);



?>