Session - avoid double vote

[eevan79]

I want to avoid double vote using session, but cant make it to work. Here is my script:

 

<?php
$mode = $_GET[''mode''];
$voted = intval($_GET[''voted'']);

//vote 1 to 5
if(($voted < 1)||($voted>5)) die;
if ($mode=="vote")
{

//update mysql
mysql_query ("UPDATE fraze SET total = total+$voted, votes = votes+1, srednja = round(total/votes, 2) WHERE id = $id");
echo "<meta http-equiv=''refresh'' content=''0;URL=http://www.mysite.info/index.php?id=".$red[''id'']."''>"; 
}

?>

 

Thanks in advance.

[Kestrad]

if(($voted < 1)||($voted>5)) die;

 

do you need curly braces for this line?

[eevan79]

if(($voted < 1)||($voted>5)) die;

 

do you need curly braces for this line?

I dont think so  .

But still I have problem with double vote. I dont know how to use session to avoid double (or multiple) vote.

[Lamez]

Are you getting errors?

If you are using sessions, I don't see anything related to sessions. You also need to remember to add session_start();

[dpacmittal]

<?php
session_start();
if($_SESSION['voted']==1)
{
echo "Already voted";
exit 0;
}
   $mode = $_GET[''mode''];
   $voted = intval($_GET[''voted'']);
   
   //vote 1 to 5
   if(($voted < 1)||($voted>5)) die;
   if ($mode=="vote")
   {
      
   //update mysql
   mysql_query ("UPDATE fraze SET total = total+$voted, votes = votes+1, srednja = round(total/votes, 2) WHERE id = $id");
$_SESSION['voted']=1;
   echo "<meta http-equiv=''refresh'' content=''0;URL=http://www.mysite.info/index.php?id=".$red[''id'']."''>"; 
   }
            
   ?>

[eevan79]

Thanks, dpacmittal

Solved. 

[dpacmittal]

But that will avoid double vote as long as session lasts. You'd have to store the voted info in database for avoiding double votes forever.

[eevan79]

But that will avoid double vote as long as session lasts. You'd have to store the voted info in database for avoiding double votes forever.

I really like to do that, but dont know how (I already tried something, but always failed).

[Lamez]

Then look up MySQL insert queries, and things revolving that matter. They will help a ton