Require PHP script to read and parse log files, then post data to MySQL table.
//Sample log attached.
MySQL Table headers are to be setup as IP | DATE | TIME | ACTION | FILE
Script must populate table columns from entries in .log file. Script must ONLY post requests for .gif files located in a specified folder.
A new log file is generated daily. More than one log file may exist for each day. Script should open and log each .log file in the log folder.
Ex. filename ("[url removed, login to view]")
MySQL access (password etc.) to be stored as variable in script.
This script is run manually, daily. Script must NOT alter the log file in any way.
Script must NOT post duplicate entries.
(Must check to see if EXACT access entry exists in MySQL table before posting.)
Well commented code is appreciated.
[url removed, login to view] - - [23/May/2010:19:14:56 -0700] "GET [url removed, login to view] HTTP/1.0" 200 304 "-" "research-scan-bot/Nutch-1.0"
[url removed, login to view] - - [23/May/2010:19:14:59 -0700] "GET [url removed, login to view] HTTP/1.0" 200 3303 "-" "research-scan-bot/Nutch-1.0"
MySQL information and folder locations will be entrusted to the winning bidder.
Payment given upon successful 24hr testing of script.
Please use the Project Clarification Board of this posting ONLY for questions regarding the posting.
Table header update!
The tables headers are IP | DATE | TIME | ACTION | PATH | FILE
I had left out the PATH header in the original posting. I apologize for any inconvenience.
26 freelancers are bidding on average $61 for this job
Hello, 10+ years exp freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.
Hello, I have 3+ years experience in PHP programming and MySql and I would like to work on this project. I have done this kind of work before. Regards, Adina
Hi, I can do this job for you.. This is very much possible to do in perl and easy to maintain. if given a chance I can do this in perl for you regards SouvikB