Inserting multiple rows

Hi all,

I want to get a textarea form and add each new line to a database as a seperate row. Does anyone know how to do this in PHP?

I really haven't a clue where to start :(

Thanks,
Mike

You can do that with the explode() function.

PHP Code:

---

$line = explode ("\n", $foo); 


---

Where $foo is the name of your textarea. $line would be an array, then you can handle the array however you want.

PHP Code:

---

     foreach($line as $x) {
     echo $x;
} 


---

That would echo out each line. Or you can do your insert from there.

You would get ur textarea text by:

PHP Code:

---

    $textarea_text = $_POST['textarea_name']; 


---

Then as mobeilebadboy suggested, but could do:

PHP Code:

---

foreach($line as $x) {
     $sql="INSERT INTO table (text) VALUES ('$x')";
     $outcome = mysql_query($sql);
} 


---

I'll try it out later, thanks guys :) Thought it would be more complicated then that.