Regular Expressions and/or explode()

ghanson

Hi i am looking for somebody who can help me out here, i'm building a script that managed OpenVZ VPS Servers after running a command in shell im given this:

ssh wrote:
VEID NPROC STATUS IP_ADDR HOSTNAME
110 55 running 102.95.136.9 server.vpsempire.net
120 54 running 102.95.14.3 server.digitalised-data.com
140 27 running 102.95.153.69 server.avoyellesparishonline.com
150 65 running 19.58.16.1 vps01.ainap.com
170 55 running 162.125.168.158 vps.joyus.org

Formatted exactly as above, i am trying to display the above information in variables, Which is easy if i have only 1 as the spacing is different etc.

for example VEID: 110
i can do $array[4] to display VEID and $array[12] to display HOSTNAME, but on VEID 120: Hostname becomes $array[11] due to the +1 Whitespace from the smaller IP. and this happens between all fields.

I need somebody who can be real real kind and fix this little regex script up for me 🙂 here is my current code:

<?php
$command = "sudo -u root /usr/sbin/vzlist $veid";


       $io = array();

       $p = proc_open($command,
                      array(1 => array('pipe', 'w'),
                            2 => array('pipe', 'w')),
                      $io);

       /* Read output sent to stdout. */
       while (!feof($io[1])) {
           $output .= htmlspecialchars(fgets($io[1]),
                                                   ENT_COMPAT, 'UTF-8');
       }
       /* Read output sent to stderr. */
       while (!feof($io[2])) {
           $output .= htmlspecialchars(fgets($io[2]),
                                                   ENT_COMPAT, 'UTF-8');
       }

       fclose($io[1]);
       fclose($io[2]);
       proc_close($p);

//echo('<pre>'.$output.'</pre>');

$line = explode("HOSTNAME", $output);
//print_r($line);
$spaces = explode(" ", $line[1]);

$no_procs = $spaces[40];
$ve_status = $spaces[41];
$ve_mainip = $spaces[42];
$ve_hname = $spaces[44];

echo "<div align='center'>
	<table border='0' cellpadding='5' cellspacing='0' width='100%' bgcolor='#FFFFCC' style='border: 1px solid #FFFF3E; padding: 0'>
		<tr>
			<td width='25%'><b><font face='Verdana' size='2'>VPS Status:</font></b></td>
			<td width='25%'><font face='Verdana' size='2'>$ve_status</font></td>
			<td width='25%'><b><font face='Verdana' size='2'>Master IP:</font></b></td>
			<td width='25%'><font face='Verdana' size='2'>$ve_mainip</font></td>
		</tr>
		<tr>
			<td width='25%'><b><font face='Verdana' size='2'>Running Processes:</font></b></td>
			<td width='25%'><font face='Verdana' size='2'>$no_procs</font></td>
			<td width='25%'><b><font face='Verdana' size='2'>Hostname:</font></b></td>
			<td width='25%'><font face='Verdana' size='2'>$ve_hname</font></td>
		</tr>
	</table>
</div>";
?>

bradgrafelman

Sorry, solicitations are against the AUP here.

At any rate, I'm a bit confused at your code. All you'd need to do is to first explode() the data on line breaks, and then you could loop through each line and grab the columns like so:

$data = explode("\n", $data); // explode data into an array on line breaks

foreach($data as $line) {
    $col = preg_split('/\s+/', $line);

echo "VEID: $col[0], NPROC: $col[1], ..."; // etc. for each column
}

ghanson

If it was so simple i'd be happy!

using explode() is great for VEID: 110

but each VEID Line that comes up shows a different ammount of spaces between each result the QUOTE option here took out the extra spaces, here is how it looks direct paste from SSH / vzlist

       380         26 running 66.90.83.203    ranch.wickedrss.com
       390         49 running 66.90.83.204    server2.betsysptchosting.info
       400         52 running 208.53.169.227  elyannanetworks.net
       410          5 running 66.90.124.132   vpsempire.budian.cn
       420         18 running 66.90.124.146   genesis.gloryimsaved.com
       430         55 running 66.90.83.207    jmxxs00
       440         29 running 66.90.83.208    fry.boomwise.com

Hopefully this helps, If your code above will infact split this is there any chance of helping me replace my working variables

$no_procs = $spaces[40];
$ve_status = $spaces[41];
$ve_mainip = $spaces[42];
$ve_hname = $spaces[44];

Thanks, and sorry for violating the AUP, the site keeps refreshing on me for some reason i had to write these posts in notepad then drop them in.

NogDog

You could explode each line with preg_split():

$fields = preg_split('/ +/', $line);

Weedpacket

ghanson wrote:
using explode() is great for VEID: 110

bradgrafelman suggested using explode() to separate all the data into individual lines (if you haven't done that already). Read the rest of his post to see his suggestion for handling each line.