Work with Mysql and php

Cancelled

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.

Skills: PHP, SQL

See more: work mysql php, simple php mysql, work values, Signal and system, mysql and sql, sql multiple questions, mysql multiple insert, php select insert sql, php insert select, mysql inserted, insert mysql table, lat address php, mysql tables rows, address match php, small php sql project, simple small project php, small project php sql, mysql database php code, multiple questions sql, php mysql small project table, php simple project insert, sql work, simple project insert php, insert data database mysql, mysql queries using

About the Employer:
( 2 reviews ) alytus, Lithuania

Project ID: #4537535

36 freelancers are bidding on average $146 for this job

kabirchy

HI, I can help you develop this script in PHP with MySQL. best quality assured. Thanks

$144 USD in 3 days
(734 Reviews)
8.1
vux3m

Hello, please check my PM.

$55 USD in 3 days
(58 Reviews)
7.1
hoangvandungbk

nice to help you

$105 USD in 3 days
(245 Reviews)
6.6
kssoftphp

I am ready and expert in Website Design and Development.

$147 USD in 5 days
(47 Reviews)
6.6
oneclickdevelop

Dear Sir or Madam: Thank you for giving us opportunity to submit our proposal for your project. Our company have good team of people which includes: Project Manager, Web Developer, Web Designer, Q/A and Testing sta More

$257 USD in 7 days
(99 Reviews)
6.5
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ More

$309 USD in 5 days
(71 Reviews)
6.0
mauryacravings

Hello, I have 8 years of extensive experience in Web Application Development. Recently, I have added mobile development expertise in my portfolio which allows me to play dynamic role as per requirement. Following are More

$123 USD in 3 days
(15 Reviews)
5.6
phpprogramming

please check PM for details

$122 USD in 5 days
(46 Reviews)
5.7
AlGordo

Experienced PHP and MySQL developer

$60 USD in 3 days
(23 Reviews)
5.6
AdamsK

Ready for service sir, thanks.

$66 USD in 3 days
(65 Reviews)
5.5
priyankjini

Hello Sir, Please check PMB. Thanks.

$115 USD in 3 days
(20 Reviews)
5.4
bigdognec

Lets get this started :)

$70 USD in 3 days
(66 Reviews)
5.3
ambalaonline1

Kindly check pmb

$210 USD in 10 days
(27 Reviews)
5.2
honeypotant

I am ready for you. Please check PM. Thanks.

$257 USD in 3 days
(21 Reviews)
5.1
phpmysqlrocks

Ready to start Now. Thanks

$115 USD in 2 days
(20 Reviews)
4.9
farhaoui

hello, I can complete your project in three easily. thank you

$66 USD in 3 days
(39 Reviews)
4.8
pixecs

Hello sir, i have over 7 years of experience in database programming - mySQL / MsSQL / Firebird.

$35 USD in 3 days
(28 Reviews)
4.8
webprof2

Let's Start. Please Check PMB for more details.

$64 USD in 3 days
(33 Reviews)
4.8
techdoo

expert here

$206 USD in 10 days
(5 Reviews)
4.5
code827562

Hi, would like to help you on this one! Thanks! Cheers!

$222 USD in 3 days
(17 Reviews)
4.3