[RESOLVED] Get IP

jbachris

Is there a way to get a person's IP when they add an item?

I have a voting system on my site, but I've had a few people "stuff the ballots" and want to track IPs. How can I do this easily?

Can I have a:

Thanks!

laserlight

Try say, $_SERVER['REMOTE_ADDR'].

jbachris

laserlight wrote:
Try say, $_SERVER['REMOTE_ADDR'].

i have this:

$sql = 'INSERT INTO rating ( player_id, draft_id, rating_value, ip ) VALUES (' . $player_rating[0] . ', "2006",' .  $player_rating[1] . ',' .  $_SERVER['REMOTE_ADDR'] . ')';

But it isn't inserting anything...

laserlight

$sql = "INSERT INTO rating ( player_id, draft_id, rating_value, ip )
	VALUES ('{$player_rating[0]}', '2006', '{$player_rating[1]}', '{$_SERVER['REMOTE_ADDR']}')";

jbachris

laserlight wrote:

$sql = "INSERT INTO rating ( player_id, draft_id, rating_value, ip )
	VALUES ('{$player_rating[0]}', '2006', '{$player_rating[1]}', '{$_SERVER['REMOTE_ADDR']}')";

hm, nothing. i'm thinking in need to call or $_GET the address first, right?

laserlight

Test with:

<?php echo $_SERVER['REMOTE_ADDR']; ?>

jbachris

laserlight wrote:
Test with:
<?php echo $_SERVER['REMOTE_ADDR']; ?>

it works. i have this code:

<?

require ( "db_conn.inc.php" );

// First, check whether the add vote form was submitted
if ( $_POST['add_votes'] ) {
	foreach ( $_POST as $key => $val ) {
		if ( eregi ( "rating", $key ) ) {
			$player_rating = explode ( "_", $val );
			$sql = 'INSERT INTO rating ( player_id, draft_id, rating_value, ip ) VALUES (' . $player_rating[0] . ', "2006",' .  $player_rating[1] . ',' . $ip . ')';
			$add_rating_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() );
		}
	}
	header ( "Location: results.php" );
	exit;	
}

$draft_rs = $conn->Execute ( "SELECT * FROM player ORDER BY player_pick ASC" ) or die ( $conn->ErrorMsg() );
$playerid = $draft_rs->Fields("player_id");

?>

I have this in the <form></form> area:

<input name="ip" type="hidden" id="ip" value="<?php echo $_SERVER['REMOTE_ADDR']; ?> ">

It isn't inserting the IP into the DB, but it is inserting the rest of the info and the IP address displays when I echo it.

Houdini

Try doing this and see if it isn't easier

$ip = $_SERVER['REMOTE_ADDR'];
$sql = 'INSERT INTO rating ( player_id, draft_id, rating_value, ip ) VALUES (' . $player_rating[0] . ', "2006",' .  $player_rating[1] . ',' $ip ')';

bradgrafelman

Houdini's code is missing some periods there at the end... though there's no need to store the IP in yet another array...

$sql = 'INSERT INTO rating ( player_id, draft_id, rating_value, ip ) VALUES (' . $player_rating[0] . ', "2006",' .  $player_rating[1] . ',' . $_SERVER['REMOTE_ADDR'] . ')';

Also, if it's not working, try adding some debug info. Every time it loops through, add an echo $sql before it executes the query. That way, you can visually inspect the SQL query. Post the results here if that doesn't work.

jbachris

It is kind of work. When I "vote" instead of redirecting to the results.php page as it is supposed to I get this error message:

"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.185.236)' at line 1"

So it looks like it is trying to get the IP, right?

<?

require ( "includes/db_connex_fake_file.php" );

// First, check whether the add vote form was submitted
if ( $_POST['add_votes'] ) {
	foreach ( $_POST as $key => $val ) {
		if ( eregi ( "rating", $key ) ) {
			$player_rating = explode ( "_", $val );
			$sql = 'INSERT INTO rating ( player_id, match_id, rating_value, ip ) VALUES (' . $player_rating[0] . ',' . $_POST['match_id'] . ',' .  $player_rating[1] . ',' . $_SERVER['REMOTE_ADDR'] . ')';
			$add_rating_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() );
		}
	}
	header ( "Location: results.php?match_id=" . $_POST['match_id'] );
	exit;	
}
?>

Skull

change

            $sql = 'INSERT INTO rating ( player_id, match_id, rating_value, ip ) VALUES (' . $player_rating[0] . ',' . $_POST['match_id'] . ',' .  $player_rating[1] . ',' . $_SERVER['REMOTE_ADDR'] . ')';

            $sql = "INSERT INTO rating ( player_id, match_id, rating_value, ip ) VALUES (" . $player_rating[0] . "," . $_POST['match_id'] . "," .  $player_rating[1] . ",'" . $_SERVER['REMOTE_ADDR'] . "')";

jbachris

Skull wrote:

change

            $sql = 'INSERT INTO rating ( player_id, match_id, rating_value, ip ) VALUES (' . $player_rating[0] . ',' . $_POST['match_id'] . ',' .  $player_rating[1] . ',' . $_SERVER['REMOTE_ADDR'] . ')';

            $sql = "INSERT INTO rating ( player_id, match_id, rating_value, ip ) VALUES (" . $player_rating[0] . "," . $_POST['match_id'] . "," .  $player_rating[1] . ",'" . $_SERVER['REMOTE_ADDR'] . "')";

perfect, thanks.