Forum » Server-Side scripting » Poll systeem
Shahiem
http://www.hogwartscastle
Berichten: 217
avatar
Offline Stuur privebericht
Hi,

Ik heb een Poll systeem maar als je bijvoorbeeld een stem uitbrengt dan zijn al de keuzes op 100%

Wie kan me helpen?

VoorbeeldCriminalsPoint error: de volgende afbeelding werd niet geladen omwille van veiligheidsproblemen: http://hogwartscastle.nl/poll.PNG

Code
Code | Selecteer Alles
minimaliseren
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
<?php
            $pollSql = $core->mysql->query("SELECT 
                                                * 
                                            FROM 
                                                poll");
            
            if($core->mysql->num_rows($pollSql))
            {
                     
                     $pollFetch = $core->mysql->fetch($pollSql);
                     
                     $gestemdSql = $core->mysql->query("SELECT 
                                                            poll_id,
                                                            lid_id,
                                                            stem_antwoord
                                                        FROM
                                                            poll_stemmen
                                                        WHERE 
                                                            poll_id = '".$core->mysql->escape($pollFetch['id']) . "' 
                                                        AND 
                                                            lid_id = '".$core->leden->ledeninfo['eigen']['id']."'");
            
                       if($core->leden->ingelogd == TRUE)
                       {
                               
                            if(isset($_POST['submit']))
                            {
                     
                       
                            if((isset($_POST['antwoord'])) && (ctype_digit($_POST['antwoord'])))
                            {
                            
                               if(!empty($pollFetch['antwoord' . $core->entities($_POST['antwoord'])]))
                               {
                               
                                  if($core->mysql->num_rows($gestemdSql) == 0)
                                  {
                                  
                                      $core->mysql->query("INSERT INTO 
                                                                poll_stemmen
                                                            (
                                                                poll_id,
                                                                lid_id,
                                                                stem_antwoord
                                                            ) VALUES (
                                                                '".$core->mysql->escape($pollFetch['id']) . "',
                                                                '".$core->leden->ledeninfo['eigen']['id']."',
                                                                '".$core->mysql->escape($_POST['antwoord']) . "'
                                                            )");
                                       
                                       $gestemdSql = $core->mysql->query("SELECT 
                                                                                stem_antwoord
                                                                            FROM 
                                                                                poll_stemmen
                                                                            WHERE
                                                                                poll_id = ".$core->mysql->escape($pollFetch['id'])."
                                                                            AND 
                                                                                lid_id = ".$core->mysql->escape($core->leden->ledeninfo['eigen']['id']));
                                    
                                }
                                }
                            }
                        }
                     }
                     
                     echo '<strong>' . $core->entities($pollFetch['vraag']) . '</strong>';
                        
                        $votes_sql = $core->mysql->query("SELECT 
                                                            COUNT(1) AS total_votes 
                                                        FROM 
                                                            poll_stemmen
                                                        WHERE 
                                                            poll_id = '" . $core->mysql->escape($pollFetch['id']) . "'");
                    
                        $votes = $core->mysql->fetch($votes_sql);
                      
                                                if($core->mysql->num_rows($gestemdSql))
                                                {
                        $gestemdFetch = $core->mysql->fetch($gestemdSql);
                                                }
                          
                          
                      
                       
                      if($core->mysql->num_rows($gestemdSql) == 0 && $core->leden->ingelogd == TRUE)
                      {
                        ?>
                        <form action="" method="post">
                       <?php
                      }
                        
                        echo '<table>';
                                                
                        for($i = 1; $i <= 10; $i++)
                        {
                                                
                            if(!empty($pollFetch['antwoord' . $i]))
                            {
                                                    
                                $antwoord_votes_sql = $core->mysql->query("SELECT
                                                                                COUNT(1)  AS antwoord_votes
                                                                            FROM 
                                                                                poll_stemmen`
                                                                            WHERE 
                                                                                poll_id = '".$core->mysql->escape($pollFetch['id']) . "' 
                                                                            AND
                                                                                stem_antwoord = '".$core->mysql->escape($i) . "'");
                            
                                $antwoord_votes = $core->mysql->fetch($antwoord_votes_sql);
                                                       
                                if($votes['total_votes'] != 0)
                                {
                                                            
                                    $percentage = ((round(($antwoord_votes['antwoord_votes'] / $votes['total_votes']), 4)) * 100);
                                                       
                                }
                                else
                                {
                                                            
                                    $percentage = 0;
                                                        
                                }
                                                        
                                    echo '<tr>';
                                                        
                                    if($core->mysql->num_rows($gestemdSql) == 0 && $core->leden->ingelogd == TRUE)
                                    {
                                    ?>
                                        <td><input type="radio" name="antwoord" value="<?php echo $core->entities($i); ?>" /></td>
                                     <?php                   
                                    }
                                                       
                                     echo '<td>';
                                                        
                                    if($gestemdFetch['stem_antwoord'] == $i)
                                    {
                                                           
                                        echo '<i>' . $core->entities($pollFetch['antwoord' . $i]) . '</i>';
                                                       
                                    }
                                    else
                                    {
                                                        
                                        echo $core->entities($pollFetch['antwoord' . $i]);
                                                       
                                    }
                                                       
                                        echo '</td>
                                                    <td><div style="background: url(''.ROOT.'img/poll_bar.png') no-repeat bottom left; width: ' . $percentage . 'px; height: 15px; float: left; margin: 1px 0 0 0;"></div></div></td><td><i>' . $percentage . '%</i></td></tr>';
                                                    
                                }
                          }
                                                
                                                echo '</table>';
                                                
                                                if($core->mysql->num_rows($gestemdSql) == 0 && $core->leden->ingelogd == TRUE)
                                                {
                                                ?>
                                                   <input type="submit" value="Stem" class="inputVeld" name="submit" />
                                                   </form>
                                                    <?php
                                                }
                                                
                                                echo 'Totaal aantal stemmen: ' . $core->entities($votes['total_votes']);
                                            }
                                ?>

Laatst gewijzigd door Shahiem op 2010-08-05 12:22:18
05-08-2010 12:18
Dit topic is 257 keer bekeken door 51 verschillende leden
Reacties op: "Poll systeem"
1
Shahiem
http://www.hogwartscastle
Berichten: 217
avatar
Offline Stuur privébericht
BUMP
06-08-2010 09:13
L.Groot
Rapifia Europe
Berichten: 3719
avatar
Offline Stuur privébericht
Even een opmerking:
Gebruik alsjeblieft geen * in een query, maar gebruik gewoon de tablenamen.

Succes,

Lars
06-08-2010 17:28
Shahiem
http://www.hogwartscastle
Berichten: 217
avatar
Offline Stuur privébericht
Dat doe ik meestal ook hoor
06-08-2010 22:04
Reageer op: "Poll systeem"
1
Je kan niet reageren omdat je niet bent ingelogd. Inloggen of Aanmelden