PHP/MySQL and XML

DJDOG

Hello,

I'm looking for some help so I'm going to try an explain what I'm trying to do.

I have a variable that outputs data from an XML Script, but I have it setup to display from more than one xml feed. (Same data) therefore outputs a result, In this case a number.

The numbers are like

5
9
24

These are examples, Once they're echoed out what I would like to do is add them together, but they use the same variable.

Call it $max

If it uses the same variable, How would I add these numbers together? I could be overlooking something.

I've tried adding this numbers by using - as a delimiter to separate them and use an explode to create each number there own variable by using

$addMax = $max2[0]+$max2[1]+$max2[2];
echo $addMax;

and It should be able to display, by total...but goes back to a list of numbers if as I was using $max;

        $max = "$XMLdata-";
        $max2 = explode("-", $max);
        $addMax = $max2[0]+$max2[1]+$max2[2]+$max2[3]+$max2[4]+$max2[5]+$max2[6]+$max2[7]+$max2[8]+$max2[9]+$max2[10]+$max2[11]+$max2[12]+$max2[13]+$max2[14]+$max2[15];     

        echo $addMax;

Should be result: 38

Result: 5924 (Notice it's the numbers without the -)

Please help me fix this or point me into another solution.

Thanks

TheoGB

Have you tried putting in

        $max2 = explode("-", $max); 

    print_r($max2);

    $addMax = $max2[0]+$max2[1]+$max2[2]+$max2[3]+$max2[4]+$max2[5]+$max2[6]+$max2[7]+$max2[8]+$max2[9]+$max2[10]+$max2[11]+$max2[12]+$max2[13]+$max2[14]+$max2[15];

So you can check the array you're about to sum is definitely correct? Also it would make more sense to do:


$addMax = 0;

for($i = 0; $i< count($max2); $i++)
    $addMax += $max2[$i];

halojoy

To further simplify
we have a function [man]array_sum/man

        $max = "$XMLdata-";
        $max2 = explode("-", $max);
        $addMax = array_sum($max2);     

        echo $addMax;

But first, like Theo said, do a test that $max2 array
have those nmbers you want to add correctly.
5924 is not what you want, when you expect 38

$max = "$XMLdata-";
$max2 = explode("-", $max);
echo '<pre>';
print_r($max2); // show what $max2 is like

DJDOG

Here's my result (real numbers)

571010111718181818182022242626

5 is the first number.
2 is the second number.
Add those together you get 7.
3 is the third number.
You get 10.
0 is the fourth number.
You get 10.

and so on...

16 numbers total...

Code Used:

        $max  = "$currentlisteners-";
        $max2 = explode("-", $max);
	for($i = 0; $i< count($max2); $i++)
    	$addMax += $max2[$i];
        echo $addMax;

I'm going to explain what I'm extactly doing.

$fp = @fsockopen("".$data["hostname"]."", "".$data["port"]."", $errno, $errstr, 100);
 if(!$fp) {
 echo "<td align=\"center\"><font class='black10' color=red><b><a href=\"http://".$data["hostname"].":".$data["port"]."\" target=\"_blank\">Offline</a></b></font></td>";
  }
  else {
       if($scsuccs!=1){
        fputs($fp,"GET /admin.cgi?pass=APASS&mode=viewxml HTTP/1.0\r\nUser-Agent: SHOUTcastPRO (Mozilla Compatible)\r\n\r\n");
        while(!feof($fp)) {
      $page .= fgets($fp, 1000);
     }
}
$loop = array("AVERAGETIME", "MAXLISTENERS", "SERVERGENRE", "SERVERURL", "STREAMSTATUS", "SERVERTITLE", "BITRATE", "SONGTITLE", "IRC", "ICQ", "AIM", "CURRENTLISTENERS");
 $y=0;
  while($loop[$y]!=''){
  $pageed = ereg_replace(".*<$loop[$y]>", "", $page);
   $scphp = strtolower($loop[$y]);
   $$scphp = ereg_replace("</$loop[$y]>.*", "", $pageed);
  if($loop[$y]==SERVERGENRE || $loop[$y]==SERVERTITLE || $loop[$y]==SONGTITLE || $loop[$y]==SERVERTITLE)
 $$scphp = urldecode($$scphp);
$y++;
}
$pageed = ereg_replace(".*<SONGHISTORY>", "", $page);
 $pageed = ereg_replace("<SONGHISTORY>.*", "", $pageed);
  $songatime = explode("<SONG>", $pageed);
   $r=1;
    while($songatime[$r]!=""){
     $t=$r-1;
     $playedat[$t] = ereg_replace(".*<PLAYEDAT>", "", $songatime[$r]);
    $playedat[$t] = ereg_replace("</PLAYEDAT>.*", "", $playedat[$t]);
   $song[$t] = ereg_replace(".*<TITLE>", "", $songatime[$r]);
   $song[$t] = ereg_replace("</TITLE>.*", "", $song[$t]);
   $song[$t] = urldecode($song[$t]);
   $dj[$t] = ereg_replace(".*<SERVERTITLE>", "", $page);
 $dj[$t] = ereg_replace("</SERVERTITLE>.*", "", $pageed);
$r++;
}
fclose($fp);
}
if($fp) {
 if($streamstatus=="1") {
        echo "<td align=\"center\"><font class='black10' color=red><b><a href=\"http://".$data["hostname"].":".$data["port"]."\" target=\"_blank\">Online</a></b></font></td>
        <td align='center'>".$song[0]."</font></td>
        <td align='center'>".$currentlisteners."/".$maxlisteners."</font></td>";
        $max  = "$currentlisteners-";
        $max2 = explode("-", $max);
	for($i = 0; $i< count($max2); $i++)
    	$addMax += $max2[$i];
        echo $addMax;
	}
}

I have 16 Shoutcast Ports and I'm trying to use the $currentlisteners varablie to ADD all 16+ current listeners we have total, Once get that working I'll be using the same for $maxlisteners.

If we add more Shoutcast Ports it will calculate the new ones as well once the page is loaded.

As for the count function, I was planning on doing that once I figured out how to get them added...but seems as it's not working.

DJDOG

Array ( [0] => 4 [1] => ) Array ( [0] => 5 [1] => ) Array ( [0] => 1 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => 1 [1] => ) Array ( [0] => 4 [1] => ) Array ( [0] => 1 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => 2 [1] => ) Array ( [0] => 2 [1] => ) Array ( [0] => 2 [1] => ) Array ( [0] => 3 [1] => ) Array ( [0] => 0 [1] => )

DJDOG

The little numbers are current.
The big numbers are max.

Add all current numbers together.
Add all max numbers together.

Total: 100/1500 (Example)

TheoGB

Your explanation is a bit confusing. You seem to be adding the - at the end of numeric value:

if($streamstatus=="1") {
        echo "<td align=\"center\"><font class='black10' color=red><b><a href=\"http://".$data["hostname"].":".$data["port"]."\" target=\"_blank\">Online</a></b></font></td>
        <td align='center'>".$song[0]."</font></td>
        <td align='center'>".$currentlisteners."/".$maxlisteners."</font></td>";
        $max  = "$currentlisteners-";
        $max2 = explode("-", $max);
    for($i = 0; $i< count($max2); $i++)
        $addMax += $max2[$i];
        echo $addMax;
    }
}

And then you use eplode() to get the number back? Why not just add $currentlisteners to $addMax?

When I wrote that sample code I was assuming you had a single text field like this:
"3-4-5-6-2-10-4-11"
And where running explode over that?

As far as that block of code goes, I would have expected $addMax to finish as zero since you don't apparently declare it anywhere else but inside the For...Loop which would mean it only has scope inside that loop (hence why I first declared it outside the loop). That said, your code output above implies you're getting almost the right values out but then your listing of the arrays doesn't hold that:

5 7 10 10 11 17 18 18 18 18 18 20 22 24 26 26
doesn't match the array out of
4, 5, 1, 0, etc.

Are you still getting the incorrect $addMax now?

DJDOG

Ok.

Found this issue.

if($fp) {
 if($streamstatus=="1") {
        echo "<td align=\"center\"><font class='black10' color=red><b><a href=\"http://".$data["hostname"].":".$data["port"]."\" target=\"_blank\">Online</a></b></font></td>
        <td align='center'>".$song[0]."</font></td>
        <td align='center'>".$currentlisteners."/".$maxlisteners."</font></td>";
	for ($i=0; $i< count($currentlisteners); $i++)
        $addCurrent += $currentlisteners[$i];
	for ($i=0; $i< count($maxlisteners); $i++)
    	$addMax += $maxlisteners[$i];
        }
}

I had to move the echo $addMax; out of that because it was causing this weird number error.

             	echo "".$addCurrent."/".$addMax."";

Result: 18/28

18 is Correct, Therefore it does work!

The 28 I don't understand, because the $maxlisteners should be a total of 1550.