J'ai un problème avec le code de sondage ci dessous, les résultat ne semblent pas s'enregistrer, et donc pas conséquent les résultats ne s'affichent pas
Vous pouvez voir a cette adresse: http://www.platomic-junior.com/~ffzone/vote.php
Voila le code qui pose problème:
<html>
<head>
<title>Sondage</title>
</head>
<body>
<?
print '<script language="javascript">
function sonde()
{
newWindow=open("","Sondage","width=250,height=200,scrolling=no,resizable=no,scrollbars=yes");
newWindow.focus();
location.reload();
}
</script>';
include("config.php");
include("lib_log.php");
$link = opendb();
$query = doquery ("SELECT * FROM {{table}} ORDER BY id DESC LIMIT 0,1", "sondage");
$resultat = mysql_fetch_array($query);
{
$id_sondage = $resultat[id];
print '
<form method="POST" action="resultvote.php?id='.$id_sondage.'" target="Sondage" onsubmit="sonde()">
<b>'.$resultat[question].'</b><br><br>
';
$re_1 = $resultat[reponse1];
$re_2 = $resultat[reponse2];
$re_3 = $resultat[reponse3];
$re_4 = $resultat[reponse4];
if(!empty($resultat[reponse1]))
{
print '<input type="radio" value="1" name="reponse"> '.$resultat[reponse1].'<br>';
}
if(!empty($resultat[reponse2]))
{
print '<input type="radio" value="2" name="reponse"> '.$resultat[reponse2].'<br>';
}
if(!empty($resultat[reponse3]))
{
print '<input type="radio" value="3" name="reponse"> '.$resultat[reponse3].'<br>';
}
if(!empty($resultat[reponse4]))
{
print '<input type="radio" value="4" name="reponse"> '.$resultat[reponse4].'<br>';
}
}
print '
<br>
<input type="submit" value="Ok !">
</form>
<br>
';
$query = doquery ( "SELECT * FROM {{table}} WHERE numero='$id_sondage'","resultats");
echo mysql_num_rows($query);
if($votes == 0)
{
$votes = 1;
}
$query = doquery ("SELECT * FROM {{table}} WHERE numero='$id_sondage' AND reponse='1'","resultats");
$rep1 = mysql_num_rows($query);
$query = doquery ("SELECT * FROM {{table}} WHERE numero='$id_sondage' AND reponse='2'","resultats");
$rep2 = mysql_num_rows($query);
$query = doquery ("SELECT * FROM {{table}} WHERE numero='$id_sondage' AND reponse='3'","resultats");
$rep3 = mysql_num_rows($query);
$query = doquery ("SELECT * FROM {{table}} WHERE numero='$id_sondage' AND reponse='4'","resultats");
$rep4 = mysql_num_rows($query);
$deb1 = 100*$rep1;
$fin1 = $deb1 / $votes;
$deb2 = 100*$rep2;
$fin2 = $deb2 / $votes;
$deb3 = 100*$rep3;
$fin3 = $deb3 / $votes;
$deb4 = 100*$rep4;
$fin4 = $deb4 / $votes;
print '<script language="javascript">
reponse1 = Math.round('.$fin1.');
reponse2 = Math.round('.$fin2.');
reponse3 = Math.round('.$fin3.');
reponse4 = Math.round('.$fin4.');
';
$query = doquery ("SELECT * FROM {{table}} WHERE numero='$id_sondage' AND ip='$REMOTE_ADDR'","sondage_ip");
$lignes = mysql_num_rows($query);
if($lignes == 1)
{
if(!empty($re_1))
{
print '
document.write(\'<b>'.$re_1.'</b> <img border="0" src="barre.gif" height=5 WIDTH="\'+reponse1+\'"> <b> \'+reponse1+\'%</b><br>\');
';
}
if(!empty($re_2))
{
print '
document.write(\'<b>'.$re_2.'</b> <img border="0" src="barre.gif" height=5 WIDTH="\'+reponse2+\'"> <b> \'+reponse2+\'%</b><br>\');
';
}
if(!empty($re_3))
{
print '
document.write(\'<b>'.$re_3.'</b> <img border="0" src="barre.gif" height=5 WIDTH="\'+reponse3+\'"> <b> \'+reponse3+\'%</b><br>\');
';
}
if(!empty($re_4))
{
print '
document.write(\'<b>'.$re_4.'</b> <img border="0" src="barre.gif" height=5 WIDTH="\'+reponse4+\'"> <b> \'+reponse4+\'%</b><br>\');
';
}
print '</script>';
}
?>
</body>
</html>
La fonction doquery pour ceux qui ne l'a comprenne pas:
function doquery($query, $table) { // Selection des tables.
include('config.php');
global $numqueries;
$sqlquery = mysql_query(str_replace("{{table}}", $dbsettings["prefix"] . "_" . $table, $query)) or die(mysql_error());
$numqueries++;
return $sqlquery;
}
Merci