I gang

Interactive Chart for PHP Mysql Query

I have a website link tracking table that has the following fields:

id,link_id,hit_timestampt,deleted,ip,ref,agent,track_page,domain

I would like a query to report back link_id, number of total hits, number of uniqe hits, browser types(counts). The report would by usual table output, but each line should have a link to produce a detailed report and graph.

The report should be an output to csv or excel with all of the data, and the graph should be a pop-up timeline that can be customized in real-time (with a calendar parameter for timeline AND a interval (minute, hour, day, week, month, etc).

If you look at google analytics, you'll understand what type of chart I'd like.

Thanks!

Also, in a similar table, I'll have a list of phone numbers. I would like to compute the number within each area code and plot them onto a USA chart? I believe googleapi has this chart in their inventory. Please add that to the project.

Færdigheder: Javascript, MySQL, PHP, PSD to HTML

Se mere: timeline php mysql, look php id, id analytics, graph data type, data for graph, data for a graph, line graph excel, real time graph, mysql query, excel analytics, interactive php mysql, mysql calendar table, customized report excel, excelchart, interactive javascript table, google query, interactive excel, report chart, php table csv, query pop, table month php, php interactive line, mysql excel query, javascript line chart, chart line

Om arbejdsgiveren:
( 13 bedømmelser ) Wilmington, United States

Projekt-ID: #4053090