Multiple get requests to mysql table

$30-250 CAD

Завершено

Опублікований

over 9 years ago

$30-250 CAD

Оплачується при отриманні

I have a remote data logger that sends 3 seperate post requests to 3 seperate php files and currently they insert into there own mysql table with a unique timestamp (makes a join request a pain) I need a way to insert the values into the same table under the same row even though the post interval is off by a few seconds. perhaps it can be done on the mysql side or the php side? I have included the current php insert files Happy bidding

MySQL

PHP

ID проекту: 6886096

Про проект

6 пропозицій(-ї)

Дистанційний проект

Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@renandocarmo

Hello... We can think in a PHP solution to this... Maybe the requests may be stored in the session... and when reques #3 comes.. then save in DB

$50 CAD за 1 день

5,0

(45 відгуки(-ів))

5,3

6 фрілансерів(-и) готові виконати цю роботу у середньому за $126 CAD

@mistersoft

If you can post some unique identifier such as local timestamp with all other data to this script - I will do rest in your script.

$150 CAD за 3 дні(-в)

5,0

(484 відгуки(-ів))

7,9

@mtavartkiladze

A proposal has not yet been provided

$147 CAD за 1 день

5,0

(94 відгуки(-ів))

6,9

@optimizmo

Hello, do you have a way to define that each of these logging queries belong to the same "packet". We can setup a flag field which will hold boolean value indicating that the row is "closed". The row will remain open untill the third packet arrives, after which it will be closed. When data comes, if any row is open, it will be added to that row rather than inserted to a new row. This can be done by means of php and minor modification of your db (adding a field). Can do this for you. If interested, feel free to contact me. Regards, Alexander

$80 CAD за 1 день

5,0

(31 відгуки(-ів))

5,9

@sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards

$194 CAD за 3 дні(-в)