<?php
$test = 1;
$debug = 0;
$section = "garderie";

if($test == 1) {
	$mysql_host = 'localhost';
	$mysql_user = 'root';
	$mysql_pass = '';
	$mysql_db = 'majeunes_admin';
}
else {
	$mysql_host = 'db.majeunesse.app';
	$mysql_user = 'majeunes_prep';
	$mysql_pass = 'Mikael010';
	$mysql_db = 'majeunes_admin';
}

$conni = mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_db);
if (!$conni) {
    die("MySQL Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conni,"utf8mb4");


$timestamp = date("Y-m-d H:i:s");

$sondage_public_id = mysqli_real_escape_string($conni, $_POST['sondage_id']);
$gard_id = mysqli_real_escape_string($conni, $_POST['gard_id']);

$query_sondage = mysqli_query($conni, "SELECT * FROM sondages WHERE public_id = '$sondage_public_id'");
$sondage_id = mysqli_result($query_sondage,0,"id");

$numero_compte = mysqli_result(mysqli_query($conni,"SELECT * FROM sondages_access WHERE public_id = '$gard_id' AND sondage_id = '$sondage_id'"),0,"numero_compte");

$query_questions = mysqli_query($conni,"SELECT * FROM sondages_questions WHERE sondage_id = '$sondage_id'");
$questions_result = mysqli_num_rows($query_questions);

for($i=0;$i<$questions_result;$i++) {
	$question_id = mysqli_result($query_questions,$i,"id");
	$question_type = mysqli_result($query_questions,$i,"type");
	
	if($question_type == 4) { //Multiple answers
		
	}
	else {
		$reponse = mysqli_real_escape_string($conni,$_POST["q$question_id"]);
	}
	
	if($reponse != "") {
		$query_resultat = mysqli_query($conni,"SELECT * FROM sondages_resultats WHERE sondage_id = '$sondage_id' AND garderie_id = '$numero_compte' AND question_id = '$question_id'");
		$result_resultat = mysqli_num_rows($query_resultat);
		
		if($result_resultat == 0) {
			mysqli_query($conni,"INSERT INTO sondages_resultats VALUES ('','$timestamp','','$sondage_id','$numero_compte','$question_id','$reponse')");
		}
		else {
			mysqli_query($conni,"UPDATE sondages_resultats SET reponse = '$reponse', timestamp_updated = '$timestamp' WHERE sondage_id = '$sondage_id' AND garderie_id = '$numero_compte' AND question_id = '$question_id'");
		}
	}
}

function mysqli_result($res,$row=0,$col=0){ 
    $numrows = mysqli_num_rows($res); 
    if ($numrows && $row <= ($numrows-1) && $row >=0){
        mysqli_data_seek($res,$row);
        $resrow = (is_numeric($col)) ? mysqli_fetch_row($res) : mysqli_fetch_assoc($res);
        if (isset($resrow[$col])){
            return $resrow[$col];
        }
    }
    return false;
}
?>