Extract data from file and insert into MySQL database using PHP



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: Amazon Web Services, Game Consoles, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: mysql insert file, mysql database software, create mysql database using php, h game, php script create table, lua, lua programmer, insert, extract data, php script execute, rows insert, mysql stuff, database project php, script php extract data mysql, mysql create table data, insert mysql table, mysql show data insert, php execute rows, table extract, mysql containing, duplicate file, php mysql database query, cron mysql, simple php mysql task, software cron

Project ID: #3476579

Awarded to:


See private message.

$21.25 USD in 2 days
(47 Reviews)