code fait rapidement, a l'arrache, c'est moche, c'est lent, mais ca a le merite de te donner quelques indices
<?php
function newQuestion(){
return '
<input type="text" name="question" value="entrez une question supplementaire ici "/>
<div class="plusmoinsbox">
<input type="button" onclick="add(\'reponsesBox\')" value="+"/>
<input type="button" onclick="del(\'reponsesBox\')" value="-"/>
</div>
<div id="reponsesBox">
<div>
<input type="checkbox" name="is[]" value="ok" />
reponse <input type="text" name="reponse[]" />
</div>
</div>
';
}
function insertName($nom){
$nom=strtolower(htmlentities($nom));
$nom=strtoupper($nom[0]).substr($nom, 1);
$a=mysql_query('INSERT INTO personnes SET nom="'.$nom.'"');
if ($a===false){
$a=mysql_query('SELECT id FROM personnes WHERE nom="'.$nom.'"') or die(mysql_error());
$data=mysql_fetch_assoc($a);
if ($data===false){
echo 'Personne a ce nom !';
return false;
}
$id=$data['id'];
echo $id;
}else{
$id=mysql_insert_id();
}
foreach ($_SESSION['reponses'] as $r){
mysql_query('INSERT INTO link SET id_personne='.$id.', id_reponse='.$r);
}
return true;
}
session_start();
mysql_connect('', '', '') or die(mysql_error());
//met ici tes identifiants de connections...
//mysql_query('DROP DATABASE QuestionsReponses') or die(mysql_error());
mysql_query('CREATE DATABASE IF NOT EXISTS QuestionsReponses') or die(mysql_error());
mysql_query('USE QuestionsReponses') or die(mysql_error());
mysql_query('CREATE TABLE IF NOT EXISTS question(
id int unsigned auto_increment,
question text,
primary key(id)
)') or die(mysql_error());
mysql_query('CREATE TABLE IF NOT EXISTS reponse(
id int unsigned auto_increment,
id_question int unsigned,
reponse varchar(200),
primary key(id)
)') or die(mysql_error());
mysql_query('CREATE TABLE IF NOT EXISTS personnes(
id int unsigned auto_increment,
nom varchar(200),
primary key(id),
unique(nom)
)') or die(mysql_error());
mysql_query('CREATE TABLE IF NOT EXISTS link(
id_personne int unsigned,
id_reponse int unsigned,
unique(id_personne, id_reponse)
)') or die(mysql_error());
echo '
<html>
<head>
<style>
input[type="text"]{
width:80%;
border:0px solid;
border-bottom:1px solid #000;
background: #EEE;
}
.plusmoinsbox{
width:10%;
border:1px solid #AAA;
text-align:center;
margin:10px;
}
#reponsesBox{
width:90%;
border:1px solid #AAA;
margin-left:auto;
margin-right:auto;
padding:10px;
margin-top:10px;
margin-bottom:10px;
}
</style>
<script type="text/javascript">
var counter=1;
function add(id){
var e=document.getElementById(id);
var fc=e.firstChild;
while (fc.nodeName!="DIV") fc=fc.nextSibling;
var clfc = fc.cloneNode(true);
e.appendChild(clfc);
counter++;
}
function del(id){
if (counter==1) return;
var e=document.getElementById(id);
var fc=e.lastChild;
while (fc.nodeName!="DIV") fc=fc.previousSibling;
e.removeChild(fc);
counter--;
}
</script>
</head>
<body>
<form action="questionsreponses.php" method="post">
';
if (!isset($_SESSION['reponses']))
$_SESSION['reponses']=array();
if (!isset($_SESSION['questions']))
$_SESSION['questions']=array();
if (isset($_POST['autre_question'])){
$_SESSION['questions'][]=intval($_POST['idq']);
$_SESSION['questions']=array_unique($_SESSION['questions']);
}else if (isset($_POST['clean'])){
$_SESSION['reponses']=array();
$_SESSION['questions']=array();
}else if (isset($_POST['reponse'])){
if (isset($_POST['question'])){
mysql_query('INSERT INTO question SET question="'.htmlentities($_POST['question']).'"')
or die(mysql_error());
$qid=mysql_insert_id();
$_SESSION['questions'][]=$qid;
foreach ($_POST['reponse'] as $i=>$q){
mysql_query('INSERT INTO reponse SET reponse="'.htmlentities($q).'", id_question='.$qid)
or die(mysql_error());
if (isset($_POST['is'][$i])){
$_SESSION['reponses'][]=mysql_insert_id();
}
$_SESSION['reponses']=array_unique($_SESSION['reponses']);
$_SESSION['questions']=array_unique($_SESSION['questions']);
}
}else if(isset($_POST['idq'])){
$_SESSION['questions'][]=intval($_POST['idq']);
foreach ($_POST['reponse'] as $i=>$on){
$_SESSION['reponses'][]=$i;
}
$_SESSION['reponses']=array_unique($_SESSION['reponses']);
$_SESSION['questions']=array_unique($_SESSION['questions']);
}
}else if (isset($_POST['nom'])){
insertName($_POST['nom']);
}else if (isset($_POST['autre_nom'])){
insertName($_POST['autre_nom']);
}
$List=implode(', ', $_SESSION['reponses']);
$QList=implode(', ', $_SESSION['questions']);
if ($List!=''){
$suspects=mysql_query('
SELECT id_personne, COUNT(*) as count,
(SELECT nom FROM personnes WHERE personnes.id=link.id_personne) AS nom
FROM link WHERE id_reponse IN ('.$List.')
GROUP BY id_personne
HAVING '.count($_SESSION['reponses']).'=count
') or die(mysql_error());
$nombre_suspects = mysql_num_rows($suspects);
}else{
$suspects=false;
$nombre_suspects=-1;
$List='0';
$QList='0';
}
if ($nombre_suspects==1){
$data=mysql_fetch_assoc($suspects);
echo '<p>'.$data['nom'].'</p>
<input type="text" name="autre_nom" value="sinon, qui est-ce ?" />';
}else if ($nombre_suspects==0){
echo '
<input type="text" name="nom" value="qui est-ce ?" />
';
}else{
$req=mysql_query('
SELECT
id, question,
(
SELECT MAX((SELECT COUNT(*) FROM link WHERE id_reponse=reponse.id
AND id_personne IN
(SELECT id_personne FROM link WHERE id_reponse IN ('.$List.') )
/*ici, il manque une notion d\'ordre, c\'est mauvais,*/
/*mais ca devrait fonctionner a peu pres correctement*/
))
FROM reponse
WHERE id_question = question.id
) as max
FROM question
WHERE id NOT IN ('.$QList.')
ORDER BY max DESC
') or die(mysql_error());
if (mysql_num_rows($req)==0){
echo newQuestion();
}else{
$data=mysql_fetch_assoc($req);
echo '<div id="question">'.$data['question'].' ('.$data['max'].')</div>
<input type="hidden" name="idq" value="'.$data['id'].'" />';
$req=mysql_query('SELECT reponse, id FROM reponse WHERE id_question='.$data['id']) or die(mysql_error());
while ($data=mysql_fetch_assoc($req)){
echo '<div class="reponse">
<input type="checkbox" name="reponse['.$data['id'].']" />'.$data['reponse'].'</div>';
}
echo '<input type="submit" value="autre question" name="autre_question"/>';
}
}
echo '
<br />
<input type="submit" value="poster"/>
<br />
<input type="submit" value="effacer mes reponses" name="clean"/>
</form>';
if ($suspects!==false){
$suspects=mysql_query('
SELECT id_personne, COUNT(*) * 100 / '.count($_SESSION['reponses']).' as count,
(SELECT nom FROM personnes WHERE personnes.id=link.id_personne) AS nom
FROM link WHERE id_reponse IN ('.$List.')
GROUP BY id_personne
') or die(mysql_error());
echo '</ul>
<ul id="suspects">';
while ($data=mysql_fetch_assoc($suspects)){
echo '<li>'.$data['nom'].' ('.intval($data['count']).' %)</li>';
}
echo '</ul>';
}
echo '
</body>
</html>
';
?>