RE: Textarea and mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Please forgive me im still new to programming and php. So this is what I got
from what you said however I guess I managed to screw the whole code up
because it doesn't work at all anymore :(

$textareaSubmit = $_POST['cpu_asset'];
$textarea2Submit = $_POST['cpu_serial'];
$textareaSubmit = str_replace("\r", "",$textareaSubmit); //First of all strip
all the returns \r
$textarea2Submit = str_replace("\r", "",$textarea2Submit); //First of all
strip all the returns \r
$inserts = explode("\n", $textareaSubmit, $textarea2Submit);  //Explode by
new line
				if(is_array($inserts)){ //check if its array
					//run foreach on array
					for($i = 0; $i < count($inserts);
$i++){
					$check = false;
					$check = mysql_query('INSERT INTO
labels (`asset`,`serial`) VALUES (\''.$inserts[$i].'\',
\''.$textarea2Submit[$i].'\')');
	if($check === true){
		echo "Done";
		}else{
		echo "An error occured during printing. \n Reason:\n Failed
to insert data into mysql";
						        }
							}
						}

Im sure one of the problem area(s) is 

$check = mysql_query('INSERT INTO labels (`asset`,`serial`) VALUES
(\''.$inserts[$i].'\', \''.$textarea2Submit[$i].'\')');

However im not sure what the variable $textarea2Submit[$i] is supposted to
be. Do I need to create a whole other if(is_array($inserts)){ ??

Thanks for your help


-----Original Message-----
From: muadib@xxxxxxxxxxxxx [mailto:muadib@xxxxxxxxxxxxx] 
Sent: Friday, May 18, 2007 11:11 AM
To: Moore, Joshua
Cc: bedul; Bill Bolte; php-windows@xxxxxxxxxxxxx
Subject: RE:  Textarea and mysql

if the $check returns a "false" it would mean that there was an error  
in your SQL statement. The error might be here:

- > (`asset, serial`)

I doubt you have a column named `asset, serial`

Secondly if you are inserting two values into the SQL then they must  
be separated with a comma (,).

- > VALUES (\'value1\', \'value2\')

Thirdly :) if you are sure these two texareas are "in sync" you might  
wanna try to do the following:

for($i = 0; $i < count($inserts); $i++){
...
'INSERT INTO somewhere (`col1`,`col2`) VALUES (\''.$inserts[$i].'\',  
\''.$otherSyncedArrfay[$i].'\')'
...
}

Hope I was clear enough :)

Aleksander

Quoting "Moore, Joshua" <Joshua.Moore@xxxxxxxxx>:

> I have two textareas that I need to insert into 2 different fields, so with
> the following code im having trouble getting it to work:
>
> Original:
> $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?
>         }
>     }
> }
>
> Mine:
>
> $textareaSubmit = $_POST['cpu_asset'];
> $textarea2Submit = $_POST['cpu_serial'];
> $textareaSubmit = str_replace("\r", "",$textareaSubmit,$textarea2Submit);
> //First of all strip all the returns \r
> $inserts = explode("\n", $textareaSubmit, $textarea2Submit);  //Explode by
> new line
> if(is_array($inserts)){ //check if its array
>  //run foreach on array
> foreach($inserts AS $insertSQL){
> 	$check = false;
> 	$check = mysql_query('INSERT INTO labels (`asset, serial`) VALUES
> (\''.$insertSQL.'\')');
> 	if($check === true){
> 	echo "Done";
> 	}else{
> 	echo "An error occured during printing. \n Reason:\n Failed to insert
> data into mysql";
> 				        }
> 				    }
> 				}
>
> Mine doesn't work and im not sure why....
>
> Thanks for your help!
>
> -----Original Message-----
> From: Aleksandar Vojnovic [mailto:muadib@xxxxxxxxxxxxxx]
> Sent: Friday, May 18, 2007 3:02 AM
> To: bedul
> Cc: Bill Bolte; php-windows@xxxxxxxxxxxxx
> Subject: 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@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
>
>

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux