Importing Txt files into a database

[BoneHunter9]

First,im a kinda noob with mysql,i know some basics,not more.

Thats the reason for my following question:

 

I have a giant .txt file with many user datas in,but now i need all these datas in a sql database.

The database contains a table called "Plots" with the following rows: idx ; idz ; owner ; topX ; topZ

So the format of the datas in the txt file is that:

 

 

        max: {x: 127.0, y: 200.0, z: 208.0}

            user: [maximini97]

 

I marked with colors wich data has to be in what row.

The row idx and idz just has to be continued in that style: -1;-2 etc

 

I have about 2000 datas to put in,and doing this by hand would be a fulltime job.

So i need a sql command or a script for this.

I would be very happy when someone can help me with this

 

Greetings

Bone

[Jessica]

You'll need to write a script using something like PHP. If you need someone to do it for you, post in Freelance.

[BoneHunter9]

I figured out that i need a script,so i hoped to find someone here who can help me out with that.

And this needs only to do 1 time,after that i dont need the txt file anymore :S 

So setting up a freelance announcement is mabye to mutch 

Edited April 5, 2013 by BoneHunter9

[Jessica]

We will help you with code YOU write, or you can hire someone to do it for you.

 

What have you done so far? Cause so far you're saying "help me out" but it's looking like "do it for me".

Edited April 5, 2013 by Jessica

[BoneHunter9]

"do it for me".

 

I said im a sql noob,im more into server management than scripting.

So it is more a script request than a help request.

[Jessica]

If you need someone to do it for you, post in Freelance.

[Christian F.]

If you want to have a crack at this yourself, then you need to read up on a bit of stuff.

 

Firstly, start with basic PHP syntax, if you haven't done so already. Then, move on to the next chapters of the PHP manual, skipping the installation one (as PHP is installed already).

I recommend reading everything up to the function reference, which you'll be using as a... Well, reference, later on.

 

Once you've done that, you'll want to find a MySQL + PHP tutorial, which there are many of. Just take care to preferably find one that is using MySQLI or PDO, since the others are out of date by now. Follow it, to get a basic understand of how SQL works.

Also, remember to read up on SQL injections, and how to protect you against them. Hint: Prepared statements.

 

The next step is to read up on JSON, and how to decode JSON in PHP. Along with reading files, and that should be all of the basic functionality you need.

 

Good luck!

Edited April 5, 2013 by Christian F.