MySQL insert from a textarea to multiple rows
<p>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. </p>

<p>HTML code:</p>

<pre><code>&lt;html&gt;
&lt;form method="POST" action="insert.php"&gt;
&lt;textarea name="url" rows="10" &gt;&lt;/textarea&gt;
&lt;input type="submit" name="submit" value="Enter"&gt;
&lt;/form&gt;
&lt;/html&gt;
</code></pre>

<p>PHP Code:</p>

<pre><code>&lt;?php
$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);
?&gt;
</code></pre>

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