Scripts - Tutorials - Forum - Downloads - Showcase - Contact

Artikels

VPN vergelijken

Algemeen

Beginpagina

FAQ

Grafische worm (243)

Links

Nieuwsartikels

Nieuwsarchief

Boeken programmeren

Overzicht

Samenwerken

Webhosting

Zoek op Sitemasters

Leden

Registreren

Ledenlijst

Ons team

Links

webhostingtop10.be

Sociale media

Follow @sitemasters

Sitemasters

Adverteren op Sitemasters?

Contacteer ons

RSS

Link naar ons

Donaties

Poll

Je moet ingelogd zijn om te stemmen.

Statistieken

Linkpartners

Forum

Categorieën > PHP & SQL

Poll telt niet (Opgelost)

Designick - 25/03/2009 18:45

Nieuw lid

Hallo,

ik heb een probleem met een poll.
Hij doet alles. Telt in database etc etc.

Alleen hij laat de uiteindelijke %ten niet zien.
Heel raar en zie niet wat er fout is.

Poll.php

php code - Bekijk de code zonder highlighting - Klap code in

<? 
 
    class poll 
    { 
        # Show options function 
        function showOptions() 
        { 
            # Get newest poll 
            $data = $this->getPoll(); 
 
            # Split options 
            $options = explode(",", $data['poll_keuzes']); 
            # Count options for loop 
            $aant = count($options)-1; 
 
            $poll .= "<h1><b style=\"color:#333333; font-size:17;font-family:Arial, Helvetica, sans-serif;\">" . $data['poll_stelling'] . "</b><br />"; 
            $poll .= "<form method=\"POST\" action=\"" . $_SERVER['PHP_SELF'] . "\">"; 
            # Loop and make input radios 
            for($i = 0; $i <= $aant; $i++) 
            { 
                $j = $i+1; 
                $poll .= "<input type=\"radio\" value=\">" . $j . "\" name=\"poll\" />" . $options[$i] . "<br />"; 
            }
            $poll .= "<input type=\"submit\" name=\"vote\" value=\"Stem!\" style=\"font-size:12px; background-color:transparent; border:none;cursor:pointer;font-weight:bold;color:fd0071;text-decoration:underline;\"/>"; 
            $poll .= "</form>"; 
 
            # Show link to archives 
            # $poll .= "<p><a href=\"archives.php\">Bekijk archief!</a>"; 
 
            return $poll; 
        } 
 
        function updateVotes($vote) 
        { 
            # Get newest poll 
            $data = $this->getPoll(); 
 
            # Split the vote scores 
            $stemmen = explode(",", $data['poll_scores']); 
 
            # add one to the selected option 
            $vote--; 
            (int) $stemmen[$vote]++; 
 
            # Remake the data 
            $stem = implode(",", $stemmen); 
 
            # Add to database 
            $sql1 = "UPDATE `poll` SET `poll_scores` = '" . $stem . "' WHERE `poll_id` = '" . $data['poll_id'] . "'"; 
            $ip = $_SERVER['REMOTE_ADDR']; 
            $sql2 = "INSERT INTO `votes` SET `vote_ip` = '" . $ip . "', `vote_datum` = '" . time() . "'"; 
 
            # Run db class 
            $db = new database; 
 
            $res1 = $db->execute($sql1); 
            $res2 = $db->execute($sql2); 
 
        } 
 
        function getPoll() 
        { 
            # Select the newest poll 
            $sql = "SELECT * FROM `poll` ORDER BY `poll_id` DESC LIMIT 1"; 
 
            # Run db class 
            $db = new database; 
 
            # Get array 
            $data = $db->get_single($sql); 
 
            return $data; 
        }     
 
        function showResults() 
        { 
            # Get data 
            $data = $this->getPoll(); 
 
            # Split options and scores 
            $options = explode(",", $data['poll_keuzes']); 
            $scores = explode(",", $data['poll_scores']); 
 
            $option = count($options)-1; 
 
            # Count the votes 
            $votes = array_sum($scores); 
 
            # Show total votes                         
            $results .= "<h1><b style=\"color:#333333; font-size:17;font-family:Arial, Helvetica, sans-serif;\">" . $data['poll_stelling'] . "</b><br />"; 
            $results .= "Totaal aantal stemmen: <b style=\"color:#333333\">" . $votes . "</b></h1>"; 
            $results .= "<h1>"; 
 
            # Loop through results 
            for($i = 0;$i <= $option; $i++) 
            { 
                $results .= $options[$i] . "<br />"; 
                $results .= "<img src=\"images/indicator.png\" width=\"" . $this->imgPXL($votes, $scores[$i]) . "\" height=\"10\"/>&nbsp;" . $this->imgPXL($votes, $scores[$i]). "%"; 
                $results .= "<br />"; 
            } 
            $results .= "</p>"; 
 
            
 
            # Show link to archives 
            $results .= "<p><a href=\"archives.php\">Bekijk archief!</a>"; 
 
            return $results;             
        } 
 
        function archResults($id) 
        { 
            # Get data 
            $data = $this->archPoll($id); 
 
            # Split options and scores 
            $options = explode(",", $data['poll_keuzes']); 
            $scores = explode(",", $data['poll_scores']); 
 
            $option = count($options)-1; 
 
            # Count the votes 
            $votes = array_sum($scores); 
 
            # Show total votes                         
            $results .= "<b><h1>" . $data['poll_stelling'] . "</b><br />"; 
            $results .= "<p><h1>"; 
 
            # Loop through results 
            for($i = 0;$i <= $option; $i++) 
            { 
                $results .= $options[$i] . "<h1><br />"; 
                $results .= "<h1><img src=\"images/indicator.png\" width=\"" . $this->imgPXL($votes, $scores[$i]) . "\" height=\"15\" />" . $this->imgPXL($votes, $scores[$i]) . "%"; 
                $results .= "<br />"; 
				$results .= "<h1>Totaal aantal stemmen: " . $votes . ""; 
            } 
            $results .= "</p>"; 
 
            # Show link to archives 
            $results .= "<p><a href=\"archives.php\">Terug!</a>"; 
 
            return $results;             
        } 
 
        function archPoll($id) 
        { 
            # Select the newest poll 
            $sql = "SELECT * FROM `poll` WHERE `poll_id` = '" . $id . "' ORDER BY `poll_id` DESC LIMIT 1"; 
 
            # Run db class 
            $db = new database; 
 
            # Get array 
            $data = $db->get_single($sql); 

            return $data; 
        }     
 
        # Calculate indicator size 
        function imgPXL($tot, $opt) 
        { 
            $pro = $tot / 100; 
            $num = $opt / $pro; 
 
            return (int) $num; 
        } 
    } 
?>

<? 
 
    class poll 
    { 
        # Show options function 
        function showOptions() 
        { 
            # Get newest poll 
            $data = $this->getPoll(); 
 
            # Split options 
            $options = explode(",", $data['poll_keuzes']); 
            # Count options for loop 
            $aant = count($options)-1; 
 
            $poll .= "<h1><b style=\"color:#333333; font-size:17;font-family:Arial, Helvetica, sans-serif;\">" . $data['poll_stelling'] . "</b><br />"; 
            $poll .= "<form method=\"POST\" action=\"" . $_SERVER['PHP_SELF'] . "\">"; 
            # Loop and make input radios 
            for($i = 0; $i <= $aant; $i++) 
            { 
                $j = $i+1; 
                $poll .= "<input type=\"radio\" value=\">" . $j . "\" name=\"poll\" />" . $options[$i] . "<br />"; 
            }
            $poll .= "<input type=\"submit\" name=\"vote\" value=\"Stem!\" style=\"font-size:12px; background-color:transparent; border:none;cursor:pointer;font-weight:bold;color:fd0071;text-decoration:underline;\"/>"; 
            $poll .= "</form>"; 
 
            # Show link to archives 
            # $poll .= "<p><a href=\"archives.php\">Bekijk archief!</a>"; 
 
            return $poll; 
        } 
 
        function updateVotes($vote) 
        { 
            # Get newest poll 
            $data = $this->getPoll(); 
 
            # Split the vote scores 
            $stemmen = explode(",", $data['poll_scores']); 
 
            # add one to the selected option 
            $vote--; 
            (int) $stemmen[$vote]++; 
 
            # Remake the data 
            $stem = implode(",", $stemmen); 
 
            # Add to database 
            $sql1 = "UPDATE `poll` SET `poll_scores` = '" . $stem . "' WHERE `poll_id` = '" . $data['poll_id'] . "'"; 
            $ip = $_SERVER['REMOTE_ADDR']; 
            $sql2 = "INSERT INTO `votes` SET `vote_ip` = '" . $ip . "', `vote_datum` = '" . time() . "'"; 
 
            # Run db class 
            $db = new database; 
 
            $res1 = $db->execute($sql1); 
            $res2 = $db->execute($sql2); 
 
        } 
 
        function getPoll() 
        { 
            # Select the newest poll 
            $sql = "SELECT * FROM `poll` ORDER BY `poll_id` DESC LIMIT 1"; 
 
            # Run db class 
            $db = new database; 
 
            # Get array 
            $data = $db->get_single($sql); 
 
            return $data; 
        }     
 
        function showResults() 
        { 
            # Get data 
            $data = $this->getPoll(); 
 
            # Split options and scores 
            $options = explode(",", $data['poll_keuzes']); 
            $scores = explode(",", $data['poll_scores']); 
 
            $option = count($options)-1; 
 
            # Count the votes 
            $votes = array_sum($scores); 
 
            # Show total votes                         
            $results .= "<h1><b style=\"color:#333333; font-size:17;font-family:Arial, Helvetica, sans-serif;\">" . $data['poll_stelling'] . "</b><br />"; 
            $results .= "Totaal aantal stemmen: <b style=\"color:#333333\">" . $votes . "</b></h1>"; 
            $results .= "<h1>"; 
 
            # Loop through results 
            for($i = 0;$i <= $option; $i++) 
            { 
                $results .= $options[$i] . "<br />"; 
                $results .= "<img src=\"images/indicator.png\" width=\"" . $this->imgPXL($votes, $scores[$i]) . "\" height=\"10\"/>&nbsp;" . $this->imgPXL($votes, $scores[$i]). "%"; 
                $results .= "<br />"; 
            } 
            $results .= "</p>"; 
 
 
 
            # Show link to archives 
            $results .= "<p><a href=\"archives.php\">Bekijk archief!</a>"; 
 
            return $results;             
        } 
 
        function archResults($id) 
        { 
            # Get data 
            $data = $this->archPoll($id); 
 
            # Split options and scores 
            $options = explode(",", $data['poll_keuzes']); 
            $scores = explode(",", $data['poll_scores']); 
 
            $option = count($options)-1; 
 
            # Count the votes 
            $votes = array_sum($scores); 
 
            # Show total votes                         
            $results .= "<b><h1>" . $data['poll_stelling'] . "</b><br />"; 
            $results .= "<p><h1>"; 
 
            # Loop through results 
            for($i = 0;$i <= $option; $i++) 
            { 
                $results .= $options[$i] . "<h1><br />"; 
                $results .= "<h1><img src=\"images/indicator.png\" width=\"" . $this->imgPXL($votes, $scores[$i]) . "\" height=\"15\" />" . $this->imgPXL($votes, $scores[$i]) . "%"; 
                $results .= "<br />"; 
				$results .= "<h1>Totaal aantal stemmen: " . $votes . ""; 
            } 
            $results .= "</p>"; 
 
            # Show link to archives 
            $results .= "<p><a href=\"archives.php\">Terug!</a>"; 
 
            return $results;             
        } 
 
        function archPoll($id) 
        { 
            # Select the newest poll 
            $sql = "SELECT * FROM `poll` WHERE `poll_id` = '" . $id . "' ORDER BY `poll_id` DESC LIMIT 1"; 
 
            # Run db class 
            $db = new database; 
 
            # Get array 
            $data = $db->get_single($sql); 
 
            return $data; 
        }     
 
        # Calculate indicator size 
        function imgPXL($tot, $opt) 
        { 
            $pro = $tot / 100; 
            $num = $opt / $pro; 
 
            return (int) $num; 
        } 
    } 
?>

Pollbeheer.php (toont de poll op deze site.

php code - Bekijk de code zonder highlighting - Klap code in

        <? 

 
    # Include database classfile 
    include("database.php"); 
    # Include poll classfile 
    include("poll.php"); 
 
    # Run database class 
    $db = new database; 
 
    # Set query to see if voted already 
    $ip = $_SERVER['REMOTE_ADDR']; 
    $sql = "SELECT * FROM `votes` WHERE `vote_ip` = '" . $ip . "'"; 
 
    # Run poll class 
    $poll = new poll; 
 
        # If a match is found show results only 
        if($db->num_rows($sql) == 1) 
        { 
            # Show results 
            echo $poll->showResults(); 
        } 
        else 
        { 
            # Check if form submitted 
            if(!$_POST['vote']) 
            {             
                # Show form 
                echo $poll->showOptions(); 
            } 
            else 
            { 
                # Add data to database 
                # Check for a value 
                if(!$_POST['poll']) 
                { 
                    # No option selected 
                    # Show poll again 
                    echo $poll->showOptions(); 
                } 
                else 
                {
                    # A radio is checked 
                    # Update votes 
                    $poll->updateVotes($_POST['poll']); 
 
                    # Show results 
                    echo $poll->showResults(); 
                } 
            } 
        } 
?>

<? 
 
 
    # Include database classfile 
    include("database.php"); 
    # Include poll classfile 
    include("poll.php"); 
 
    # Run database class 
    $db = new database; 
 
    # Set query to see if voted already 
    $ip = $_SERVER['REMOTE_ADDR']; 
    $sql = "SELECT * FROM `votes` WHERE `vote_ip` = '" . $ip . "'"; 
 
    # Run poll class 
    $poll = new poll; 
 
        # If a match is found show results only 
        if($db->num_rows($sql) == 1) 
        { 
            # Show results 
            echo $poll->showResults(); 
        } 
        else 
        { 
            # Check if form submitted 
            if(!$_POST['vote']) 
            {             
                # Show form 
                echo $poll->showOptions(); 
            } 
            else 
            { 
                # Add data to database 
                # Check for a value 
                if(!$_POST['poll']) 
                { 
                    # No option selected 
                    # Show poll again 
                    echo $poll->showOptions(); 
                } 
                else 
                {
                    # A radio is checked 
                    # Update votes 
                    $poll->updateVotes($_POST['poll']); 
 
                    # Show results 
                    echo $poll->showResults(); 
                } 
            } 
        } 
?>

hopelijk kan iemand helpen

4 antwoorden

Gesponsorde links

mark92 - 25/03/2009 18:54
Nieuw lid		Misschien werkt dit: php code - Bekijk de code zonder highlighting - Klap code in function imgPXL($tot, $opt) { $num = $opt / $tot * 100; return round($num); } function imgPXL($tot, $opt) { $num = $opt / $tot * 100; return round($num); }

Designick - 25/03/2009 18:57
Nieuw lid		mark92 schreef: Misschien werkt dit: [..code..] Werkt niet, sorry. Toch bedankt

mark92 - 25/03/2009 19:02 (laatste wijziging 25/03/2009 19:04)
Nieuw lid		ik zie het al: php code - Bekijk de code zonder highlighting - Klap code in $scores = explode(",", $data['poll_scores']); (...) $votes = array_sum($scores); $scores = explode(",", $data['poll_scores']); (...) $votes = array_sum($scores); je gebruikt array_sum op een array met alleen maar strings erin. De optelsom wordt 0, aangezien deze functie alleen integers en floats optelt. Misschien verhelpt dit het probleem, alleen weet ik het niet zeker: php code - Bekijk de code zonder highlighting - Klap code in $scores = (float) explode(",", $data['poll_scores']); $scores = (float) explode(",", $data['poll_scores']); Anders zou je ze 'handmatig' op moeten tellen.. EDIT: Volgens mij ben ik er niet zo bij vandaag

Designick - 25/03/2009 19:18
Nieuw lid		mark92 schreef: ik zie het al: [..code..] je gebruikt array_sum op een array met alleen maar strings erin. De optelsom wordt 0, aangezien deze functie alleen integers en floats optelt. Misschien verhelpt dit het probleem, alleen weet ik het niet zeker: [..code..] Anders zou je ze 'handmatig' op moeten tellen.. EDIT: Volgens mij ben ik er niet zo bij vandaag Nee werkt ook niet, maar ik heb het orgineel nog gevonden tussen me backups en die werkt wel ;) Toch bedankt voor je inzet!

Gesponsorde links

Dit onderwerp is gesloten.

Actiefste leden van de maand

Actieve forumberichten