IP check

[KellyJ]

Hello,

 

I have created a little voting script for my site. The insertion code into the MySQL databse when they vote is very simple:

 

$ipaddress = addslashes($_POST['ipaddress']);
$theid = addslashes($_POST['theid']);
$gamert = addslashes($_POST['gamert']);
$serveron = addslashes($_POST['serveron']);

$db = mysql_connect("localhost", "username", "password");

mysql_select_db("thedb",$db);

mysql_query ("INSERT INTO voting (theid,ipaddress,gamert,serveron2) 
                VALUES
('$theid','$ipaddress','$gamert','$serveron')
");

 

Obviously I only want them to be able to vote once. What is the best way to do a check of the IPs already in the database and check against theirs before submitting?

 

Thanks.

[ZulfadlyAshBurn]

That would make it more difficult if the users are using dynamic ip. Only some users use static ip. Try something else like logging in or session id

[revraz]

But to answer your question

 

<?php
// Example use of getenv()
$ip = getenv('REMOTE_ADDR');

// Or simply use a Superglobal ($_SERVER or $_ENV)
$ip = $_SERVER['REMOTE_ADDR'];
?> 

 

http://php.net/manual/en/reserved.variables.server.php

 

[Charmees]

What is the best way to do a check of the IPs already in the database and check against theirs before submitting?

 

Thanks.

 

well this is what i did:

 

		$check= mysql_query("select * from voting where ipaddress='$ipaddress'");
	$ipname = mysql_fetch_assoc($check);
	if($ipname['ipaddress'] == $ipaddress) {
                     echo 'IP address already exists in database';  # you can add here anything what you want
	} else {
                     mysql_query ("INSERT INTO voting (theid,ipaddress,gamert,serveron2) VALUES
                     ('$theid','$ipaddress','$gamert','$serveron')");
	}

[KellyJ]

Ok thanks for the help guys.