[RESOLVED] sort problems - verifying 2 arrays

Reiners

Hello!
I've got the following problem with my script and appreciate any help 😉

First of all what my script does:
- it reads out information about the system connections and running process by using DOS commands like "netstat" or "tasklist" (tasklist is only available at winXP prof., btw)
- it splits every line and every chunks into an array for the netstat- and tasklist-command
- it verifies both arrays by checking the "PID" (it's the only data which exists in both arrays)
- it displays all informations of the PID's in a table

(why? because the netstat command does not display the processname. thats why I fetch the output of the netstat command and the tasklist command)

Example for netstat-command:
http://home.arcor.de/r3in3rs/info/netstat.JPG

Example for tasklist-command:
http://home.arcor.de/r3in3rs/info/tasklist.JPG

ok. That works pretty well, but I also want to add a function to sort the content of my table (by clicking on the tableheader). And here comes the problem :/

Here is my script (cut to the bone):

////////// get information about connections //////////////


$input_net = shell_exec("cmd /c netstat.exe -ano");

$line_net = explode("\n", trim($input_net));


for ($i=0; $i<count($line_net); $i++)
  {

$data_net = explode(" ",trim($line_net[$i]));



if($order == 'PID')
{
$key[] = $data_net[4];
}
else if($order == 'Remaddi')
{
$key[] = $data_net[2];
}
else if($order == 'Protokoll')
{
$key[] = $data_net[0];
}



$rows_net[]=$data_net;

  }


//////////// get information about processes //////////////


$input_proz = shell_exec("cmd /c tasklist.exe /NH /FO CSV");

$line_proz = explode("\n", trim($input_proz));


for ($i=0; $i<count($line_proz); $i++)
  {

$data_proz = explode(",", trim($line_proz[$i]));


if($order == 'Process')
{
$key[] = $data_proz[0];
}

$rows_proz[]=$data_proz;

  }


//////////////////////// sort /////////////////////////////


if ($order == 'Process')
  {
    array_multisort($key, SORT_ASC, SORT_STRING, $rows_proz);
  }


if ($order == 'PID')
  {
    array_multisort($key, SORT_ASC , SORT_NUMERIC,$rows_net);
  }


if ($order == 'Adress')
  {
    array_multisort($key, SORT_ASC , SORT_NUMERIC,$rows_net);
  }


if ($order == 'Protokoll')
  {	
    array_multisort($key, SORT_ASC , SORT_REGULAR,$rows_net);
  }


////////////////// display table header ///////////////////


echo '<table>
      <tr>
      <td><a href=my.php?order=PID>	 PID	  </a></td>
      <td><a href=my.php?order=Process>	 Process  </a></td>
      <td><a href=my.php?order=Protokoll>Protokoll</a></td>
      <td><a href=my.php?order=Adress>   Adress   </a></td>
      </tr>';


/////////////////// display table lines ///////////////////


foreach($rows_net as $data_net)
{
 foreach($rows_proz as $data_proz)
 {   

 // PID == PID 
 if ($data_net[4] == $data_proz[1])
     {	   

 echo '<tr>
   <td>$data_net[4]</td>
   <td>$data_proz[1]</td>
   <td>$data_net[0]</td>
   <td>$data_net[2]</td>
   </tr>';
 }

 }
}

echo '</table>';

///////////////////////////////////////////////////////////
?>

Ok. By clicking on the tableheaders is should actually sort it chunks. But that works only for the PIDs (problably because it exists in both arrays). By clicking on the tableheader "process" (for example) it doesn't sort the processes alphabetically. It just sorts the lines in the order they appear in the commando line, if the order has been changed (by sorting by "PID" for example).
Anyone an idea how to fix this ? I think the problem are those two "for each" loops, but I am not entirely shure and dont know how to avoid them.

Thanks a lot for reading and any hint that helps 😉
(and sorry for my bad english :p )

Reiners

Right now I am trying to avoid those two foreach-loops.
My idea was to fetch the process name from the data_proz and write it into the existing array data_net.
Sorting with only one array (data_net) works perfect and the problem would be solved.

But I dont know why this transfer doesnt works:

foreach($rows_net as $data_net)
{
foreach($rows_proz as $data_proz)
 {
 // if the PID equals, write the processname into a new element of data_net
 if ($data_net[4] == $data_proz[1])
     {
     $data_net[5] = $data_proz[0];
     }
 }
}

Unfortunetly, when I echo the added element it is empty:

echo $rows_net[0][5]; // ---> empty
echo $rows_net[1][5]; // ---> empty
echo $rows_net[2][5]; // ---> empty

How do I add a new element to an array correctly ?

I've already tried:

foreach($rows_net as $data_net)
{
foreach($rows_proz as $data_proz)
 {
 if ($data_net[4] == $data_proz[1])
     {
     $data_net[] = $data_proz[0];
     }
 }
}


and


foreach($rows_net as $data_net)
{
foreach($rows_proz as $data_proz)
 {
 if ($data_net[4] == $data_proz[1])
     {
     array_push($data_net, $data_proz[0]);
     }
 }
}

But the element $data_net[5] is still empty, although $data_proz[0] exists and my if-clause gets complied.

Reiners

I found out that the transfer works actually. When I echo my elements while those foreach-loops are still running it shows that the transfer of the element worked.
But after the foreach loops they are empty again. anyone an idea why ?

foreach($rows_net as $data_net)
{
foreach($rows_proz as $data_proz)
 {
 if ($data_net[4] == $data_proz[1])
    {
    echo "<pre>".$data_net[4]."=".$data_proz[1]."-->".$data_proz[0]." ";

 $data_net[] = $data_proz[0];

 echo ":".$data_net[5].":\n</pre>";

}

 }
}

echo "<pre>1:".$rows_net[0][5]."\n</pre>";
echo "<pre>2:".$rows_net[1][5]."\n</pre>";
echo "<pre>3:".$rows_net[2][5]."\n</pre>";
echo "<pre>4:".$rows_net[3][5]."\n</pre>";
echo "<pre>5:".$rows_net[4][5]."\n</pre>";

output:

0=0-->System Idle Process :System Idle Process:

1572=1572-->Apache.exe :Apache.exe:

1644=1644-->Apache.exe :Apache.exe:

2408=2408-->opera.exe :opera.exe:

2220=2220-->Icq.exe :Icq.exe:

2220=2220-->Icq.exe :Icq.exe:

1:

2:

3:

4:

5:

As you can see the element were filled with the correct information. But why do they disappear again after the loop finishes ?

Reiners

Finally it works with following code:

foreach($netstat as $netstatKey => $netstatValue) 
{ 
    foreach($tasklist as $tasklistKey => $tasklistValue) 
    { 
        if($netstatValue[0] == $tasklistValue[0]) 
        { 
            $netstat[$netstatKey][] = $tasklistValue[1]; 
        } 
    } 
}

I didn't knew that the foreach loop just uses a copy of the arrays. Thats why the changes dont persist after the loops.

Know everything is in one multiarray which allows me to order more easily

if ($order == 'Process')
{
    array_multisort($key, SORT_ASC, SORT_REGULAR, $rows_net);
}