[RESOLVED] Using arrays to generate fieldl names in MySql INSERT

edziffel

Me: self taught, not a ton of exp with php or mysql

Situation:
Uploading CSV files to insert into pre-existing database tables using a web based interface.
Have placed into arrays all rows of CSV and can access individual elements
Have placed into variable database name from server
Have placed into variable database table selected from selected database
Have placed into an array field names for a given table.

All is dandy up until that point.

I am lost at the point of how to convert from the field name array into (field1, field2, ..., field"n") in the insert statement. How do I use an array to generate my field names in SQL friendly way?

Here is the code that works for the INSERT statement using a variable for the table name using a small table created for testing.

<?php
$query1=("INSERT INTO $dbtableselected (Shoes,Sandels,Socks) VALUES ('mud','crud','bud')");
mysql_query($query1) or die(mysql_error());

echo "data Inserted";

?>

How do I get from the $fieldnames array, which in this case holds
Array ( [0] => TesterTblId [1] => Shoes [2] => Sandels [3] => Socks )
to Shoes,Sandels,Socks so that it can be used dynamically to do the insert?

Derokorian

$array = array_slice($array,1);
$field_list = implode(',',$array);

HTH

edziffel

Derokorian,

Short, sweet and simple. Works like a really cold beer on a really hot day! Thank you very much.

Derokorian

Also note, the only reason I did array slice, is because you had an extraneous value at the beginning of your array, that you didn't specify as needed included =D

Still, glad I could help =D

edziffel

No worries,

I got that when I looked up the functions in the php manual. Also checked out explode and a few others, so it's all good. :-)

But...

I have some really big files to upload. Looks like using LOAD DATA INFILE will be the way to go, which is giving me another beating. Going to make a new post. Maybe you could take a look if you have a couple of extra minutes to baby sit. lol.