PHP newbie question - GoFuckYourself.com

fireorange · 05-31-2005, 05:47 AM

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 · 05-31-2005, 06:03 AM

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 · 05-31-2005, 06:09 AM

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

the example is not clear in regards to mysql subject

MickeyG · 05-31-2005, 06:20 AM

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

fireorange · 05-31-2005, 06:27 AM

Quote:

Originally Posted by MickeyG

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 · 05-31-2005, 07:01 AM

something like:

Code:

$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.

05-31-2005, 05:47 AM	#1
fireorange Confirmed User Join Date: Jan 2005 Posts: 1,648	PHP newbie question 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?

05-31-2005, 06:03 AM	#2
ddfGandalf Confirmed User Join Date: Feb 2005 Location: Budapest, Hungary Posts: 534	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? __________________

05-31-2005, 06:09 AM	#3
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	batch import: http://sunsite.mff.cuni.cz/MIRRORS/f...atch_mode.html the example is not clear in regards to mysql subject __________________ SilverCrocodile.com Adult web design since '05

05-31-2005, 07:01 AM	#6
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	something like: Code: $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. __________________ Your post count means nothing.

05-31-2005, 06:20 AM	#4
MickeyG Confirmed User Join Date: May 2004 Location: South Florida Posts: 4,134	if its a html submit use a loop, otherwise you can use a txt file and then import into mysql.