finding a var in an array

r3n

Hey all,
Just wondering if anybody can help me with this, its a simple problem but i just dont know what function to use. Heres the code i have now.

$validateVoterSQL = "select votersIP from $poll_log where pollID=$pollID";
$validateVoterResult = mysql_query($validateVoterSQL) 
or die ("Error !! (poll-vote1.php)mysql : $query : " . mysql_error());
$votersIProw=mysql_fetch_array($validateVoterResult);
$votersIP=$votersIProw["votersIP"];
if($votersIP==$REMOTE_ADDR)
header("Location: http:".$filename."?".$phpQuery."
&pollreq=poll-result&pollMSG=You+may+only+vote+once!#poll");

The idea of this is to deny a user with the same IP from voting twice (on a poll) -- at the moment, if($votersIP==$REMOTE_ADDR), only gets the first var... i need a way of making it look through all the vars. Feel free to tidy this up for me aswell if u want, hehe :p

Frag

hmm..

$query = "select votersIP from $poll_log where votersIP = $REMOTE_ADDR and pollID=$pollID";
$result = mysql_query($query) or die("Query Failed");
if(mysql_num_rows($result)>0) {
   header("Location: http:".$filename."?".$phpQuery." &pollreq=poll-result&pollMSG=You+may+only+vote+once!#poll")
}

Frag

bastien

http://www.php.net/manual/en/function.in-array.php

but validation by IP has limitations..any one who is on dial up is assigned a dynamic IP address that need not be the same each time they dial up for access. better to allow for members only to vote...get more valid results...

if(in_array($voterIP,$REMOTE_ADDR){

header("Location: http:".$filename."?".$phpQuery."
&pollreq=poll-result&pollMSG=You+may+only+vote+once!#poll");

}

hth

r3n

thx guys, i'll try the in_array function, and Frag - thx for tidying up my messy code (i'll try ur method if this one dosent work out) :p

Frag

My code doesn't use an array. It allows the database to do all the work.

Databases are 10% data storage and 90% data control and management 🙂

Frag

r3n

Yeah, good point frag hehe. Ur method of using mySQL to do the work seems to be the better option -- now, i need to know some more stuff :p

How would i create a cookie on the users' computer so they cant vote twice? As i may not use the IP method as it dosent allow users ona network (with the same IP) to vote simultaniously.

Frag

setcookie();

Frag

r3n

hmm, i'm not sure of what vars to put in the setcookie() function;

setcookie("poll[0]","voted",0,"/",".u-clan.net");

this is just a guess, so its prolly completely wrong 🙂 could someone explain it for me plz?

Frag

It takes upto 6 variables.

Here they are in order from left to right.

1) The cookies name (how you will refer to this cookie)
2) The value that you wish the cookie to hold.
3) How long the cookie will live before it expires. (0 means it doesn't expire)
4) The root which it lives. (will explain below)
5) The domain that it belongs too.
6) Security

Explain: root

This is where the cookie exsist. It will be visable from this directory and deeper. So you you make this field "/" it will be
visable from the root of the webserver (http://www.domain.com/) If you make it something else like
a subdirectory of "thisdir" then it will only be visable from (http://www.domain.com/thisdir)

I hope I explained that well enough.

Frag