Iterate over/on a list?

scrupul0us

I'm writing an app to parse IIS logs

This is what I have so far:

$fp = fopen($file,'r');
$i = 0;
while($line = fgets( $fp ,1024 ))
{	list($date,$time,$s_sitename,$s_ip,$cs_method,$cs_uri_stem,$cs_uri_query,$s_port,$cs_username,$c_ip,$cs_user_agent,$cs_referer,$cs_host,$sc_status,$sc_substatus,$sc_win32_status,$sc_bytes,$cs_bytes) = explode(' ',$line);
}

what Id like to be able to do is iterate over that list within the while loop so for each line of log I can quickly and cleanly build an XML structure dynamically like this:

//LOOP START
$xml .= '<$listVarName>$listVarValue</$listVarName>';

//EG <date>2009-12-03</date>

any ideas?

richie

Why not do something like:

$contents = file($file);

while(list($date,$time,$s_sitename,$s_ip,$cs_method,$cs_uri_stem,$cs_uri_query,$s_port,$cs_username,$c_ip,$cs_user_agent,$cs_referer,$cs_host,$sc_status,$sc_substatus,$sc_win32_status,$sc_bytes,$cs_bytes) = each($contents))
{
$xml .= '<$listVarName>$listVarValue</$listVarName>';
}

scrupul0us

i fail to see in that example how I can access the list variable names and values to assign to xml elements / values

richie

Well, since list() gives you an array.
If you want the key for each array element, you can do it with:
key($array);

Otherwise, I'm not really sure what you're asking to do.

scrupul0us

look at my example...

for every variable in the list I need to create an XML element whose name is the variable and whose value is that of the variable

the first variable in the list is date then time then ...

so I need to loop on that list so I can create

<date>2009-12-03</date> 
<time>00:01:43</time>
...
...
...
...

NogDog

Maybe use variable variables?

$keys = array(
   'date',
   'time',
   'etcetera'
);
foreach($keys as $key)
{
   echo "<$key>" . $$key . "</$key>\n";
}

richie

You can also check out the solutions offered here:

http://us2.php.net/manual/en/language.variables.php#49997
http://mach13.com/how-to-get-a-variable-name-as-a-string-in-php

scrupul0us

This is what I ended up with.... not as elegant as I had hoped but its functional:

<?php
$file = 'ex091203.log';
$lines = file($file);

$xml = '<?xml version="1.0" ?>'."\n";
$xml .= '<rss version="2.0">'."\n";
$xml .= '<channel>'."\n";

$format = array('date','time','s_sitename','s_ip','cs_method','cs_uri_stem','cs_uri_query','s_port','cs_username','c_ip','cs_user_agent','cs_referer','cs_host','sc_status','sc_substatus','sc_win32_status','sc_bytes','cs_bytes');
foreach ($lines as $line_num => $line)
{
	if (substr($line,0,1)=='#')	
	{	}
	else
	{
		$array[] = explode(' ',$line);
	}
}
foreach($array as $num => $log_line)
{
	$i=0;
	$xml .= "<item>\n";
	foreach($log_line as $vars)
	{		
		$xml .= "\t<".$format[$i]."><![CDATA[".trim($vars)."]]></".$format[$i].">\n";	
		$i++;
	}
	$xml .= "</item>\n";
}
$xml .= '</channel></rss>';
unset($array);
?>

NogDog

"Works and on schedule" trumps "elegant but behind schedule". 😉

(You can always re-factor later.)