Encerrado

PHP Website Visitor Logging and Reports enchancement

I currently have PHP script to log my visitor information.? I want to expand on it's features.? With better logging and reports.

## Deliverables

I currently have PHP script to log my visitor information. I want to expand on it's features. With better logging and reports.

I use $datetime = mktime(); to place a time stamp in my log files.

I use $referer = $_SERVER['HTTP_REFERER']; for referer I need code to separate the search engine refer from the keywords, and save them as two separate fields

I need this to work for msn, yahoo, google

This is what my log file looks like

$logline = $ipaddress . '|' . $referer . '|' . $datetime . '|' . $useragent . '|' .

$remotehost . '|' . $page . "\n";

I need a script to parse the data from the [url removed, login to view] into a MySQL database table.

This needs to parse the data from the log file into MySQL database table I want the following fields created from the log file.

UNIQUEKEYINDEX autoincrement, IPADDRESS, REFERRER, DATETIME, MONTH, YEAR, USERAGENT, REMOTEHOST, PAGE, KEYWORD, SEARCH ENGINE

This is how I want the data written to the MySQL database table.

I need the refer search engine for msn, yahoo, google broken down from the keyword used to search. So it would end up with a SEARCH ENGINE field, and KEYWORD field.

I need to make find all the unique combinations of referer and keywords.

Same page plus same keyword will be made into 1 entry on the report.

I then need the total number of unique visitors based on ip and host name for each 1 entry.

I need the search engines that refered the traffic and the percentage each one sent unique visitors for that page and keyword for each 1 entry.

I need the Month noted in a unique field.

I need the Year noted in a unique field.

I need each page url + keyword combination to only show up once.

I need a script to run a report for a certain month or year on the MySQL database table. When select a month the report script will go to the MySQL table and return data from that month only. When select a year the report script will go to the MySQL table and return data from that year only.

I need the report to be display in a certain order.

need the report sorted, but the page + keyword entries with the highest # of unique visitors first and the lowest last based on only the entries for that month or year that was selected when generating the report.

I hope this is easy to follow, I will quickly answer questions ask by coders in a broadcast message to all coders. I will quote the question and write my answer. This communication will be considered part of the project scope and required for completion. I will give you access to my hosting to work on the files for development you are only required to get the files working in the development area you will not be required to install a second time. I need the code for all work documented in the source code files for all lines. I will also need a MySQL file that creates the database table and fields with all proper data types.

## Platform

PHP

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website, XML

Veja mais: yahoo broken, write xml code website, write reports, website to find coders, types of data entry fields, source code php website, search engine ask question, referer url php, php refer url, php code for google search, i want to get project of website development, how to write reports, how to write a field report, how to get website visitors, how to get visitors to my website, how to find website coders, google plus one website, generating reports in php mysql, expand url, ask a question search engine

Acerca do Empregador:
( 32 comentários ) Ponte Vedra, United States

ID do Projeto: #3673322

15 freelancers estão ofertando em média $71 para esse trabalho

matttzuvw

See private message.

$85 USD in 14 dias
(160 Comentários)
6.2
emberke

See private message.

$85 USD in 14 dias
(134 Comentários)
6.2
s4234

See private message.

$72.25 USD in 14 dias
(151 Comentários)
6.0
liumy1985

See private message.

$63.75 USD in 14 dias
(151 Comentários)
5.6
wwwPHP

See private message.

$85 USD in 14 dias
(141 Comentários)
4.8
hasanur

See private message.

$63.75 USD in 14 dias
(25 Comentários)
4.8
eg624vw

See private message.

$51 USD in 14 dias
(10 Comentários)
4.1
blueoceanco

See private message.

$76.5 USD in 14 dias
(15 Comentários)
4.1
testenggsl

See private message.

$85 USD in 14 dias
(11 Comentários)
3.2
martonos

See private message.

$85 USD in 14 dias
(1 Comentário)
2.7
russellb

See private message.

$72.25 USD in 14 dias
(3 Comentários)
2.2
blackfirelx

See private message.

$42.5 USD in 14 dias
(8 Comentários)
1.9
vw7170326vw

See private message.

$68 USD in 14 dias
(5 Comentários)
0.2
earnestdev

See private message.

$63.75 USD in 14 dias
(2 Comentários)
0.0
smarttwo

See private message.

$85 USD in 14 dias
(0 Comentários)
0.0
junaidarifvw

See private message.

$68 USD in 14 dias
(0 Comentários)
2.5