Devam Ediyor

PHP: Access log (text) to MySQL

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.

Operating Environment:

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]")

Special Requests:

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.

SAMPLE:

(

[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.

Beceriler: MySQL, Perl, PHP

Daha fazlasını görün: php access log, php mysql access log script, access log mysql php, php mysql access log, open text, open table com, Mysql questions, mysql data access, gif to txt, daily access, php mysql access log read, access log php mysql, mysql data files, log time, scan to text, project clarification board, php testing, php perl, php bot , Nutch, mysql 4, log post, log files, data log, alter files

İşveren Hakkında:
( 2 değerlendirme ) Nashua, United States

Proje NO: #701497

Seçilen:

LonnyK

Hi, I have 8 years of LAMP (Linux, Apache, MySQL, PHP) experience and 12 years of HTML/CSS/JS experience. Please check your PM.

0 gün içinde 50$ USD
(3 Değerlendirme)
1.8

26 freelancer bu iş için ortalamada 61$ teklif veriyor

eperfections

I have done similar jobs already and ready to do this one as well. Thanks

in 2 gün içinde50$ USD
(230 Değerlendirme)
7.2
kernelbd

We are highly interested, ready to start now. Thanks.

in 0 gün içinde55$ USD
(122 Değerlendirme)
7.1
Indispensable

Ready to do it. Please see your PMB. Thanks.

in 0 gün içinde50$ USD
(51 Değerlendirme)
6.2
gsala81

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.

1 gün içinde 50$ USD
(43 Değerlendirme)
6.4
kopila123

please view pm

in 2 gün içinde80$ USD
(108 Değerlendirme)
6.3
ranacseruet

I can do this..

in 5 gün içinde150$ USD
(37 Değerlendirme)
5.7
wincent

easy & quick work, ready to start.

in 0 gün içinde50$ USD
(80 Değerlendirme)
6.0
vsworx

We have a team of highly qualified and creative professionals. Give us a chance to show our talents and we assure you quality.

in 2 gün içinde65$ USD
(11 Değerlendirme)
6.2
starshine

It can be done :)

1 gün içinde 60$ USD
(28 Değerlendirme)
5.1
getndone

Plz check PM

in 5 gün içinde36$ USD
(42 Değerlendirme)
5.5
adinaluiza

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

1 gün içinde 80$ USD
(12 Değerlendirme)
4.7
PedroMC

Greetings. It is a simple PHP and MySQL project. I can provide you with quality work for your project. Escrow is required. Regards.

in 2 gün içinde30$ USD
(25 Değerlendirme)
4.6
alephiej

Hi. I can write you logfile parser in accordance with your requirements. Let me know if you're interested.

in 3 gün içinde90$ USD
(25 Değerlendirme)
4.8
zenithsoftwares

Dear Sir, please check PMB Thank you

in 2 gün içinde75$ USD
(10 Değerlendirme)
4.5
xristos678

Hello [url removed, login to view] check PMB for details.

in 3 gün içinde60$ USD
(15 Değerlendirme)
3.8
amsak

Pls see PM

in 5 gün içinde40$ USD
(10 Değerlendirme)
3.8
souvikbasu00

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

in 5 gün içinde100$ USD
(2 Değerlendirme)
3.1
ravenurse

Ready to start, ready to deliver.

1 gün içinde 30$ USD
(5 Değerlendirme)
3.2
vadimhl

I can do this work.

in 2 gün içinde50$ USD
(3 Değerlendirme)
3.2
bhonti

Hello! Have >10 years experience. ;-)

in 0 gün içinde55$ USD
(2 Değerlendirme)
2.0