Array hell (parsing a file) -- PHP5 OOP style

[rkolbe]

Ok...so...I am editing this post to make it easier to understand my problem.

My class returns a flattened array such as:

[0]BBB
[1]CCC
[2]CCC
[3]BBB
[4]CCC
[5]CCC
[6]BBB
[7]CCC
[8]CCC

The number in brackets is the key. So...what I really need is to unflatten the array so that it reads:

[0]BBB
[0][0]CCC
[0][1]CCC
[1]BBB
[1][0]CCC
[1][1]CCC
[2]BBB
[2][0]CCC
[2][1]CCC

and so on. Is there an easy way to do this?

[Installer]

An array element can have only one value, either a scalar value or an array value. You want to have it both ways. In your "unflattened" array, what would $arr[0] be? It would have to be either "BBB" or array("CCC", "CCC"), but not both; you just can't have more than one simultaneous value for the same array element, or any variable for that matter.

[NogDog]

$ix1 = -1;
$newArray = array();
foreach($array as $value)
{
   if($value == 'BBB')
   {
      $ix1++;
      $newArray[$ix1] = $value;
   }
   else
   {
      $newArray[$ix1][] = $value;
   }
}

Note: I'm not real comfortable with this as (1) it depends on the original array starting with a level 1 value ('BBB'), and (2) it would seem much better to me to incorporate the necessary logic when the array is initially populated rather than after the fact.

[Installer]

$array = array('BBB', 'CCC', 'CCC', 'BBB', 'CCC', 'CCC', 'BBB', 'CCC', 'CCC');

$ix1 = -1; 
$newArray = array(); 
foreach($array as $value) 
{ 
   if($value == 'BBB') 
   { 
      $ix1++; 
      $newArray[$ix1] = $value; 
   } 
   else 
   { 
      $newArray[$ix1][] = $value;  // l. 16
   } 
}

Fatal error: [] operator not supported for strings in C:\htdocs\test\index.php on line 16

[NogDog]

Yeah, I didn't think through all the ramifications (like you did 😉 ). Looks like you'd have to do something that created an array like:

array (
   [0] => array (
      [0] => 'BBB',
      [1] => array(
         [0] => 'CCC',
         [1] => 'CCC'
      )
   ),
   [1] => array (
      [0] => 'BBB',
      [1] => array(
         [0] => 'CCC',
         [1] => 'CCC'
      )
   )
)

However, I suspect a better understanding of the actual functional requirements and real data might give a better indication of what is really needed here.

[Installer]

Or OP might have meant something like this (just guessing):

$array = array('AAA', 'BBB', 'CCC', 'DDD', 'EEE', 'FFF', 'GGG', 'HHH', 'III');

$i = 0;
while (isset($array[$i])) {
    for ($j = 0; $j < 2; $j++) {
        if (isset($array[$i + $j])) {
            $new_array[$array[$i]][$j] = $array[$i + $j + 1];
        } else {
            break 2;
        }
    }
    $i += 3;
}

Array
(
    [AAA] => Array
        (
            [0] => BBB
            [1] => CCC
        )

[DDD] => Array
    (
        [0] => EEE
        [1] => FFF
    )

[GGG] => Array
    (
        [0] => HHH
        [1] => III
    )

)

[rkolbe]

Thank you all for your replies...let me elaborate on my situation as there might be a better way to solve this...

The log file has data such as (taken right from the log file, player names and uid changed):

[Mon Apr 30 17:11:29 2007] *** Results for Map: Worlds\ReleaseMultiplayer\Office
[Mon Apr 30 17:11:29 2007] 
[Mon Apr 30 17:11:29 2007] Player: l33tPlayer (uid: e43A932e4df9115ba34tt3898d64307f)
[Mon Apr 30 17:11:29 2007] Score: 97
[Mon Apr 30 17:11:29 2007] Kills: 22
[Mon Apr 30 17:11:29 2007] Deaths: 10
[Mon Apr 30 17:11:29 2007] Team Kills: 0
[Mon Apr 30 17:11:29 2007] Suicides: 1
[Mon Apr 30 17:11:29 2007] Objective: 0
[Mon Apr 30 17:11:29 2007] 
[Mon Apr 30 17:11:29 2007] Player: TheKing (uid: 6ee1b98804d39a99930d7c1ba38ccc2l)
[Mon Apr 30 17:11:29 2007] Score: 17
[Mon Apr 30 17:11:29 2007] Kills: 7
[Mon Apr 30 17:11:29 2007] Deaths: 18
[Mon Apr 30 17:11:29 2007] Team Kills: 0
[Mon Apr 30 17:11:29 2007] Suicides: 0
[Mon Apr 30 17:11:29 2007] Objective: 0

Currently, I have a custom class that reads the file in reverse, parsing each line and checking them against an array of regular expressions. Here is that array of regexs:

Regex array

$patterns = array(
	array('Player', 	'/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Player:\s+(.*)\s+\(uid:\s+(?:.*)\)$/'), 
	array('UID', 		'/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Player:\s+(?:.*)\(uid:\s+(.*)\)$/'),
	array('Score', 		'/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Score:(.*)(?:.*)?$/'),
	array('Kills', 		'/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Kills:(.*)(?:.*)?$/'),
	array('Deaths', 	'/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Deaths:(.*)(?:.*)?$/'),
	array('Team Kills', '/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Team Kills:(.*)(?:.*)?$/'),
	array('Suicides', 	'/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Suicides:(.*)(?:.*)?$/'),
	array('Objective', 	'/^\[(?:Mon|Tue|Wed|Thu|Fri|Sat|Sun)\s+(?:Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+(?:[0-9]{2})\s+(?:[0-9]{2}):(?:[0-9]{2}):(?:[0-9]{2})\s+20(?:[0-9]{2})\]\s+Objective:(.*)(?:.*)?$/')
	);

Now, the first item in each array (e.g. Player, Score, etc) is currently how we name each key of the (new) array we put the results in. It will make a little bit more sense in a minute...I hope.

Here is the routine that parses the file and currently creates my flattened array...the part that I think really needs help (root of the problem):

private function parseFile(){
		// until SOF or our index pointer is reached, we read from the bottom up of the file
		$tt = 0;
		while(!$this->reader->sof()){
			$line = $this->reader->GetLine();
			for($i = 0; $i < count($this->checks); $i++){
				if(preg_match($this->checks[$i][1], $line, $matches)){
					$this->data[$tt][$this->checks[$i][0]] = $matches[1];
					$tt++;
				}
			}

	}
	// Since we read the file in reverse, let's flip the data right side up in the array
	$this->data = array_reverse($this->data); 
}

Notes: sof() returns the pointer to the start of the file (e.g. 0 [zero]). $this->checks is the array of checks (regexs) passed to this class (what we are trying to find in the file).

Now, if there was a nice and easy way to just create the array as needed right here...that would save a lot of work.

This is the format I need (or at least it would be easier to work with for a lot of things):

Array
(
    [0] => Array
        (
            [0] => l33tPlayer
            [1] => 97
            [2] => 22
            [3] => 10
            [4] => 0
            [5] => 1
            [6] => 0
        )

[1] => Array
    (
        [0] => TheKing
        [1] => 17
        [2] => 7
        [3] => 18
        [4] => 0
        [5] => 0
        [6] => 0
    )
)

After I have the array, I basically create "player" objects that calculate and update the DB (I won't get into that here...I need to clean that code up too much and do some refactoring first...).

Thank you all so much again. I hope this post here helps.