UN SYSTÈME DE SONDAGE POUR VOTRE SITE (A ADAPTER AU VOTRE)

<? 
// S y s t è m e  d e  v o t e  :

// S t r u c t u r e   d e   l a   t a b l e   ` n e _ v o t e s `
/*
CREATE TABLE `ne_votes` (
  `pid` int(9) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `fields` text NOT NULL,
  `results` text NOT NULL,
  `datei` datetime NOT NULL default '0000-00-00 00:00:00',
  `ok` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`pid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
*/

// P r é s e n t a t i o n   d e s   c h a m p s   d e   ` n e _ v o t e s `
# pid => pool's id
# title => pool's title
# text => pool's question
# fields => pool's fields
# results => pool's results
# date => Date of the day
# ok => the pool is actived

//O p t i m i s é  p o u r   u n   s y s t è m e   d o n t   l e s   v a r i a b l e s   g l o b a l e s   s o n t   à   O F F 
$votes = 'ne_votes';
if(!isset($_GET['op'])){$_GET['op']="";}
if(!isset($_GET['part'])){$_GET['part']="";}
mysql_select_db("netwaka emulation", mysql_connect("localhost", "root", ""));
switch($_GET['op'])
{
	default:
		echo 'Affichage du sondage et<br>des résultats :';
		$req = mysql_fetch_array(mysql_query('SELECT * FROM `'.$votes.'` WHERE `ok`="1" ORDER BY `pid` DESC'));
		if(is_array($req))
		{
			$fields = explode(';', $req['fields']);
			$results = explode(';', $req['results']);
			unset($results[''],$fields['']);
			echo '<hr width="150" align="left">';
			echo $req['title'];
			echo '<br>';
			echo $req['text'];
			echo '<br>';
			echo '<br>';
			$answers  = array_sum($results);
			for($i=0; $i<count($fields); $i++)
			{
				if($answers!=0)
				{
					$percents = (($results[$i]/$answers)*100);
				}
				else
				{
					$percents = "1";
				}
				$percents = floor($percents);
				echo $fields[$i].' ('.$percents.' %)';
				echo '<br>';
				echo '<table border="0" width="100" bgcolor="#CCCCCC" height="15" cellpadding="0" cellspacing="0">';
				echo '<tr>';
				echo '<td>';
				echo '<table border="0" cellpadding="0" cellspacing="0" width="'.$percents.'" bgcolor="#FF0000" height="15">';
				echo '<tr>';
				echo '<td>';
				echo '</td>';
				echo '</tr>';
				echo '</table>';
				echo '</td>';
				echo '</tr>';
				echo '</table>';
			}
		}
		else
		{
			echo '<br>';
			echo 'Aucun sondage pour le moment ...';
		}
		echo '<br>';
		echo '<a href="?op=insert">Insérer un nouveau sondage</a>';
	break;
	case "insert":
		switch($_GET['part'])
		{
			default:
				echo 'Combien de choix possibles pour le sondage ?';
				echo '<form method="post" action="?op=insert&part=1">';
				echo '<input type="text" name="choice" value="5">';
				echo '<input type="submit">';
				echo '</form>';
			break;
			case "1":
				echo 'Création d\'un formulaire à '.$_POST['choice'].' choix :';
				echo '<form method="post" action="?op=insert&part=2">';
				echo '<input type="text" name="title" value="Titre de votre sondage">';
				echo '<br>';
				echo '<input type="text" name="text" value="Question de votre sondage">';
				echo '<br>';
				echo '<br>';
				for($i=0; $i<$_POST['choice']; $i++)
				{
					echo '<input type="text" name="'.$i.'" value="Choix '.$i.'">';
					echo '<br>';
				}
				echo '<br>';
				echo 'Ce sondage est activé : <input type="checkbox" name="ok" value="1">';
				echo '<input type="hidden" name="choice" value="'.$_POST['choice'].'">';
				echo '<br>';
				echo '<br>';
				echo '<input type="submit">';
				echo '&nbsp;';
				echo '<input type="reset">';
				echo '</form>';
			break;
			case "2":
			if(isset($_POST['choice'])&&isset($_POST['title'])&&isset($_POST['text']))
			{
				$fields = "";
				$results = "";
				for($i=0; $i<$_POST['choice']; $i++)
				{
					$fields .= $_POST[$i];
					if(isset($_POST[($i+1)]))
					{
						$fields .= ";";
						$results .= ";";
					}
				}
				if(mysql_query('INSERT INTO `'.$votes.'` VALUES("","'.$_POST['title'].'","'.$_POST['text'].'","'.$fields.'","'.$results.'","'.date("Y-m-d H:i:s").'","'.$_POST['ok'].'")'))
				{
					echo 'Création de votre nouveau sondage réussie ...';
					echo '<br>';
					echo '<a href="?ok">Cliquez là</a>';
				}
				else
				{
					echo 'Une erreur interne s\'est produite ...';
				}
			}
			else
			{
				echo 'Une erreur interne s\'est produite ...';
			}
			break;
		}
	break;
}
?>