Closed

Work with Mysql and php

This project received 39 bids from talented freelancers with an average bid price of $146 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
39
Project Description

work is with php and mysql.
I need queries and php code to run them.
Also i have few questions about sql tables i want to ask during project.

i want person who communicate well and can suggest his offers if he see it can be done better or easier then i described.

it should be written easy and simple.

This is small project i am hopping small bids.

So i have 3 tables in database:

table name ( columns in table)
accesspoints (wifimac ,signals, lat, lon)
usersdata (PhoneIMEI, wifimac, signals, lat, lon, timestamp)
locations (PhoneIMEI, wifimac, signals, lat, lon, timestamp)

accesspoints and locations tables are where data will be stored from queries.
usersdata is table where data is comming from system users.

Query1:
insert data to locations table by using data from usersdata and accesspoints tables.
3.1 there can be multiple rows with same PhoneIMEI but different others columns values in usersdata.
3.2 first i need to take wifimac from usersdata table and check if there is same wifimac in accesspoints then from those who match choose only one with highest signal.
3.3 this should be done for every PhoneIMEI
3.4 this should be done from latest data from timestamp for every PhoneIMEI (time from timestamp should be taken in minutes not seconds)
3.5 then data should be sent to locations table ([url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view])

I need php fields where you can insert wifimac address and select time interval. and it shows results on screen from query2.
Query2:
4.1 i need to count how many different PhoneIMEI from usersdata table had wifimac that was inserted during selected time interval.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online