Find Jobs
Hire Freelancers

266619 Tiny PHP MySQL Scipt

N/A

Completed
Posted over 15 years ago

N/A

Paid on delivery
We need a very simple php script that will query an existing MySQL db based on our date search parameters and display a couple of columns with the results for each date. More specifically, we want a page that will display a couple of data fields for each calendar date within the specified input range. The data in the db is in unix time, however the input and the display needs to be in human readable time. We will provide the specific search parameters to the programmer. Each of the two calculations is just a statistical count based on the activity for each day. One is a straight count of new records for each calendar day, and the other is a count of records for each calendar date which also meet an additional criteria. When we load the php page, it should simply show a three-column table with all dates for the current month thus far, with each of the two calculations shown. Something like this (I'll tell you the labels later): Date XXX XXX 11/01/08 121 283 11/02/08 139 347 11/03/08 146 389 etc. Totals: xxx xxx There should also be input fields in case we want to use a custom date range instead. We're going to copy and paste this information into a google docs spreadsheet on a regular basis, so if you know how to automate getting the data we need from MySQL into google docs, then we could go that route as well. We believe this is a very simple script that will not take long to create, and we plan to pick a programmer right away to get started. Currently we're just doing these searches via phpmyadmin, so we want to make this easier. Please PM with any questions.
Project ID: 2012897

About the project

1 proposal
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Have throughly read your requirments and can write this in about a hour. I'll need search parameters/criteries, probably sample of DB structure.
$15 USD in 1 day
5.0 (6 reviews)
2.1
2.1

About the client

Flag of UNITED STATES
Franklin, United States
5.0
18
Member since May 29, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.