storing and retv ipaddress?

[desjardins2010]

hey all;

 

I had a post in here I was getting help with and I can't figure out how to search for all my post so for that i apologize...

 

I'm needing to give a user an ip address prob is when I try to store in the the database it don't store.. it cuts it?

 

anyone help on how to do this and be able to refer to it per user

[PnzrDrgoon]

What kind of field are you using in the table?  Have you tried lengthening it?

[Pikachu2000]

Have a look at INET_ATON() and INET_NTOA().

[desjardins2010]

thanks thats what I was looking for I couldn't remember....

[desjardins2010]

Pikachu2000 maybe you might have a way for me to do what I'm trying to do.. I want that when the user registers to inster into IPaddress feild a random ip address, then for me to be able reference that IP later as a way of pulling that user info

[Pikachu2000]

I don't really follow what you're asking.

[PFMaBiSmAd]

Here's your existing thread where you first asked the question - http://www.phpfreaks.com/forums/mysql-help/how-to-get-database-to-accept/

 

Here's your existing thread after you added inet_aton() to the code - http://www.phpfreaks.com/forums/php-coding-help/this-was-working-fine/

 

 

[Viper69]

hey all;

 

I had a post in here I was getting help with and I can't figure out how to search for all my post so for that i apologize...

 

I'm needing to give a user an ip address prob is when I try to store in the the database it don't store.. it cuts it?

 

anyone help on how to do this and be able to refer to it per user

 

This script works, I didnt write it but I have used it successfully to store ip addresses

$ip = getRealIpAddr();

function getRealIpAddr() 
{ 
    if (!empty($_SERVER['HTTP_CLIENT_IP']))   //check ip from share internet 
    { 
      $ip=$_SERVER['HTTP_CLIENT_IP']; 
    } 
    elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))   //to check ip is pass from proxy 
    { 
      $ip=$_SERVER['HTTP_X_FORWARDED_FOR']; 
    } 
    else 
    { 
      $ip=$_SERVER['REMOTE_ADDR']; 
    } 
    return $ip; 
} 

 

[desjardins2010]

ya thats using there real IP address what I'm trying to accomplish is when a user registers for the game they are given a random IP address, this ip address is stored in the database under a field IPaddress, later I want to be able to SELECT the user if there IP address matches the one entered into a form...

 

so really just a way of given a user a random ip address on register as a feild that is INSERTED into the database when they register and then being able to reference that IP address later...

 

[Pikachu2000]

What do you mean you're going to give the user a random IP address? If it's just as it sounds, you can't do that.