Hellp Need Seperate Ip With Comma

[rastaman46]

Hello im here again

 

im just strugling to add comma between Ip adresses

 

im get result in array like this "141.237.52.41 86.1.223.181" but i need "141.237.52.41,86.1.223.181"

 

Im tryd implode but no succes

[Christian F.]

Why would you do this?

[rastaman46]

I need get users from sql by matching ip up where userip In ('141.237.52.41','86.1.223.181') Like this

 

output im get im can do this

[spfoonnewb]

You can also use preg_replace('/\s/', '', $input) or explode() and many others.

 

However, are you talking about an array or a string? because you mentioned an array but provided a string.

[rastaman46]

Yes its array

 

foreach ($returnStats['listener'] as $listener)

{

$listeners['LISTENERS'] = array(

'HOSTNAME' => (string) $listener->HOSTNAME,

'USERAGENT' => (string) $listener->USERAGENT,

'CONNECTTIME' => (string) $listener->CONNECTTIME,

'POINTER' => (string) $listener->POINTER,

'UID' => (string) $listener->UID,

);

echo $listeners['LISTENERS']['HOSTNAME'];

 

}

[spfoonnewb]

So I assume your hostname is the IP?

[rastaman46]

yes

[rastaman46]

Im tryd use explode like this

$hmm = $listeners['LISTENERS']['HOSTNAME'];

$ip = explode(" " ,$hmm);

 

echo $ip;

 

output = array array

[Christian F.]

Where do you get the IP address you want to match from, and how does the source data look? You can find out by using var_dump ().

[rastaman46]

source im taking it from is shoutcast DNSA server XML file

 

 

var_bump return this

 

string(13) "141.237.52.41" string(12) "86.1.223.181"

[spfoonnewb]

You can either build your own array to implode (use a key based recursive implode) or build the string yourself. Building the string yourself in this case is easiest assuming you needed that second listeners array rebuilt. Also, you should really validate that IP (make sure it's an IP in the correct format) and/or use prepared statements.

 

<?php
//Assume the dataSet appears like this based upon the provided foreach.
$returnStats = array(
   'listener' => array(
       (object) array(
           'HOSTNAME' => '192.168.1.1',
           'USERAGENT' => 'Google Chrome',
           'CONNECTTIME' => '60',
           'POINTER' => '0',
           'UID' => '1Z5548488484'
       ),
       (object) array(
           'HOSTNAME' => '192.168.1.2',
           'USERAGENT' => 'Mozilla Firefox',
           'CONNECTTIME' => '120',
           'POINTER' => '0',
           'UID' => '1Z5584844484'
       )
   )
);

$listeners = array();
$ipStr = 'WHERE IN (';
foreach ($returnStats['listener'] as $listener) {
   $listeners[] = array(
       'HOSTNAME' => (string) $listener->HOSTNAME,
       'USERAGENT' => (string) $listener->USERAGENT,
       'CONNECTTIME' => (string) $listener->CONNECTTIME,
       'POINTER' => (string) $listener->POINTER,
       'UID' => (string) $listener->UID
   );
   $ipStr .= "'{$listener->HOSTNAME}',";
}
$ipStr = substr($ipStr, 0, -1).')';

var_dump($ipStr);

//You can use the listeners array if you need it, but you shouldn't define a key.
var_dump($listeners);

[rastaman46]

Love u man

 

Big thanks