[PHP-DB] text area handle

2001-09-11 Thread Sommai Fongnamthip

Hi,
I know this group for PHP-DB, but I could not find any help from 
PHP-Manual about Text Area Handle.  I'd like to accept input with 
multi-line text box (use textarea quote).  How could I get each row value 
in text area.  If someone have better idea to input multiple row in one 
time and retrieve into SQL Statement with PHP.

Example:
+---+
| ABC   |
| DEF   |   SearchFill value in text area and then press Search. 
(Put each 
value
| GHI   |   into SQL statement; using in Where clause)
+---+

Thanks
SF


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] text area handle

2001-09-11 Thread Timothy Aslat

On 2001.09.12 13:24 Sommai Fongnamthip wrote:
   I know this group for PHP-DB, but I could not find any help from 
 PHP-Manual about Text Area Handle.  I'd like to accept input with 
 multi-line text box (use textarea quote).  How could I get each row value
 
 in text area.  If someone have better idea to input multiple row in one 
 time and retrieve into SQL Statement with PHP.

the easiest option is to use the  explode function

$variable = 
line1 bulk stuff here ..
line2 bulk stuff here ..
line3 bulk stuff here ..
line4 bulk stuff here ..
line5 bulk stuff here ..
line6 bulk stuff here ..
line7 bulk stuff here ..
line8 bulk stuff here ..
line9 bulk stuff here ..
;
$lines = explode (\n, $variable);

that should work.


Cheers


-- 
Tim Aslat [EMAIL PROTECTED] | To err is human...to really foul up 
Spyderweb Consulting   | requires the root password.
http://www.spyderweb.com.au|   -- anon
Phone: +61 8 82270800  |
Mobile: +61 401088479  | #include disclaimer.h

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]