﻿
<html>
<head>
<title>Tk liste des sondages</title>
<link rel="stylesheet" media="screen" type="text/css" title="Mon design" href="design.css" />
</head>
<body>
<?php
$affichage="";

if (isset($_GET['id'])){
$affichage.='Sondage n°'.$_GET['id'].'';

//connexion
include('connexion.php');
$sql="SELECT * FROM tk_sondages where pour_le_sondage_numero=".$_GET['id'];
$reponse=mysql_query("$sql") or die( "<br/>erreurrrr $sql  " .mysql_error());

//Titre du sondage 

$t_sql=' SELECT *FROM tk_sondages WHERE id_sondage ="'.$_GET["id"].'"  ';
$t_reponse=mysql_query("$t_sql") or die( "<br/>erreurrrr $t_sql  " .mysql_error());
$t = mysql_fetch_array($t_reponse);
$titre = "<h1> $t[3]</h1><span class=\"notice2\"> <sub>$t[4], Créé le $t[1]. $t[11] Réponses</sub> </span>";


// $donnees[0] = id
// $donnees[1] = date
// $donnees[2] = id_sondage
// $donnees[3] = titre_sondage
// $donnees[4] = sous_titre_sondage
// $donnees[5] = ordre_questions
// $donnees[6] = nature_q
// $donnees[7] = texte_q
// $donnees[8] = contenu_q
// $donnees[9] = pour_le_sondage_numero
// $donnees[10] = num_q
// $donnees[11] = reponse
// $donnees[12] = adress-ip
// $donnees[13] = authuserID
$a_natures=array("DP","DS","DA","V","ON","T","N","C","S","G","L","B","TA");
	foreach ($a_natures AS $k => $value){${$value} ="";}  //initialisation des natures de questions
	//$debug="".$sql;
	//print_r($a_natures);
while($donnees=mysql_fetch_array($reponse))
{

  foreach ($a_natures AS $k => $value)
  {
  //$debug.="<br> value: $value , donnees6 $donnees[6]";
  
  
  	if (($value == "DP")AND $value ==  $donnees[6]) 
	{${$value} .='<br/> '.$donnees[7].' : <input type="text" name="'.$_GET['id'].'_'.$donnees[10].'_pseudo"> ';}
  
	if ($value == "DS" AND $value ==  $donnees[6]) //homme femme
	{${$value} .='<br/>  '.$donnees[7].' : <input type="radio" name="'.$_GET['id'].'_'.$donnees[10].'_genre" value="homme"/> homme,  <input type="radio" name="'.$_GET['id'].'_'.$donnees[10].'" value="femme"/>femme ';}
	
	if ($value == "DA" AND $value ==  $donnees[6]) 
	{${$value} .='<br/>  '.$donnees[7].' : <input type="text" name="'.$_GET['id'].'_'.$donnees[10].'_age" size="3"> ans ';}
	
	if (($value == "T")AND $value ==  $donnees[6]) 
	{${$value} .='<br/>  <input type="text" name="'.$_GET['id'].'_'.$donnees[10].'"> '.$donnees[7].'';}
	
	if (($value == "TA")AND $value ==  $donnees[6]) //textAREA
	{${$value}.='<br/>  <textarea cols="50" rows="4" name="'.$_GET['id'].'_'.$donnees[10].'"></textarea> '.$donnees[7].'';}
	
	if (($value == "N")AND $value ==  $donnees[6]) 
	{${$value} .='<br/>  <input type="text" size="6" name="'.$_GET['id'].'_'.$donnees[10].'"> '.$donnees[7].'';}
	
	
	if ($value == "C" AND $value ==  $donnees[6]) 
	{${$value} .='<br/>  <input type="checkbox" name="'.$_GET['id'].'_'.$donnees[10].'"/ value="1"> '.$donnees[7].'';}
	
	if (($value == "B" OR $value == "ON" )AND $value ==  $donnees[6]) //boolean oui non
	{${$value} .='<br/>  '.$donnees[7].' <input type="radio" name="'.$_GET['id'].'_'.$donnees[10].'" value="oui"/> oui,  <input type="radio" name="'.$_GET['id'].'_'.$donnees[10].'" value="non"/>non ';}
	
	
	if ($value == "V" AND $value ==  $donnees[6]) 
	{
		
		${$value} .='<table width="100%"><tr><td width="20%"><h2> '.$donnees[7].'</h2></td></tr> ';
		$choix_vote = explode(",",$donnees[8]);
		$iv=0;
		foreach ($choix_vote AS $k2 => $v2)
		{
		$iv++;
		${$value} .='<tr><td> <input type="radio" name="'.$_GET['id'].'_'.$donnees[10].'" value="'.$iv.'__'.$v2.'"/> </td><td> '.$donnees[10].' '.$v2.'</td></tr> ';
		}
		${$value} .='</table>';
	}
	if (($value == "L" OR $value == "S" ) AND $value ==  $donnees[6]) 
	{
		${$value} .='<br/>'.$value.' '.$donnees[7].': <select name="'.$_GET['id'].'_'.$donnees[10].'">';
		$choix_vote = explode(",",$donnees[8]);
		foreach ($choix_vote AS $k2 => $v2)
		{
		${$value} .=' <option  value="'.$v2.'">'.$v2.'</option> ';
		}
		${$value} .='</select>';
	}
	if ($value == "G" AND $value ==  $donnees[6]) //gradation
	{
		${$value} .='<table width="100%"><tr><td width="20%">'.$value.' '.$donnees[7].'</td> ';
		$choix_vote = explode(",",$donnees[8]);
		for ($compteur_grad=0;$compteur_grad< $donnees[8] ;$compteur_grad++)
		{
		${$value} .='<td> <input type="radio" name="'.$_GET['id'].'_'.$donnees[10].'" value="'.$compteur_grad.'" />'.$compteur_grad.', </td>';
		}
		${$value} .='</tr></table><br/> ';
	}
	else{ //$debug .=" ELSE ";
	}
  }
	
	}
	$q_affichage="$DP $DS $DA $L $T $N $TA $V $C $B $G $S "; //
	$ordre_questions = explode (", ",$donnees[5]);
	foreach ($ordre_questions AS $k => $v)
	{
	$q_affichage.= $v;
	}

}





//ordonner les questions selon l'ordre


else {$affichage.='Pas de sondage choisi. ';}

$affichage.='<form method="post" action="vote.php" border="1" >
<fieldset>

<br/>
'.$titre.$q_affichage.'
<input type="hidden" name="id" value="'.$_GET['id'].'" />
<br/><input type="submit" value="envoi" />
</fieldset>
</form>';

$affichage.='<br/> <a href="liste_sondages.php" >Aller à la liste des sondages</a>';
echo $affichage;

?>


</body>
</html>