editpoll.php

   1 <?php
   2 $require_login = true;
   3 $page_name = 'Poll Maker';
   4 require ('config.php');
   5 $level_restriction = ADMIN;
   6 require ('top.inc.php');
   7
   8 if (isset ($_POST['submit']))
   9 {
  10         $query1 = '';
  11         $query2 = '';
  12         for ($i = 1; $i <= 8; $i++)
  13         {
  14                 $query1 .= '`option'.$i.'`, ';
  15                 $query2 .= '\''.mysql_real_escape_string ($_POST['option'.$i]).'\', ';
  16         }
  17         $pollname = mysql_real_escape_string ($_POST['pollname']);
  18
  19         mysql_query ('INSERT INTO `poll` (`pollname`, '.$query1.' `polldate`) VALUES (\''.$pollname.'\', '.$query2.' UNIX_TIMESTAMP())');
  20 }
  21
  22 echo '<div class="c3">Start New Poll</div>
  23 <form action="'.urlpath(2).'" method="post">
  24 <div class='.colour().'>Poll name: <input type="text" name="pollname" maxlength="50"/></div>';
  25
  26 for ($optnum = 1; $optnum <= 8; $optnum++)
  27         echo '<div class='.colour().'>Option '.$optnum.': <input type="text" name="option'.$optnum.'" maxlength="100"/></div>'."\n";
  28
  29 echo '<div class="c3"><input type="submit" name="submit" value="Create new poll"/></div>
  30 </form>
  31 ';
  32
  33 $pollinfo = mysql_fetch_row (mysql_query ('SELECT * FROM `poll` ORDER BY `pollid` DESC LIMIT 1'));
  34 if ($pollinfo)
  35 {
  36         $sum = array_sum (array_slice ($pollinfo, 10, 8));
  37         echo '<div class="c3">Current poll results for: '.$pollinfo[1].': '.$sum.' votes</div>
  38 <table>
  39 <tr><th>Option</th><th style="width:66%">Votes</th></tr>
  40 ';
  41         for ($optnum2 = 0; $optnum2 < 8; $optnum2++)
  42         {
  43                 $widthpc = ($sum && $pollinfo[($optnum2+10)]) ? round ($pollinfo[($optnum2+10)] / $sum * 100, 1) : 0;
  44                 if ($pollinfo[($optnum2+2)])
  45                         echo '<tr class='.colour().'><td>'.$pollinfo[($optnum2+2)].'</td><td><span class="alert" style="width:'.$widthpc.'%;display:block">'.$pollinfo[($optnum2+10)].'</span></td></tr>
  46 ';
  47         }
  48         echo '</table>';
  49 }
  50
  51 require ('foot.php');
  52 ?>