https://www.machform.com/forums/ MachForm Community Forums Topic: Polls... how to show results en Mon, 04 May 2026 02:44:53 +0000 https://www.machform.com/forums/topic/polls-how-to-show-results#post-16831 Sat, 19 Jan 2013 00:45:43 +0000 garybpenn 16831@https://www.machform.com/forums/ <p>ggmaury - </p> <p>I am attempting to do the same thing that you did here several years back. That is, show instant results after a poll is submitted. Can you possible turn the example links back on or share your code? Thank you! </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1872 Wed, 21 May 2008 23:15:54 +0000 girljinbink 1872@https://www.machform.com/forums/ <p>I'm at a beginning level of PHP, so although I understand most of what you're saying, there are some holes...</p> <p>would you be willing to send me the code for your results page?<br /> mjohnson(at)tcgrec.com </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1858 Wed, 21 May 2008 00:57:24 +0000 ggmaury 1858@https://www.machform.com/forums/ <p>AMurray:</p> <p>Sorry, I disabled that form.<br /> You can check an example in <a href="http://campeche.com/encuestas/index.php?id_1=8&#38;id_2=1&#38;id_3=0&#38;id_4=0" rel="nofollow">http://campeche.com/encuestas/index.php?id_1=8&#38;id_2=1&#38;id_3=0&#38;id_4=0</a></p> <p>girljinbink:</p> <p>I made a machform directory where I use only 1 field multiple choice forms.</p> <p>The machform db structure includes a table called 'ap_element_options' where field 'form_id' is the number of the form you want to show results from. All rows with the same 'form_id' will have different 'position' (or 'option_id' which have the same values). Each 'position' is a choice for the form.</p> <p>By querying ($id is the form number passed in the url so the same script takes care of all polls):</p> <p>$result = mysql_query("SELECT <code>position</code>, <code>option</code> FROM <code>ap_element_options</code> WHERE <code>form_id</code> = '$id'");</p> <p>you will get all rows with the same <code>form_id</code> thus getting all choices (choice number and name) of your poll:</p> <p>while ($row = mysql_fetch_array($result))<br /> {<br /> $choice[$total]['position'] = $row['position']; //choice number<br /> $choice[$total]['option'] = $row['option']; //text describing choice<br /> $choice[$total]['votes'] = 0; //will store total votes per choice </p> <p> $total++;<br /> }</p> <p>At this point, you have a multidimentional array holding poll values.</p> <p>Then you count the number of times (rows) each choice has been selected (I used a for loop based on $total). Those are saved in table 'ap_form_x' where 'x' is your 'form_id' and field <code>element_1</code> has the same value than 'option':</p> <p>$result = mysql_query("SELECT <code>element_1</code> , COUNT( * ) as <code>votes</code> FROM ".$apform." WHERE <code>element_1</code> ='$i' GROUP BY <code>element_1</code>");</p> <p>$row = mysql_fetch_array($result);<br /> $choice[$i]['votos'] = (int)$row['votes'];<br /> $totalVotes = $totalVotes + $choice[$i]['votes'];</p> <p>then I sort the array based on total votes to show them from max to min votes.</p> <p>From that point you display the results of your poll.</p> <p>I hope that helps. </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1834 Sat, 17 May 2008 09:07:41 +0000 AMurray 1834@https://www.machform.com/forums/ <p>I don't see anything except a blank screen with green background.....no poll or results there. </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1805 Thu, 15 May 2008 23:01:18 +0000 girljinbink 1805@https://www.machform.com/forums/ <p>Can you elaborate a bit more on how you coded the results page? </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1729 Fri, 09 May 2008 14:33:01 +0000 yuniar 1729@https://www.machform.com/forums/ <p>ooh.. that looks nice! </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1714 Fri, 09 May 2008 02:45:14 +0000 ggmaury 1714@https://www.machform.com/forums/ <p>Yuniar:<br /> I achieved that by accessing the database and using form_id, position and option from ap_element_options table to select the form and then count the votes contained in element_1 (table ap_form1, ap_form2 and so on depending on the form number).<br /> If works for a single multiple choice field and redirects to my results viewer.<br /> check it out at:<br /> <a href="http://campeche.com/encuestas/formas/view.php?id=1" rel="nofollow">http://campeche.com/encuestas/formas/view.php?id=1</a></p> <p>There are 4 forms so changong the id to 2, 3 or 4 you can see the others.</p> <p>I just need to make a page with a menu of available polls to control the flow. </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1241 Sat, 29 Mar 2008 15:07:34 +0000 yuniar 1241@https://www.machform.com/forums/ <p>Sorry, I'm afraid I can't help much with this one, since it would require pretty much custom code. </p> https://www.machform.com/forums/topic/polls-how-to-show-results#post-1239 Sat, 29 Mar 2008 11:12:16 +0000 ggmaury 1239@https://www.machform.com/forums/ <p>I just made a form to make a poll. The form works fine but I need to display the results with the total votes per choice and the percentage each one has.<br /> I know I can export the values to xls or csv but I need to get them automaticly right after each vote.<br /> Can you suggest any workaround?<br /> Maybe updating the csv automaticly after casting a vote?</p> <p>Thanks </p>