PHP newbie question

[fireorange]

I'm searching for the code to batch import stuff into a MySQL db, can't find shit.

Example:

abc
zyx
qwe
asd

Each on a seperate line, from a HTML form submit.

Any help?

[ddfGandalf]

Dunno really what you need, but you could use $HTTP_POST_VARS or $HTTP_GET_VARS depending on your form action, then process the array (while) and simple INSERT into db?

[Serge Litehead]

batch import: http://sunsite.mff.cuni.cz/MIRRORS/f...atch_mode.html

the example is not clear in regards to mysql subject

[MickeyG]

if its a html submit use a loop, otherwise you can use a txt file and then import into mysql.

[fireorange]

if its a html submit use a loop, otherwise you can use a txt file and then import into mysql.

Yea that's what I want but I can't find any sample code on Google to use.

[psili]

something like:

$txt_array = file('/path/to/file.txt');
$db = ....connect to db

for($i=0;$i<count($txt_array);$i++)
{
  $sql = "insert into something where
}

...

FUCK THAT...

Can't you just format your text file like how the table is formatted and run something like:

>load data infile .....

-- search good for "load data in file" -- that'd be the fastest and easiest if possible.