writing the contents of an array into database

gentlegiant

Hi all, first post here - thanks in advance for any help offered ...

I'm trying to create a very basic organizer script using PHP and MySQL. The user uploads a tab-delimited text file which contains three columns. I use file() to read the contents of the text file into an array.

Now, I'm stumped ... how do I write the contents of that array into the database? I've preconfigured the database so that it has three fields to match the three that will be in the text file, plus a numerical key field (with auto_increment set to true). I'm just beginning to wrap my head around the way PHP works with arrays ... very different from other languages. Can anyone offer some guidance?

Best,
GG

drawmack

Step 1) Loop through your array ([man]foreach[/man]).
#Inside loop
Step 2) Get the newline character off the end of the elements ([man]trim[/man]).
Step 3) Create a new array out of the element ([man]explode[/man]).
Step 4) Insert the array of elements into the database. ([man]mysql_query[/man]).
#End the loop here

gentlegiant

Originally posted by drawmack
Step 1) Loop through your array ([man]foreach[/man]).
#Inside loop
Step 2) Get the newline character off the end of the elements ([man]trim[/man]).
Step 3) Create a new array out of the element ([man]explode[/man]).
Step 4) Insert the array of elements into the database. ([man]mysql_query[/man]).
#End the loop here

Thanks drawmack,

Tell me, do I need to tell it to skip the auto_increment field? Or are fields with that attribute skipped automatically?

(I don't think I can leave that field out, because none of the other fields will have unique contents)

Best,
GG

drawmack

if you have an auto_increment field you should not specify that field in the inserts, the dbms will do that for you.