This is a _very_ simple PHP project
I need help writing a PHP script that gets data from an URL and inserts it into a MYSQL table.
Somehow I'm not able to solve it myself, so I'm asking for paid help :-)
---
The API data are located at
[login to view URL]
---
The script should output a SQL insert, like this:
INSERT INTO Tides(Value,Time,Flag) values
('83.6','2016-07-30T03:03:00+01:00','low'),
('230.0','2016-07-30T08:55:00+01:00','high'),
('68.0','2016-07-30T15:29:00+01:00','low'),
('243.7','2016-07-30T21:41:00+01:00','high'),
('70.9','2016-07-31T04:10:00+01:00','low'),
('237.9','2016-07-31T10:05:00+01:00','high'),
('61.6','2016-07-31T16:29:00+01:00','low'),
('257.9','2016-07-31T22:38:00+01:00','high'),
('56.3','2016-08-01T05:07:00+01:00','low'),
('248.5','2016-08-01T11:03:00+01:00','high'),
('54.6','2016-08-01T17:21:00+01:00','low'),
('271.1','2016-08-01T23:28:00+01:00','high'),
('43.6','2016-08-02T05:57:00+01:00','low'),
('257.9','2016-08-02T11:53:00+01:00','high'),
('49.4','2016-08-02T18:07:00+01:00','low'),
('281.0','2016-08-03T00:12:00+01:00','high'),
('35.2','2016-08-03T06:41:00+01:00','low'),
('264.0','2016-08-03T12:39:00+01:00','high'),
('47.1','2016-08-03T18:48:00+01:00','low'),
('286.2','2016-08-04T00:53:00+01:00','high'),
('32.1','2016-08-04T07:21:00+01:00','low'),
('265.9','2016-08-04T13:20:00+01:00','high'),
('48.3','2016-08-04T19:25:00+01:00','low'),
('286.3','2016-08-05T01:33:00+01:00','high'),
('34.4','2016-08-05T07:59:00+01:00','low'),
('263.5','2016-08-05T14:00:00+01:00','high'),
('53.1','2016-08-05T20:00:00+01:00','low'),
('281.3','2016-08-06T02:11:00+01:00','high'),
('41.1','2016-08-06T08:35:00+01:00','low'),
('257.4','2016-08-06T14:38:00+01:00','high'),
('60.9','2016-08-06T20:35:00+01:00','low'),
('271.9','2016-08-07T02:48:00+01:00','high'),
('51.1','2016-08-07T09:10:00+01:00','low'),
('248.4','2016-08-07T15:16:00+01:00','high'),
('71.5','2016-08-07T21:10:00+01:00','low'),
('259.2','2016-08-08T03:25:00+01:00','high'),
('62.9','2016-08-08T09:46:00+01:00','low'),
('237.7','2016-08-08T15:54:00+01:00','high'),
('83.9','2016-08-08T21:49:00+01:00','low'),
('244.3','2016-08-09T04:03:00+01:00','high'),
('75.4','2016-08-09T10:25:00+01:00','low'),
('226.5','2016-08-09T16:35:00+01:00','high'),
('97.1','2016-08-09T22:33:00+01:00','low');
---
You don't need to change any of the parameters in the URL.
You don't need to do the actual mysql connection, if the script just echoes the insert (as shown above), I can do the rest.