Storing IP Address

[Tenaciousmug]

Alright, the register/login system is fully working with sql injection, BUUUT now I want to store their IP Address. WHOLE new function that I've never dealt with before. So I need some help. Am I doing something wrong?

 

I have the IPadd in the database as INT(10) and then I went down to another drop down list and hit unsigned.

I feel like I'm doing something wrong with the field in the database..

 

{
	$_SERVER['REMOTE_ADDR'] = $IPadd;
	$sql = "INSERT INTO Member (username,createDate,password,firstName,email,IPadd) VALUES ('$username',NOW(),md5('$password'),'$firstName','$email',inet_aton('$IPadd'))";
	mysqli_query($cxn,$sql);
	$_SESSION['auth']="yes";
	$_SESSION['username'] = $username;
	header("Location: testing.php");
}

[Pikachu2000]

Here's a good read about IP addresses and storing them in databases efficiently. Link.

[Tenaciousmug]

That's exactly what I'm already doing. It just won't store.. I am coding the PHP fine and I do have the IPadd field as INT UNSIGNED. Well I don't know what I'm doing wrong now.. I looked at every single tutorial for storing ip addresses and they are all the same and I even copied and pasted their code and it still won't work.

[Pikachu2000]

Ah, I see. May have been helpful for me to scroll to the end of the query and pay attention . . . 

 

 

Anyhow, try reversing the order of this.

 

$_SERVER['REMOTE_ADDR'] = $IPadd;

[Tenaciousmug]

You..are..a..GENIUS!!! Awesome. Thanks so much.