mysql 文本域,MySQL从文本区域插入到多行

I have a simple form which is a textarea and I need to insert each lines in my textarea into a different rows in MySQL.

HTML code:

PHP Code:

$link = mysql_connect('localhost', 'root', '');

if (!$link) {

die('Not connected : ' . mysql_error());

}

$db_selected = mysql_select_db('insert', $link);

if (!$db_selected) {

die ('Can\'t use this database : ' . mysql_error());

}

$textarea = mysql_real_escape_string($_POST['url']);

$array = explode("\n", $textarea);

$i=0;

$value = trim($array[$i]);

if (!empty($value)) {

foreach ($array as $value) {

mysql_query("INSERT INTO test (text) VALUES ('{$array[$i]}')") or die(mysql_error());

$i++;

}

}

mysql_close($link);

?>

Currently I'll store textarea in ONE row when I submit my form. Could you please help me with that.

解决方案

Try this:

$text = trim($_POST['textareaname']);

$textAr = explode("\n", $text);

$textAr = array_filter($textAr, 'trim'); // remove any extra \r chars

foreach ($textAr as $line) {

// Your sql Query here with $line as the string.

}