Ip address storage.

[Anon]

Hello people, I would like some coding help on a problem I'm having, I'm not sure if this can be done as I'm relatively new to php, and mysql but here goes.
In my database, I wanna store an ip address in four fields in a table i.e octet1 octet2 octet3 octet4.
However I would like to enter that data from one input field on a form named 'ipaddress'.
Is there a way I can take the information from the input field and split it, and enter them into their respecive field in the table?

[djg_uk]

Hi Richard,

There is a function called EXPLODE() which satisfies your requirements.

Explode takes a string delimited by a specified character and seperates it into an array.

For example:

$octet = explode($ipaddress, ".");

This will return the following array values for an IP address of 255.255.255.255:

$octet[0] = 255;
$octet[1] = 255;
$octet[2] = 255;
$octet[3] = 255;

So, it is only a question of writing your MySQL query as such:

mysql_query("INSERT INTO [TableName] (octet1,octet2,octet3,octet4) VALUES ('".$octet[0]."','".$octet[1]."','".$octet[2]."','".$octet[3]."')");

Regards,

David

[Anon]

Thanks a lot 🙂

[Anon]

Ok, now here is a question that's a bit more difficult. What about when I want to retrieve the information from the 4 fields in the table, and show it in only one input field in the browser?
How do I go about doing that?

[brandonschnell]

<?

$result = mysql_db_query("db","select concat(octet1,'.',octet2,'.',octet3,'.',octet4) as ip_addr from table");

while($row = mysql_fetch_array($result))
{
echo "IP: " . $row["ip_addr"] . "<BR>";
}
?>