FIXED: It seems for some reason a empty space is added to the variable :s, just trim() it before it goes into fsockopen and seems to work =/




okay this is doing my head in now because i dont understand why it doesnt work.

PHP Code:

$result = $db->query("SELECT * FROM servers WHERE id='$server_id' OR name='$server_id'");
$row = $db->fetch_row($result);
$server_ip = $row['ip'];  //this is the site you wish to check
 
$server_ip1="91.197.32.125";
$fp = fsockopen($server_ip1,"80");
if($fp)
{
$status1 = '1';
} else {
$status1 = '0';
}
fclose($fp);
echo 'normal: '.$status1; 
 echo '<hr />';
 
  $fp = fsockopen($server_ip, "80");
  if($fp)
  {
  $status = '1';
  } else {
  $status = '0';
  }
 fclose($fp);
 
 echo 'DB:'.$status; 


First one works fine, the second which gets IP from database doesnt.

Ips are the same.

What could be wrong?

IP is stored as varchar in db.

it displays like this:

normal: 1 
 
Warning: fsockopen() [function.fsockopen]: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/USER/public_html/SwinServe/serverstats.php on line 52
 
Warning: fsockopen() [function.fsockopen]: unable to connect to 91.197.32.125:80 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in /home/USER/public_html/SwinServe/serverstats.php on line 52
 
Warning: fclose(): supplied argument is not a valid stream resource in /home/USER/public_html/SwinServe/serverstats.php on line 59
DB:0

Hey Dan,

Just thought I'd throw in a quick suggestion, since you seem to have to only trim when you get the information from the database, you may want to check the script that does the DB insert. Somewhere along the way that extra space is being added and it shouldn't really get into the DB in the first place.

Maybe use the trim() BEFORE it goes into the DB?

JJ!

Nah thats not it... because at the moment i havnt created the admin side, so its direct DB input (PMA)

and i double checked and it doesnt seem to have a space in DB...

So im a little clueless to be honest lol

Dan

Weird! Seriously confusing little error that. Well, good luck with your programming.

JJ