Re: [PHP] Newbie challenge to brainiacs
On Wednesday 15 May 2002 16:20, Josh Edwards wrote: > The challenge is to do it without SQL. Which blog do you recommend? > > > "David Jackson" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Jay Blanchard wrote: > > > > The burning issue that begs to be answered is, why reinvent the wheel? > > There is a least a dozen blogs on freshmeat for PHP along... > > Unless your doing it just for kicks, which is OK. Not sure what blogs have to do with this? IIRC the OP was trying to analyse webserver log files. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Your computer hasn't been returning all the bits it gets from the Internet. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Newbie challenge to brainiacs
The challenge is to do it without SQL. Which blog do you recommend? "David Jackson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Jay Blanchard wrote: > > > The burning issue that begs to be answered is, why reinvent the wheel? > There is a least a dozen blogs on freshmeat for PHP along... > Unless your doing it just for kicks, which is OK. > > David > > > > [snip] > > > I want to try to find the hour that has the most hits > > > The day of the week that has the most hits > > > and the max and ave no of hits of these. > > > > I haven't given it a whole lot of thought but I'd be tempted to dump the > > whole thing into an appropriately structured sql database and then use > > SELECT's to extract the information you want. It'll likely end up > > faster and less processor intensive than doing it in php by itself I > > suspect. > > [/snip] > > > > +1 > > > > Not only that, but then you will have the ability to create queries for > > other important factors in the logs without having to recode, or create > > code. > > > > Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Newbie challenge to brainiacs
Jay Blanchard wrote: > The burning issue that begs to be answered is, why reinvent the wheel? There is a least a dozen blogs on freshmeat for PHP along... Unless your doing it just for kicks, which is OK. David > [snip] > > I want to try to find the hour that has the most hits > > The day of the week that has the most hits > > and the max and ave no of hits of these. > > I haven't given it a whole lot of thought but I'd be tempted to dump the > whole thing into an appropriately structured sql database and then use > SELECT's to extract the information you want. It'll likely end up > faster and less processor intensive than doing it in php by itself I > suspect. > [/snip] > > +1 > > Not only that, but then you will have the ability to create queries for > other important factors in the logs without having to recode, or create > code. > > Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Newbie challenge to brainiacs
[snip] > I want to try to find the hour that has the most hits > The day of the week that has the most hits > and the max and ave no of hits of these. I haven't given it a whole lot of thought but I'd be tempted to dump the whole thing into an appropriately structured sql database and then use SELECT's to extract the information you want. It'll likely end up faster and less processor intensive than doing it in php by itself I suspect. [/snip] +1 Not only that, but then you will have the ability to create queries for other important factors in the logs without having to recode, or create code. Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Newbie challenge to brainiacs
> Here is a sample of my weblog that reads into an array from a file ie > I want to try to find the hour that has the most hits > The day of the week that has the most hits > and the max and ave no of hits of these. I haven't given it a whole lot of thought but I'd be tempted to dump the whole thing into an appropriately structured sql database and then use SELECT's to extract the information you want. It'll likely end up faster and less processor intensive than doing it in php by itself I suspect. CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Newbie challenge to brainiacs
On Tuesday 14 May 2002 19:42, Josh Edwards wrote:
> Here is a sample of my weblog that reads into an array from a file ie
>
> $filename = ("combined_log");
> $fcontents = file($filename);
>
> 203.29.154.13 - - [08/May/2002:21:21:07 +1000] "GET /A1.php HTTP/1.1" 200
> 417 "-
> " "Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)"
To help you get started this regex will match your input lines:
/^(.+)\s(.+)\s(.+)\s\[(.+)\]\s"(.+)"\s(\d+)\s(.+)\s"(.+)"\s"(.+)"/
breaking them into its components:
ip
identd
user
time
request
result
size
referrer
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Gomme's Laws:
(1) A backscratcher will always find new itches.
(2) Time accelerates.
(3) The weather at home improves as soon as you go away.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Newbie challenge to brainiacs
I'm a PHP beginner and I am amazed at the help people give you in this
newsgroup. I'm trying to attempt something ambitious (for me anyway) and
I'm looking for help.
Here is a sample of my weblog that reads into an array from a file ie
$filename = ("combined_log");
$fcontents = file($filename);
203.29.154.13 - - [08/May/2002:21:21:07 +1000] "GET /A1.php HTTP/1.1" 200
417 "-
" "Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)"
203.29.154.13 - - [08/May/2002:21:21:10 +1000] "GET /A1.php HTTP/1.1" 200
417 "-
" "Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)"
203.29.154.13 - - [10/May/2002:20:10:11 +1000] "GET /A1.php HTTP/1.1" 200
417 "-
" "Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)"
203.29.154.13 - - [11/May/2002:19:15:12 +1000] "GET /A1.php HTTP/1.1" 200
417 "-
" "Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)"
203.29.154.13 - - [12/May/2002:15:21:13 +1000] "GET /A1.php HTTP/1.1" 200
417 "-
" "Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)"
I want to try to find the hour that has the most hits
The day of the week that has the most hits
and the max and ave no of hits of these.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
