Extract data from file and insert into MySQL database using PHP

IN PROGRESS
Bids
1
Avg Bid (USD)
$21
Project Budget (USD)
$20 - $25

Project Description:
I need a PHP script to extract data from a file and insert it into a MySql Database.

See below for full description of the project.

## Deliverables

I have a lua file generated by an addon for the game World of Warcraft containing data from my auctions inside the game.



I need a php script that I will run as a cron task that will extract and insert relavent data into a mysql database.

So for example I want to add the completed auctions to the mysql db. That data is stored in the lua file as:


["completedAuctions"] = {
["52329"] = {
["item:52329:0:0:0:0:0:0:1131205632:80:0"] = {
"20;1136906;2625;59699;1193980;1193980;Peppersue;1311953168;;H", -- [1]
},
["item:52329:0:0:0:0:0:0:1470346304:80:0"] = {
"20;1095581;2625;57524;1150480;1150480;Gavonsnight;1311971961;;H", -- [1]
"20;1095581;2625;57524;1150480;1150480;Gavonsnight;1311972013;;H", -- [2]
"20;1095581;2625;57524;1150480;1150480;Gavonsnight;1311971952;;H", -- [3]


You would create a script that would execute a query to insert each line into the table completedAuctions.

INSERT INTO completedAuctions VALUES ('52329', '20', '1095581', '2625', '57524', '1150480', '1150480', 'Gavonsnight', '1311971961', '', 'H');

The colors show where the data comes from etc..

Something similar to that.. And of course not to enter duplicate rows.

Simple stuff for a moderately skilled PHP programmer.

Skills required:
Amazon Web Services, Game Consoles, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 21.25
in 2 days