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.

Beceriler: MySQL, Perl, PHP

Daha fazlasını görün: php access log, access log mysql php, php mysql access log, mysql questions, mysql data access, gif txt, daily access, access log php mysql, mysql data files, log time, project clarification board, php testing, php perl, php bot , nutch, mysql 4, log post, log files, data log, alter files, php script open file, php data table, mysql read files, duplicate table, 2010 access

İş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

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

nrifriends

Please check you PM.

1 gün içinde 50$ USD
(48 Değerlendirme)
6.9
eperfections

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

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

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

in 0 gün içinde55$ USD
(99 Değerlendirme)
6.6
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
(107 Değerlendirme)
6.3
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
wincent

easy & quick work, ready to start.

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

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

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

I can do this..

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

Plz check PM

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

It can be done :)

1 gün içinde 60$ USD
(27 Değerlendirme)
5.1
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
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
zenithsoftwares

Dear Sir, please check PMB Thank you

in 2 gün içinde75$ USD
(10 Değerlendirme)
4.5
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
(15 Değerlendirme)
4.1
amsak

Pls see PM

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

Hello sir.Please check PMB for details.

in 3 gün içinde60$ USD
(5 Değerlendirme)
3.3
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
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