Hello all
Can anyone suggest their best idea for a way to store IP addresses in a
MySQL Database?
Felix
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
INET_ATON
and
INET_NTOA
-Original Message-
From: Felix [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 11:49 AM
To: PHP list
Subject: [PHP] MySQl IP Address Storage
Hello all
Can anyone suggest their best idea for a way to store IP addresses in a
MySQL Database?
Felix
Thank you Robert.
Felix
- Original Message -
From: Robert Covell [EMAIL PROTECTED]
To: Felix [EMAIL PROTECTED]; PHP list [EMAIL PROTECTED]
Sent: Thursday, September 20, 2001 10:55 AM
Subject: RE: [PHP] MySQl IP Address Storage
INET_ATON
and
INET_NTOA
-Original Message
(ipaddress) FROM mytable;
Make sense?
- Original Message -
From: Felix [EMAIL PROTECTED]
To: Robert Covell [EMAIL PROTECTED]; PHP list
[EMAIL PROTECTED]
Sent: Thursday, September 20, 2001 11:29 AM
Subject: Re: [PHP] MySQl IP Address Storage
Thank you Robert.
Felix
- Original Message
Thank you very much.
Felix
- Original Message -
From: Jason Bell [EMAIL PROTECTED]
To: PHP list [EMAIL PROTECTED]
Sent: Thursday, September 20, 2001 12:49 PM
Subject: Re: [PHP] MySQl IP Address Storage
Felix,
Just to save you the headache that I encountered, the column that you
On 20-Sep-2001 Felix wrote:
Hello all
Can anyone suggest their best idea for a way to store IP addresses in a
MySQL Database?
INT UNSIGNED
and use the MySQL functions INET_ATON() INET_NTOA() for converting.
If you're on a pre-3.23 MySQL server then:
// Convert IP string
6 matches
Mail list logo