$textareaSubmit = $_POST['textAreaValue'];
//First of all strip all the returns \r
$textareaSubmit = str_replace("\r", "",$textareaSubmit);
//Explode by new line
$inserts = explode("\n", $textareaSubmit);
//check if its array
if(is_array($inserts)){
//run foreach on array
foreach($inserts AS $insertSQL){
$check = false;
$check = mysql_query('INSERT INTO somewhere (`somecolumn`)
VALUES (\''.$insertSQL.'\')');
if($check === true){
//success
}else{
//failure
//do something?
}
}
}
bedul wrote:
$temp = str_replace("\n","[break]",$inpText); //inpText is from textArea
and then u enter your temp to the sql..
when you want to split it up.. just use
$temp=explode("[break]",$inp4Sql); //hope i don't give wrong function
==spam?? sory===
----- Original Message -----
From: "Bill Bolte" <billb@xxxxxxxxxxxxxxxx>
To: <php-windows@xxxxxxxxxxxxx>
Sent: Friday, May 18, 2007 4:22 AM
Subject: RE: Textarea and mysql
Split the data on a line break maybe? First thing that comes into my
head...
-----Original Message-----
From: Moore, Joshua [mailto:Joshua.Moore@xxxxxxxxx]
Sent: Thursday, May 17, 2007 4:17 PM
To: php-windows@xxxxxxxxxxxxx
Subject: Textarea and mysql
Hello,
Im currently having a bit of an issue with putting user info from a
textarea
into mysql db with php. With the textarea I need each new line to be a
separate entry into the db fields. So I guess the end result is making
the
textarea act like a regular text html form. The reason I am using
textarea is
because I want a user to paste in a long string of numbers
Ex:
11111111
22222222
33333333
...and so on
And each will end up in the same field just different entries.
Does anyone have any idea how I can accomplish this?
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
