textarea tab deliminated for database insert

[nagasea]

How to insert tab deliminated value from textarea form to database table ?
1 row 1 hallo
2 row 2 this
3 row 3 is

<form action=?act=execute method=post>
<textarea name=sql style=font-family:verdana;font-size:10px;width=550;height:300;></textarea>
<input type=submit name=submit value=go>
</form>

after user hit "GO"

can I use fgetcsv ?

[andrewtayloruk]

Try this, untested and I've never done this before so YMMV. Not exactly sure why you want to put multiple records in to a textarea but hey-ho:

if(!empty($_POST['sql'])) {

$ta = $_POST['sql'];
$linesArray = explode("\n", $ta);

foreach($linesArray AS $value) {
$tmpArray = explode("\t", $value);
print_r($tmpArray);
}
}

If you're going to insert this into a DB, make sure you properly understand SQL injection.

Andrew