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
