I currently have PHP script to log my visitor information.? I want to expand on it's features.? With better logging and reports.
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.