In Progress

Daily Data PHP script/MySQL database

Looking to have a basic PHP script written that can be used in different projects.

I want to collect data from my own site on a specified time basis (daily, weekly, etc) and have it stored in a database.

Here are the fields:

URL (will be unique)

Website name (mostly unique, though not in all cases)

URL related number (not unique, grabbed from my website)

Daily Increase/Decrease (raw number and percentage)

Weekly Increase/Decrease (raw number and percentage)

Monthly Increase/Decrease (raw number and percentage)

What I need from the script:

- That it grabs the URL related number once a day (I will provide the PHP script for this that returns the number), saves it to the database along with the date

- That it calculates the daily increase or decrease, saves the raw number to the database, calculates the percentage change for display

- That it saves the 5 days with the greatest numerical increase

- That it totals the daily numbers for a weekly and monthly count, saves the raw numbers to the database, calculates the percentage change for display

- Overwrites or deletes the daily numbers after a month so that the database doesn't get too large

I will need to be able to display the various information (raw numbers, percentage changes), and specify HTML to precede and follow the data (so that they can be displayed in a table, in a list, etc). I should be able to display information for one URL, or multiple URLs.

If you are interested in this project, include a message that specifies how you would structure the table(s) for maximum speed/efficiency. This doesn't have to be long or detailed, just how many tables you would create and why. If you think 2 tables with a join would be best, say why. If you think one table with a select statement is best, say why.

***Bids that don't include a note about how you would structure the database table(s) will not be considered.***

If this works well, I'll very likely want ongoing work on the script to deal with more data, and additional projects.

There is no design/visual/creative aspect to this project.

Skills: MySQL, PHP

See more: daily data php mysql, want create database, tables data structure, table data structure, speed date script, php visual design, one deal day script, list data structure, get php projects work, get php projects, design data structure, data structure note, data structure list, data structure design, best data structure, creative display, best php script, php script create table, mysql database design, deal speed, data visual, data tables, daily data, daily bids, basic php

About the Employer:
( 11 reviews ) Las Vegas, United States

Project ID: #1246988

Awarded to:

johnangel1992

I'm interested. The details of my implementation are included in the PMB I've sent you.

$30 USD in 2 days
(4 Reviews)
3.3

5 freelancers are bidding on average $94 for this job

srinichal

i look forward to deliver the same

$150 USD in 4 days
(102 Reviews)
7.2
stefanache

Hello again, Please see PMB. Thanks.

$100 USD in 5 days
(15 Reviews)
5.0
farrukhp

hi i have read the requirements and i am interested to do the job. kindly check pmb for the details that you asked for. thanks. farrukh

$100 USD in 5 days
(31 Reviews)
4.9
venidurai

We are interested to develop the new projects using the technology of PHP, mysql, Jquery, Javascript, Html, CSS, xml, Ajax and we completed the project within the limited period and we are mainly concentrate to devel More

$90 USD in 5 days
(1 Review)
1.6