1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

need help-survey voting

Discussion in 'PHP' started by wayz1229, Nov 8, 2009.

  1. wayz1229

    wayz1229 New Member

    Joined:
    Nov 8, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    i'm a beginner and new to php. i'm having problem with survey script and voting function. can anyone please help me out.. the script only accept the last question's answer and update the database = acount+1.

    script to display survey:

    Code:
    <?php
    echo "<form action='vote.php' method=post>
    <table width='300' border='0' cellspacing='0' cellpadding='0' align='center'>";
    $query1 = "SELECT * FROM questions";
    $result1 = mysql_query($query1)or die("ERROR: $query.".mysql_error());
    $num_row=mysql_num_rows($result1);
    $i=1;
    while($i<$num_row){
    while ($row1 = mysql_fetch_array($result1)) {
    $qid = $row1['qid'];
    $qtitle = $row1['qtitle'];
    $query2 = "SELECT * FROM answers WHERE qid='$qid'";
    $result2 = mysql_query($query2) or die("ERROR: $query.".mysql_error());
    echo "<tr>
        <td width='300' align='left'><p>".$i.". ".$qtitle."</p></td>
       </tr>";
      
    while ($row2 = mysql_fetch_array($result2)) {
    $aid = $row2['aid'];
    $atitle = $row2['atitle'];
    echo "<tr>
        <td width='300' align='left'><input type = radio name =aid value = '".$aid."'><font>".$atitle."</font></input><br></p></td>
       </tr>";
    }
    echo "<input type = hidden name = qid value = '".$qid."'>";
    echo "<br />";
    $i++;
    }
    }
    echo "<td><br><br></td><tr>
    <td width='300' align='center'><input type = submit name = submit value = 'Submit'></td>
    </tr>
    </table>
    </form>";
    }
    }
    // close connection
    mysql_close();
    ?>
    

    voting script:

    Code:
    <?php
    if (isset($_COOKIE) && !empty($_COOKIE)) {
        if ($_COOKIE['lastpoll'] && $_COOKIE['lastpoll'] == $_POST['qid']) {
     echo '<script>alert("You have already voted. Thank You !!!");</script>';
     echo '<script>location.replace("trysurvey.php");</script>';
     exit();
        }
    }
    // set cookie
    setCookie('lastpoll', $_POST['qid'], time() + 2592000);
    
    if (isset($_POST['submit'])) {
        if (!isset($_POST['aid'])) {
      echo '<script>alert("Please select one of the available choices.");</script>';
      echo '<script>history.back(1);</script>';
        }
     else{
     
     require_once('config.php');
     
     $aid=$_POST['aid'];
     $qid=$_POST['qid'];
       
        // update vote counter
        $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid' AND qid = '$qid'";
        $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
     
     }
        // close connection
        mysql_close();
    
        // print success message    
     echo '<script>alert("Your have successfully voted.");</script>';
     echo '<script>location.replace("trysurvey.php");</script>';
    }
    else {
        echo '<script>alert("Unable to submit your Vote. Please try again !!!");</script>';
     echo '<script>history.back(1);</script>';
    }
    ?>
    

    please help... thanks in advance
     

Share This Page