Re: Textarea and mysql

$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@hightouchinc.com> To: <php-windows@lists.php.net> Sent: Friday, May 18, 2007 4:22 AM Subject: RE: [PHP-WIN] 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@tusd1.org] Sent: Thursday, May 17, 2007 4:17 PM To: php-windows@lists.php.net Subject: [PHP-WIN] 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