fetch before double dot

[karimali831]

Hey!

 

I am sure there is a way round this... I am using one column to store both IP and port e.g. 123.45.67.89:1234

I want to fetch only the IP, so I want to the output before the double dot. 

 

Can someone show me how I can do this please?

 

Many thanks...

[Maq]

There are a bunch of different ways to do this, I prefer something like this:

$s = "123.45.67.89:1234";
$pieces = explode(":", $s);
echo "IP: " . $pieces[0];
echo "Port: " . $pieces[1];

[gristoi]

<?php
$fullIp = '123.45.67.89:1234';

$justIp = explode(':',$fullIp);

//this gives you an array created from the string so $justIp[0] is what you need
?>

[karimali831]

thank you!