 | MEMBER LOGIN |
|
|
 |
|
 | SERVICES & FEATURES |
|
|
 |
|
 | THE 20 LATEST PROJECTS |
 | POPULAR NEW PROJECTS |
|
|
Project: XML to MySQL (PHP script)  ID: 1258899778 |
|
 |  |  |
 |
| |
|
Status: |
Closed (Chosen Programmer: egg; Paid; Rated 10 out of 10)
|
|
Budget: |
$10-20
|
|
Created: |
11/22/2009 at 9:22 EST
|
|
Closed: |
11/23/2009 at 14:35 EST
|
|
Project Creator: |
|
|
Description: |
Exchange Rates given buy bank in XML Format online:
www.bank.lv/eng/main/all/finfo/notvalkur/erbl_inxml/
I need 2 PHP simple scripts that parce & extract
- Date
- ID
- Units
- Rate
and insert data into existing MySQL table:
CREATE TABLE "currency" (
"date" DATE,
"id" CHAR(3),
"units" INTEGER,
"rate" NUMERIC(12,8),
PRIMARY KEY ("date", "id")
1. First script - extract and insert data into MySQL table according to defined period between 2 dates (will be used to fill table with past data).
2. Second script - extract and insert data into MySQL table only for current day (will be used as daily cron job).
You can create one script for both cases if you like, give me only editing instructions in order to achieve both tasks.
XML file source is attached in PDF.
|
|
Job Type: |
|
| |
 |
|
Messages Posted: 33 |
| |