Multiple Row Inserst from Multiple Line Textbox

I've been search for some help with this because I know someone has done it before.

I'm trying to have a textbox and insert into a table one entry from each line of the textbox.

So if the textbox contained:

This info
That info

It would insert into the table

|1|This info|

Assume $text contains the text from the form's textarea element:

$lines = preg_split('/[\r\n]+/', trim($text));
foreach($lines as $line)
{
   // do query with text in $line
}