Closed

Extract data from file and insert into MySQL database using PHP

This project was awarded to jsaman for $21.25 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$20 - $25 USD
Total Bids
1
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online