Completato

Very simple PHP script to get data from an XML

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

[url removed, login to view]

---

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.

Competenze: PHP

Vedere di più: writing to get paid, php and mysql connection, eng writing need help, php, mysql, server status script php simple, data migration script php, simple data entry script php, poker xml script php, send data xml via php, update script php simple, data scraping script php, vba script convert xls data xml script, post data xml extjs php, data grabbing script php, capture data web script php, software write mq4, software write chip epson, useful software write book, software write web specs

Sul datore di lavoro:
( 13 valutazioni ) Oslo, Norway

ID Progetto: #11139115

Assegnato a:

Khushmahal

Hi I am a senior web designer or developer . Experience with php html5 css3 jquery Photoshop Expert in responsive on all mobile sizes Thanks

$15 USD in 1 giorno
(0 valutazioni)
0.0

22 freelance hanno fatto un'offerta media di $23 per questo lavoro

uhjk

Hello, If you award me, I can complete this in 1 hour or less. I'm online now and ready to start. Thank you :)

$25 USD in 1 giorno
(453 Recensioni)
7.8
TopSEOExpertscom

Hi, Here's my bid to get it done for you as a php script or as a JS code that you can run in your browser to get this output.

$35 USD in 1 giorno
(239 Recensioni)
7.9
mondersky

very easy job. I am ready to start on it right now! hit my inbox .

$25 USD in 1 giorno
(110 Recensioni)
6.3
bijaya47

Hello Sir Greetings of the day! I have gone through the project specification. I have prior experience with similar types of websites. I will use my skill to make you happy. I am a developer with 4 yrs of experi Più

$25 USD in 1 giorno
(80 Recensioni)
5.8
asifchaudhry2015

Hi ! there I can work for you Just read my profile reviews and check what say others about me I can finish your project within your deadline and budget with 100% of your satisfaction thanks

$25 USD in 1 giorno
(24 Recensioni)
5.4
Scorpio1987

I can give you the script right away. I have the script ready and i have tested and it's working. Please message me to discuss more details. If you can pay me outside i can do for $15 itself.

$20 USD in 1 giorno
(15 Recensioni)
4.5
jayshreeganeshha

hi,php developer here and i would like to work on your [login to view URL] go through my reviews and discuss with me.I hope you would like to hire [login to view URL]

$25 USD in 1 giorno
(11 Recensioni)
4.6
realYuR

Hello, I can make a script for you right now in some minutes, I have a very good experience in this field. Thank you.

$35 USD in 1 giorno
(8 Recensioni)
4.1
ishtiaqn2o

hello, we are Techlogicians we can do this task for you.. Thanks

$29 USD in 1 giorno
(4 Recensioni)
2.2
bikramkumar61633

Hi, I am having 6 years experience in web application development using variant frameworks. I have gone through your requirements. I would like to submit my proposal here. I have developed many information systems like Più

$25 USD in 1 giorno
(2 Recensioni)
1.8
djyakreb

I can do it easly. Writing curl systems like bots my job :) I wrote about 100 bots. Most of for Movie & Series websites. So I can help for your project. Send me a message.

$15 USD in 1 giorno
(1 Recensione)
2.2
iksc

Hi there, I've already got the script completed and I think at a fair price (took about 20 min with some testing). Best regards

$15 USD in 0 giorni
(2 Recensioni)
1.4
DevelopingGuru

Hi. For a professional developer like me who had developed multiple websites, this would be a very simple task as I have already developed A LOT of APIs. So I know howthings work and I would easily fix your issue in no Più

$25 USD in 1 giorno
(1 Recensione)
0.8
WebMediaPak

Dear Employer, I am ready to work on your required task and can also give 100% satisfaction. Looking forward to an opportunity to work with you. You can check my previous Reviews and Work: [login to view URL] Più

$25 USD in 1 giorno
(4 Recensioni)
0.8
gauravnikam

I have good experienced in web technologies .I already build this kind of project .So it is very simple task for me.

$19 USD in 1 giorno
(1 Recensione)
0.2
shiliwicem

Hello, Your PHP script will be ready in less than one hour after accepting Bid. enjoy :) you can contact me on skype also: wicemshili Sincerely Wicem

$14 USD in 1 giorno
(0 Recensioni)
0.0
ZeeStrike

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Lo Più

$25 USD in 1 giorno
(0 Recensioni)
0.0
quickviz

hello,many many greeting of the day! i have Analyse the project requirement and understood what are you want. i have 3 year experience in developing. i'll gave you 98% surety that i'll complete this work acco Più

$25 USD in 1 giorno
(0 Recensioni)
0.0
abelvedere

Hello, I have 20 years experience in web application development. I am keeping my bid low as I want to start building my reputation on freelancer.com.

$15 USD in 1 giorno
(0 Recensioni)
0.0
techcristaglobal

Hey, we would like to work with you. let's have detailed discussion. [login to view URL] [login to view URL] [login to view URL] Più

$25 USD in 1 giorno
(0 Recensioni)
0.0