How would I explode this in PHP? :S

[Recursion]

Hey,

I have some log files where I need to explode the lines into seperate cells in a table, Dan told me to use PHP explode(), which is fine, I'd just use a space as the delimiter, but towards the end of the line I get information that has spaces in I don't want to explode.

Example line:

2010.5.28 15:08:28 - 10.0.0.13 http://en.wikipedia.org/w/opensearch_desc.php *EXCEPTION* Exception site match. GET 884 0  1 200 - room4-1.domain.example  -

(Ignore the hyphens, that's information Dansguardian hasn't been able to log).

As you can see, it's fine until I get to the "Exception site match." area.

Help please!

[Apolva]

Which parts of the example do you want separated?

[MattFr]

array explode ( string $delimiter , string $string [, int $limit ] )

Limit, see? Use space as the delimiter, limit to as far as you want to go.

[Moh]

Here ya go
http://habbcrazy.net/jack/thing.php

Source:

<?php

    $string = "2010.5.28 15:08:28 - 10.0.0.13 http://en.wikipedia.org/w/opensearch_desc.php *EXCEPTION* Exception site match. GET 884 0  1 200 - room4-1.domain.example  -";
    
    preg_match( "/([0-9]{4}.[0-9]{1,2}.[0-9]{1,2} [0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2}) - ([0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}) (.*?) \*EXCEPTION\* Exception site match. (.*?) - (.*?) -/", $string, $matches );
    echo "<p>";
    print_r( $matches );
    echo "</p>";
    
    echo "<strong>Date/Time</strong>: {$matches['1']}<br />";
    echo "<strong>IP</strong>: {$matches['2']}<br />";
    echo "<strong>URL</strong>: {$matches['3']}<br />";
    echo "<strong>GET</strong>: {$matches['4']}<br />";
    echo "<strong>URL 2</strong>: {$matches['5']}<br />";

?>

I gave in with the validation at the end LOL

[Jahova]

Nice for doing that ^^ +REP

[MattFr]

Here ya go
http://habbcrazy.net/jack/thing.php

Source:

<?php

    $string = "2010.5.28 15:08:28 - 10.0.0.13 http://en.wikipedia.org/w/opensearch_desc.php *EXCEPTION* Exception site match. GET 884 0  1 200 - room4-1.domain.example  -";
    
    preg_match( "/([0-9]{4}.[0-9]{1,2}.[0-9]{1,2} [0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2}) - ([0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}) (.*?) \*EXCEPTION\* Exception site match. (.*?) - (.*?) -/", $string, $matches );
    echo "<p>";
    print_r( $matches );
    echo "</p>";
    
    echo "<strong>Date/Time</strong>: {$matches['1']}<br />";
    echo "<strong>IP</strong>: {$matches['2']}<br />";
    echo "<strong>URL</strong>: {$matches['3']}<br />";
    echo "<strong>GET</strong>: {$matches['4']}<br />";
    echo "<strong>URL 2</strong>: {$matches['5']}<br />";

?>

I gave in with the validation at the end LOL

Bit OTT lol.

[Moh]

Bit OTT lol.

It's only a preg_match with regular expressions

Use them all the time

[MattFr]

It's only a preg_match with regular expressions

Use them all the time

I know exactly what it is only

Meh, each to their own.

[Source]

"Bit OTT lol."

Yes, let's all moan at someone for using common sense to create a method that isn't bodging it with an explode.

[MattFr]

"Bit OTT lol."

Yes, let's all moan at someone for using common sense to create a method that isn't bodging it with an explode.

I wasn't moaning. A log viewer isn't something that needs to be efficient though, I think practically for the application; there's no point doing the regex for something that isn't important. See see?